Combine Multiple Reports in XY Chart

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > XY/XYZ Charts > XY Charts (TeeChart) >

Combine Multiple Reports in XY Chart

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

 

1.After logging into a database, click Reports in the Open group of the EQuIS Home Toolbar.

2.Select the Analytical Results Report and click Open.

3.Click the ellipses and select the following reporting parameters:

 

Parameters

Selection

Location Individual(s)

B-38

Sample Date Range Start

01/1/1997

Matrix(es)

WG

Result Analyte Individual(s)

71-43-2 BENZENE

Result Unit

ug/l

 

4.Click Go Arrow right - 08(1) 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 Report, click Open, and then choose the following reporting parameters:

 

Parameters

Selection

Location Individual(s)

B-38

Sample Date Range Start

01/1/1997

Sample Date Range End

01/1/1998

 

7.Click Go Arrow right - 08(1) above User Reports.

8.Hold down the Shift key on the keyboard and click XY Charts xy.chart.button in the Toolbar below the Water Levels tab to create a chart for this data.

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

 

Parameters

Selection

Dataset

Water Levels

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.

11.From the Data pane, select the following:

 

Parameters

Selection

Dataset

Analytical Results

X-Axis

SAMPLE_DATE

Y-Axis

RESULT_VALUE

Group Series By

CHEMICAL_NAME

 

12.Click Add Series in the Data pane to display the Analytical Results in the XY Chart.

 

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.

 

To associate a series with a particular axis:

 

1. Change the graphing options for B-38 (the water level).

2. Click B-38 in the legend to deselect and clear the association with the Water Level.

3. Right-click B-38 in the legend and select Advanced.

4. Select All B-38 Series from the sub-menu.

 

This reselects this series so the advanced data parameters can be selected from the Advanced tab.

 

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 the desired attribute for edits) rather than clicking the ellipse to open sub-menus.  

 

5.Click the Advanced tab at the bottom of the Data pane, scroll down to the VertAxis row in the Misc section, and note the default VertAxis value is Left.

6.Change the VertAxis value to Right.

 

This action associates the B-38 Water Level series with the right-axis so it can be viewed along with the Analytical Result trend lines.