<< Click to Display Table of Contents >> Navigation:  Professional > Tools & Charts > XY Charts (TeeChart) > Combine Multiple Reports in XY Chart (TeeChart)

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:

 

 

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 Report, click Open, and then choose the following reporting parameters:

 

 

7.Click Go above User Reports.

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

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

 

 

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

11.From the Data pane, select the following:

 

 

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.