The XY Charts feature generates two-variable scatter, line, pie, column, and stacked-line charts. For example, it can generate time-series charts from SAMPLE_DATE/REPORT_RESULT_VALUE of ARII results, or charts of various types using crosstab results (more information is available here). Chart types other than scatter, line, pie, column, and stacked-line are listed in Add Series As/Type but have not been fully implemented; unsupported chart types will be marked by an asterisk (*).
See the Office Hour video on Chart Features in EQuIS Professional 7 here.
To open the XY Charts interface, first run a report (e.g., Analytical Results II), then click the XY Charts button.
This example creates a chart for analytical results over time:
1.When logged into EQuIS Professional, click the Reports button (for this example, the 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.Reporting selections can be made at each node. If no selections are made for a node, then all values will be returned. For this example, choose Location/Individual(s)=B-30 and B-31, Sample/Matrix(es) = WG, and Result/Analyte/Individual(s)=ACETONE and BENZENE. 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 create an XY Chart, click the XY Chart button on the toolbar.
6.The XY Chart menu panel will display on the right-hand side. Make the following selections and then click the Add Series button in the Data Toolbar of Data pane:
a.Dataset = Analytical Results II (by default)
b.X-Axis = SAMPLE_DATE (by default)
c.Y-Axis = REPORT_RESULT_VALUE (by default; selected column must be a field containing numbers (null/text values will be ignored)
d.Group Series By = SYS_LOC_CODE
e.Group Charts By = CHEMICAL_NAME
7.Click the Add Series button .
The above result in two charts with ACETONE being the active chart.
To clear all of the charts, click the Clear Series button on the toolbar of the Data tab after charts are created.
After charts are created, click on Save Parameters on the toolbar of the Data tab to save the chart parameters used to create the charts as an *.xml file.
•Saved parameters are associated with the loaded dataset or charting data. Be sure to use the same report creating the dataset when loading the saved parameters later. If a report is opened more than once and several results or datasets exist, you can change the dataset (e.g. change it from Analytical Results II to Analytical Results II-1) but still use other parameters after loading the chart parameters.
•You can slightly edit the saved xml file in a text editor, if needed.
After charts are created and saved, click on Load Parameters on the toolbar of the Data tab and select the saved parameter *.xml file to load the chart parameters, and then click on Add Series to re-create the charts. See the above notes.
Copyright © 2023 EarthSoft, Inc. • Modified: 06 Dec 2022