From the menu select ‘Insert’ and then ‘Chart’, select the primary chart type.

After adding the different values in the ‘Chart Data’ window, right click on the series which should be on the secondary vertical axis.

RightClickSeriesProperties.PNG
To change the Chart Type, select ‘Change Chart Type…’

For the secondary vertical axis, select ‘Series Properties…’

SeriesProperties.PNG
Then select ‘Axes and Chart Area’ in the left window, then select the Secondary radio button under ‘Change series axis position’.

Share This