Plot a data series along a secondary value axis in a 2-D chart

When the range of values for different data series in a 2-D chart varies widely, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series.

  1. Click the data series you want to plot along a secondary value axis.

  2. On the Format menu, click Selected Data Series, and then click the Axis tab.

  3. Click Secondary axis.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!