Trend Chart Basics
Copyright © 2018 EarthSoft, Inc • Modified: 12 Dec 2018
The Trend chart feature generates a time series chart of either actual data or averaged data, its polynomial trend and a regression analysis chart. For example, it can generate time-series charts from SAMPLE_DATE/REPORT_RESULT_VALUE of ARII results, MEASUREMENT_DATE/EXACT_ELEV of Water Level results or date/value of any crosstab results (more information is available here).
The Trend form consists of two input parameter areas (Data Columns and Variables areas), two chart areas, and one statistics results area (Figure 1).
Figure 1: Trend Chart Form
Dates of Data Columns: defines a field of date-type from the source data as X axis (not immediately updating charts).
Values of Data Columns: defines a field of double-type from the source data as Y axis of (not immediately updating charts).
Units of Data Columns: defines the unit of Y axis and is temporarily not used.
Use 'REPORT_RESULT_VALUE' (or ' .. ' determined from source data) of Available Parameters of Data Columns: defines that chart data come from all the source data of all analytes associated to the X/Y axis.
Use unique values in column of Available Parameters of Data Columns: defines that chart data come from the source data of a selected analyte associated to the X/Y axis.
Annualize Parameter of Variables: defines an analyte when the Use unique values in column is checked.
Polynomial Degree of Variables: clicking it generates the best-fit polynomial trend line.
Integer box (on right side of Polynomial Degree) of Variables: defines polynomial degree.
Calculate Average By of Variables: checking the box generates a time series scatter trend chart based on actual data otherwise based on averaged data if it is unchecked.
Day/Week/Month drop-down list (on right side of Calculate Average By) of Variables: defines if the source data of the charts are averaged by day, week or month when the Calculate Average By is checked.
Start of Summer of Statistics: defines the start date of a year for calculating yearly averages of the chart source data and updates its below statistic (Year/Average/Count) table.
Year/Average/Count table of Statistics: displays the statistic results of the chart source data.
The year factor of the scatter chart of either actual or averaged data has been ignored when chart data are prepared, as if all the data of different years occur in the same year (Trend form arbitrarily uses Year 2000). That is why Year is not displayed in the X axis of the scatter trend chart.
If the Calculate Average By is checked, the source data of the scatter chart are first averaged by the selection of Day/Week/Month drop-down list and then various years of X axis date values are replaced with 2000.
The scatter-line chart series, Data (or Data Avg), is generated from either actual or averaged data and its linear regression line (red Regression) is also plotted and the regression equation is displayed with blue color.
The scatter-line chart series, Residuals, is generated from the differences between either actual or averaged data and the polynomial trend line, and its linear regression line (blue Regression) is also plotted, and the Residuals regression equation is displayed with red color.
First, run a report (e.g. Analytical Results II) to prepare the source data of Trend charts, and then click the Trend chart button to open Trend form (Figure 1).
Trend charts may be created as follows:
1.When logged into EQuIS Professional, click the Reports button (for this example, test Springfield database is being used; other locations, matrices, and analytes may be substituted based on the contents of your database).
2.Select the Analytical Results II Report, and click Open.
3.Input parameter selections can be made at each node. For this example, choose Location/Individual(s)=B-30, Result/Analyte/Group(s)=VOCS. Leave all other values as default (no selection).
4.Run the report by clicking the Go button. Results will be returned in grid format.
5.To open an Trend chart form, click the Trend chart button in the toolbar (Figure 1).
6.To create the charts with the averages of ACETONE and its trends, select ACETONE in Annualize Parameters (Figure 1).
1.Right-click the point, where you want to insert an annotation, of a chart area to open a menu window, select Add ... > Annotation, and the Trend form adds an annotation with a default name.
2.Right-click the added annotation to open its properties editor, modify the value of Text to a desired string, e.g. My annotation, and hit Enter key to review the change in the chart. XValue/Yvalue can be edited to adjust the location of the annotation. If editing is finished, hit OK of the editor.
If multiple lines are needed, use a space + \n + a space in the string, e.g. My annotation \n an outlier will show
Tips: if some editions seem to not be working, try to increase or decrease XValue or YValue by 1 and hit the Enter key. For example, extend Font, modify Bold to True and the font of the annotation may not be applied at this point. Increase XValue by 1 and hit the Enter key, and the font of the annotation is changed to bold.
1.Right-click the point where you want to insert an image, of a chart area to open a window, select Add ... > Image, select an image from a folder to add the image.
2.Right-click the added image to open its properties editor, extend Symbol, change Size to the desired values. Note the changed size is not immediately reflected on the chart. Slight increase or decrease XValue or YValue, hit Enter key, and the image with modified size is updated in the chart. If editing is finished, hit OK of the editor to close the editor.
Right-click anywhere in a chart area to open a menu window. Select 'Selected chart' Properties to open the chart editor.
Example 1 - Make the title bold:
Right-click anywhere of the top chart area, click (Collection) of Titles to open ChartTitle Collection Editor, extend Font and modify the value of Bold to True in ChartTitle Collection Editor.
Example 2 - Add a title to the top chart:
Right-click anywhere of the top chart area, click (Collection) of Titles to open ChartTitle Collection Editor, click Add in ChartTitle Collection Editor, select the added title, enter a title to the value of Text.
Right-click an item of the chart legend to open the Chart Series Style editor of the selected series legend, e.g. click Symbol of the editor and change Shape to Diamond etc.
Right-click the Trend item of the chart legend to open the 'Trend' Properties editor, e.g. click Color of the editor and change it to red etc.
Right-click the X or Y axis area to open 'X axis' or 'Y axis' Properties editor, e.g. modify the value of Title and then hit the Enter key etc..
Right-click anywhere of a chart area to open a menu window, select Save As... > Image, and select a folder or change an image type if needed to save the chart to the computer.
Right-click anywhere of a chart area to open a menu window, select Copy Chart to copy the bmp-type chart into the computer clipboard. After copying the chart, paste it to Word, Excel etc.
Email/Save/Print a Chart
Right-click anywhere on a chart area to open a menu window, select Send To... > Mail Recipient/My Charts/Printer to email the chart, save the chart to ...\My EQuIS Work\Charts\..., or open the chart in the printer window of the computer.
Double-click anywhere on a chart area to open the Chart Editor (linked to XY Chart Basics: Chart Editor).