Add a Secondary Axis in Excel

How to Add a Secondary Axis in Excel?

Secondary Axis is nothing but the two different data sets which cannot show in a single axis requires separate axis only, so this axis is called “Secondary Axis” in an excel chart.

You can download this Add a Secondary Axis Excel Template here – Add a Secondary Axis Excel Template

For example, look at the below data.

Add a Secondary Axis in Excel Example 1

Here we have two different data sets for each month. The first data set is to represent “Sales” numbers for the month, and it is to represent “Target Achieved %” for each month.

Both these numbers are not related to each other, so it is the wrong thing to show both the numbers in a single-axis itself.

If we show both the numbers in the single-axis, below is the chart example.

Example 1.1.0

From the above, can you tell what the target achieved percentage is???

The problem here is the axis numbers of “Sales” are too high and the numbers of “Sales Conversion” is also less, so we cannot show the trend with a single axis.

Since both the numbers are plotted under a single-axis, we cannot tell the numbers of the smaller data set; we don’t even recognize there is another data with the chart.

For this, We can add the secondary axis in multiple ways; we will see each way separately. Below is the image of the secondary axis chart.

Add a Secondary Axis in Excel Example 1.16

As we can see on the right hand, there is another vertical axis showing the percentage of sales conversion. Now we will see how to add a secondary axis in excel.

Method #1: Simple to Add Secondary Axis in Excel

  • Once you have applied the column chart, we will get a chart like this.
Example 1.1.0
  • We cannot see the sales conversion percentage column, so select the chart and go to the Design tab. And from the design tab, click on “Change Chart Type.”
Add a Secondary Axis in Excel Example 1.2
  • This will open below the dialogue box.
Example 1.3
  • Choose “Recommended Chart.”
Add a Secondary Axis in Excel Example 1.4
Example 1.5
Add a Secondary Axis in Excel Example 1.6

It looks easy, but we have one more way i.e., manual way. We will see the method below.

Method 2: Manually Add Secondary Axis to the Chart

In this method, we cannot select “Sales Conversion Percentage” columns directly, so choose the chart and click on “Format.”

Example 1.7
  • This will select the “Target Achieved %” column bars.
Add a Secondary Axis in Excel Example 1.8
  • Now press Ctrl + 1 to open the FORMAT DATA SERIES option.
Example 1.9
  • In this window, select “Secondary Axis.”
Add a Secondary Axis in Excel Example 1.10
  • We can get the following chart.
Example 1.11

As we can see, the chart. It has given the Target Achieved % in column bar with a secondary axis, but reading both the data in columns only isn’t the ideal thing, so we need to change the chart type to the line chart.

  • Select the Target Achieved % column and click on Change Chart Type.
Add a Secondary Axis in Excel Example 1.13
Example 1.14
  • We will have a secondary chart like the below one.
Add a Secondary Axis in Excel Example 1.15

Now from this chart, we can easily see the trend from one month to another month.

Things to Remember

  • The secondary axis always requires a different chart type from the primary axis chart.
  • This type of chart is also called “Combo Chart.”
  • Secondary axis numbers can be read from the right side vertical axis.
  • Primary axis numbers can be read from the left side vertical axis.

Recommended Articles

This has been a guide to Secondary Axis in Excel. Here we discuss how to add a secondary axis in an excel chart along with an example and downloadable excel template. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>