How To Add Secondary Axis In Excel

5 min read|Last Updated: January 6th, 2024|Categories: excel|
table of content

 

There are different types of charts available on Excel which can help the user make different useful reports. Sometimes you will need to combine two types of Excel charts together to make a better report. That’s when you need to know how to add secondary axis in Excel.  

When is a secondary axis required? 

To explain more specifically, assume you have two different data column series, one is about monthly sales and the other is the percentage of growth you had in each month. Therefore, you have something like the following table: 

To make a chart, you first need to have a table with different values.
To make a chart, you first need to have a table with different values.

To make a chart for this table, you will select the table and choose a “Chart” from the “Insert” menu. Normally, the “Clustered Column” is the default chart on Excel. However, in the most recent versions of Excel, it is possible to choose the “recommended chart” which might have the secondary axis as a default. But right now, we assume we have a simple clustered column chart. Which is like this: 

A sample of a chart which needs to have a secondary axis to become more clear and readable.
A sample of a chart which needs to have a secondary axis to become more clear and readable.

But that’s not the type of report you should have on such data. A horizontal linear chart is needed to show the percentage of growth each month. That’s when you need to add a secondary axis in Excel. Don’t worry, it’s so simple and can be done with a few steps.