Combining different chart types on Single Chart – Secondary Axis

When data set you are comparing in excel varies too much, graphical comparison becomes difficult. A Secondary axis can easily be inserted in chart using inbuilt options of excel.

Sample chart below is having two data set and its clearly visible that input data is hardly visible. Here we can use an secondary axis.

Secondary axis

Insert Secondary axis

  1. Select data and create a chart.Secondary axis 1
  2. Right click on format data series. Select Secondary axis.Secondary axis 2
  3. Now right click on series with larger values. Select change series type. Change to line type for this series.Secondary axis 3

Final Chart will look like this

Secondary axis 4