Combine Multiple Reports in XY Chart

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > XY/XYZ Charts > XY Charts >

Combine Multiple Reports in XY Chart

This exercise demonstrates how to combine data from two different reports into one XY Chart, specifically, data from the Analytical Results II Report with data from the Water Levels II Report (allowing water levels on analytical results to be viewed).

 

1.Log in to a database. Click Reports in the Open group of the EQuIS Home Toolbar.

2.Select the Analytical Results II Report and click Open.

3.Select the following reporting parameters:

 

Parameters

Selection

Location Individual(s)

B-30

Sample Date Range Start

01/1/2007

Sample Date Range End

01/1/2008

Matrix(es)

WG

Result Analyte Individual(s)

71-43-2 BENZENE

Result Unit

ug/l

 

4.Click Go above User Reports.

5.Click Reports in the Open group of the EQuIS Home Toolbar to select a second report.

6.Select the Water Levels II Report. Click Open and choose the following reporting parameters:

 

Parameters

Selection

Location Individual(s)

B-30

Sample Date Range Start

01/1/2007

Sample Date Range End

01/1/2008

 

7.Click Go above User Reports.

8.Click XY Charts in the Toolbar below the Water Levels II tab to create a chart for this data.

9.In the Data pane, make the following selections:

 

Parameters

Selection

Dataset

Water Levels II

X-Axis

MEASUREMENT_DATE

Y-Axis

EXACT_ELEV

Group Series By

SYS_LOC_CODE

 

10.Click the Add Series icon in the Data pane to display the XY Chart.

 

Note: The left Y-axis is reversed because EQuIS Professional monitors Y-axis values that end with 'elev' or 'depth' and automatically set it as reversed.

 

11.From the Data pane, select the following:

 

Parameters

Selection

Dataset

Analytical Results II

X-Axis

SAMPLE_DATE

Y-Axis

REPORT_RESULT_VALUE

Group Series By

CHEMICAL_NAME

 

12.Click Add Series in the Data pane to display the Analytical Results in the XY Chart (Figure 1).

 

Note: The left-Y axis is not reversed because report_result_value is added after exact_level and report_result_value requires that the left-Y is not reversed.

 

Figure 1

Figure 1

 

Figure 1 indicates that the Water Levels and the Analytical Results series do not display well together in the graph. Trends from the Analytical Results Report are not immediately discernible. To make the chart easier to use, associate the Water Levels series with the right-axis or secondary Y axis.

 

Associate Series with a Particular Axis or Associate Water Level with Right-Axis

 

1.Click B-30 in the legend to deselect.

2.Click View > Advanced > All {B-30}, which re-selects the deselected series of all the charts, and opens the Advanced tab for users to edit.

3.Modify (scroll down to) Misc > SecondaryY from False to True in the Advanced tab, which associates the B-30 Water Level series with the right-axis so it can be viewed along with the Analytical Result trend lines (Figure 2).

 

Notes:

The Active Chart, All Charts, and All Series options may also be selected for editing chart attributes. If in All Chart editing mode, apply changes directly in the Advanced list (by expanding chart items to navigate to desired attribute for edits).

SecondaryY is used only when there is a primary or left Y-axis and a desire for a secondary Y-axis to display another series. See Example 3 in the help article Edit Axes if you want to have only right Y-axis.

 

Figure 2

Figure 2