Creating 2 Axes Charts

There are situations when you want to create a mix chart type with 2 axes. For example, one data set is high and the other is low.

 

Right Click on the Qty Bar chart to Change Series Chart Type.

 

Select Line Chart Type and click OK.

 

Select on Line Chart and select on Format Data Series.

 

Select Plot Series On: Secondary Axis

 

Line chart with Secondary Axis in right hand side.