Microsoft Office Tutorials and References
In Depth Information
Using the Secondary Value Axis
Suppose you want to compare sales
and budgets on the one hand to an
industry price index on the other.
Sales are in the thousands of dollars
and the price index varies between zero
and one. You can’t display both sets of
data using the same axis.
Therefore, as this figure illustrates, you display the price index
using the secondary axis.
To do so, first add the data series to your chart. Then select the
data series. Sometimes, however, it’s difficult to select a specific
data series with your mouse, because the series hugs the X axis, or
because two data series overlap. If so, select any data series and
then press your Up-Arrow or Down-Arrow keys to move from series
to series until you select the series that you want.
Choose Format, Data Series. In the Data Series dialog, choose the
Axis tab and then choose the Secondary axis radio button. In the
same dialog, choose the Patterns tab and set the marker to none.
Then choose OK.
If practical, you can use colors, as shown above, to provide a visual
clue about which data series belong to which axis.