Show TOC

Function documentationDual Axis Trend Charts Locate this document in the navigation structure

 

If you are creating a chart that compares trends between disparate items, you can chart two or three series on the same chart, using two different Y axis scales and different chart types to differentiate the series for each axis. A dual axis allows you to more accurately represent the comparison of disparate items.

Prerequisites

The Graph Items dialog box is displayed.

Features

You can do the following in the Settings tab specific to creating a dual-axis trend chart.

  • If you are charting two disparate series, use Bar & Line. The first chart type and series follows the numbers on the Left Y-Axis. The next chart type and series follows the numbers on the Right Y-Axis.

  • If you are charting two similar series and one nonsimilar series, choose 2 Bars & 1 Line or 2 Stacked & Line.

  • If you are charting one separate series and two similar series, use 1 Bar & 2 Lines.

  • You can see which series will use which chart type by viewing the Type list next to the Selected items list. If necessary, you can move the items in the list to match the appropriate chart types.

  • You can specify minimum and maximum values to chart along the Y-axes.

  • You can add one label to the left Y-axis of the chart and another label to the right Y-axis.

Activities

  • To change the chart settings, click Graph items in the Graph section of the Settings panel.

  • To create a dual Y-axis, select Dual Y Axis option in the Settings tab of the Graph Items dialog box. Then specify a chart type and select the items to graph.