Notes about creating dual-Y graphs

When you create dual-Y graphs, follow these guidelines:

• You can use the dual-Y facility with the following types of graph:

  • bar

  • line

  • area

  • combination

The figure below shows an example dual-Y bar graph with a Y axis for sales and a second Y axis for costs.

Figure 8-6 Example worksheet and dual Y graph

Description of the illustration gr_dualy.gif

• Dual-Y graphs require at least two items.

• By default, the series are displayed in the following way:

  • series one is displayed on the Y1 axis

  • series two is displayed on the Y2 axis

  • all subsequent series are displayed on the Y1 axis

In the figure above, the Y1 axis represents sales on the scale 0 to 1 million. The Y2 axis represents costs on the scale 0 to 50,000. You can therefore analyze sales and costs side by side even though they use different scales.