Well Trend Charts
Copyright © 2018 EarthSoft, Inc • Modified: 23 Nov 2018
To create a Well Trend Chart, complete the following steps.
1.Run the Water Levels Extra Fields Report.
a.Select a group.
2.Select XY Charts to use the XY Chart.
3.Group Series by: Non Selected.
4.Group Charts by: SYS_LOC_CODE.
5.Select Go for the chart.
6.Right-click the exact elevation to change the legend; choose All Series.
c.Change the title to Water Level Elevation.
d.Change the Vertical Axis from Left to Right.
7.Change the title on the right-axis by right-clicking and choosing Advanced > All Charts. Under Misc select Axes> Right> Title> Text. Enter the desired title. It is also possible to adjust the font.
If the Analytical Results Report has already been run, it is possible to add the data series to the chart by selecting that report output. To run the Analytical Results II Report, follow the steps below.
1.Open the Analytical Results Report.
2.Open the Trend Plot parameter file that was previously created.
3.Open the Well Results chart file to capture the Quarterly WG Wells and data sets.
a.Location Group: Select desired group.
b.Sample Type: N
c.Change date to the current date.
e.Result Type: TRG
f.Detection Limit Multiplier: 1.0
g.Reporting Detection Limit
h.Reportable Result: Yes
4.Use the XY Chart by clicking the XY Charts icon.
5.When the Analytical Results XY Chart-1 opens, select a Load Configuration file. Open the saved config file, which will populate the fields in the data tab on the right.
c.Y-Axis: REPORT_RESULT_VALUE. Non-detects are plotted at full detection limit.
d.Group Series By: CHEMICAL_NAME
e.Group Charts By: SYS_LOC_CODE
f.Add Series As: Line
The series needs to have the default naming scheme for the template to be applied to the series in the chart.
6.Format the SYS_LOC_CODE headers. The template will format the title on all charts. Format the Header (SYS_LOC_CODES) by right-clicking and choosing Advanced> All Charts> Advanced > Header > and select the text type.
a.It is also possible to apply subheaders: Advanced > All Charts > Advanced > Subheader > and select the text type.
7.Format the line thickness. Right-click and choose Advanced > All Series > Advanced > Appearance > Brush > Linepen > and select the width.
8.Format the symbology for the lines by right-clicking and choose Advanced > All Series > Advanced > Appearance > Linepen > and select the line style.
a.To turn on all line styles: Misc > Pointer > and set visibility to True.
9.Adjust the titles for the different axes. Right-click on the axis and choose Advanced > All Charts. Then select Misc > Axes > Left > Title > Font.
10.Remove the title on the X-Axis by right-clicking and choosing Advanced > All Charts > Advanced > All Charts. Then select Misc > Axes > Bottom > Title > Visibility and set visibility to False.
11.Edit the legend files by right-clicking on each value and choosing Advanced > Edit Data Series. Then select Misc > Title > Menus and remove desired tables.
The chart is now be ready to print or export.