Adding a secondary Y axis scale

A secondary Y axis scale is the secondary scale on which specifically selected series can be plotted. A secondary Y axis can be added to bar, line, area and combo charts.

By default, all series plot against the primary Y axis.

To add a secondary Y axis scale:

  1. On the Chart tab, in the Series group, select a series.
  2. Click Scale on 2nd Y Axis.
  3. Click Save Changes.