<< Click to Display Table of Contents >> MOVING A SERIES TO THE 2Y AXIS 

You can plot series data against a secondary axis (2Y axis). It is helpful to use the 2Y axis when the range of values vary greatly for different data series or when you are showing mixed types of data (e.g. price and volume) where one or more series is plotted against the 2Y axis. A series must be displayed as a line to be plotted on the 2Y axis.
APPLIES TO: MARIMEKKO, BAR MEKKO, AREA, STACKED BAR, CLUSTER BAR, LINE CHARTS
To plot a series on the 2Y axis:
1.Right click the series you wish to plot on the 2Y axis. For some charts, the series must first be plotted as a line before it can be plotted to the 2Y axis.
2.Choose the Plot on 2Y axis icon in the Series Context Menu