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.[adsenseyu2]
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.
Insert Secondary axis
- Select data and create a chart.
- Right click on format data series. Select Secondary axis.
- Now right click on series with larger values. Select change series type. Change to line type for this series.
Final Chart will look like this
