How to Add Secondary Axis in Excel Charts

If you look at the below two charts, in the first chart you have two different data column series but the axis is the same.

how to add secondary axis excel chart

The problem with the first chart is, both of the series have a different data range but the same axis.

But in the second chart, you have a different axis for both of the data series which makes it easy to understand.

Adding a secondary axis in a chart is pretty simple.

Steps for Adding a Secondary Axis in Your Chart

Here are the simple steps you need to follow to create a dual axis.

  • Select the data series for which you want to add a secondary axis.
select the data series to create a secondary axis
  • Right Click on it and go to Format Data Series ➜ Series Option ➜ Activate Secondary Axis.
  • Now, you have two scales in your chart.
your final excel chart with secondary axis

Want to Become PRO in Charting?

There are a lot of charts which you can create in Excel with a single click, but, apart from those, there are few advanced charts which you can use in specific way and can help you to stand out from the crowd.

Alternate Method

You can also do it in this way:

  • Select the data series for which you want to add a secondary axis.
  • Go to Format Tab ➜ Current Selection ➜ Format Selection ➜ Format Data Series ➜ Series Option ➜ Activate Secondary Axis.
click on format selection to add secondary axis to an excel chart

More on Charting

Content Protection by DMCA.com
2018-09-27T10:31:21+00:00
  • ratanak says:

    Cool

  • Inet Kemp says:

    Cool post

  • >