EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Charts Add a Secondary Axis in Excel
 

Add a Secondary Axis in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated August 24, 2023

Add a secondary Axis in excel

 

 

Excel Add Secondary Axis (Table of Contents)
  • Example of Secondary Axis in Excel
  • Steps to Add Secondary Axis in Excel

Introduction to Excel Secondary Axis

The secondary Axis is an advanced visualization technique used in analytics. We know about basic charts, which implement a single axis. But what if we need two axes, i.e., adding a second data set on the existing chart. In that case, we’ll need a secondary axis. It is the first step in advanced analytics. We can add a secondary axis when we have two data sets in a single chart. This can be done in many tools and MS Excel as well. Excel has some basic and advanced graphical techniques which allow analysts to generate better insights from the graph. Adding a secondary axis is one of those advanced techniques in analytics.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Example of Secondary Axis in Excel

Below is an example that shows how the secondary axis works in Excel. For that, we need tabular data.

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

Add a secondary Axis in excel 1-1

This data has two datasets,e Sales and Target Achieved %. As shown below, the graph will look like this when a secondary axis is added.

Add a secondary Axis in excel 1-2

Sales amounts are shown in blue bars, whereas Targets are shown in the orange line represented in the vertical axis as shown above. Both the data sets are on Y-axis, but the second data set is added as a secondary axis to the same chart.

Add a secondary Axis in excel 1-3

Explanation:

  • While creating a secondary axis, both axes are vertically shown on the same graph. This is the most advanced technique used in analytics to show two data sets in the same graph. If both the data sets are important to show, we can use a secondary axis. This technique is often used in the financial model where we need a clear data picture.
  • Representation of the two data sets in a single chart usually helps in better visualization from a reader’s and an analyst’s point of view. Below are the steps to add a secondary axis to an existing chart.

Steps to Add Secondary Axis in Excel

We’ll use the above table to demonstrate the addition of a secondary axis in the chart.

Add a secondary Axis in excel 1-4

The data has “Month” in the first column and “Sales” and “Sales percentage” in the second and third columns, respectively. The secondary axis is based on a column chart. There are some steps to add a secondary axis.

  • The first step is to select the graph type directly from Insert > Combo and select the “Clustered column-Line on secondary axis,” as shown below.

Add a secondary Axis in excel 1-5

The chart can now be seen with two axes, as per the image below.

Add a secondary Axis in excel 1-6

  • The second method is using a column chart. We must plot a column chart first to show the sales in a graphical form.

Add a secondary Axis in excel 1-7

This chart is unclear as it does not show the sales percentage clearly. So to show it better, we can add another vertical axis. But this can be done by changing the chart type by going to Design > Change chart type, as shown below.

Chart Design - Change Chart Type

A dialog box will open like this where we have to go to “All charts”, as shown below.

All Charts - Add Axis

After the window opens, we must select the first clustered column chart.

First Column Chart

Now, the result is a secondary axis added to the chart.

Add a secondary Axis in excel 1-6

The target achieved in percentage can now be seen in a second vertical axis in orange. March has the lowest sales percentage whereas May has the highest, as shown in the chart.

  • The second step is a manual method. Initially, the column chart needs to be created first.

Add a secondary Axis in excel 1-7

Next, we must select the chart and click on the Format Tab, as shown below.

Format Tab

From the “Current selection” drop-down menu, we must select “Series Target Achieved %”.

Current selection

The goal fixed can be identified in column bars as shown below.

column bars

Now, we’ll press Ctrl+1 to open the format data series options.

 format data series

Now, we’ll have to select the “Secondary Axis” from the options, and the chart will look like this, as shown below. We are switching over from the Primary Y-Axis to Secondary Y-Axis here.

 format data series 1

The chart shows Target achieved % in a column bar with a secondary axis. But it is a bit complicated to read enough. So, we can change the chart type by going to Design > Change chart type.

Target achieved %

From the options, we have to go to “Combo” and change the “Target achieved %” to “Line” instead of “Clustered”.

Target achieved % - Column

Now the result is a chart with a dual-axis, as shown below.

Add Secondary Axis Excel

This way, we can add a secondary axis to an existing chart. The above steps are a bit different, but the output remains the same in all the steps. It helps in analyzing multiple data sets in an easier way. Apart from Excel, the Secondary axis can be added to Google Sheets, Power BI, Tableau, etc. But plotting the same in Excel is comparatively easy than in other visualization tools. Comparing the “Sales” is easier in the column chart, but we can compare profit margins from different months with this technique.

Things to Remember

  • The secondary axis requires a different chart from the primary axis chart.
  • This chart type is a clustered combo chart.
  • You can view secondary axis values from the right side vertical axis.
  • You can view the primary axis value from the left side of the axis.
  • Both the data sets need to have two-axis in a single chart.
  • The chart is based on a column bar chart.
  • Two data sets mean two columns from a single table.

Recommended Articles

This has been a guide to Adding a Secondary Axis in Excel. We discuss adding a secondary axis in Excel, a practical example, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Comparison Chart in Excel
  2. Grouped Bar Chart
  3. Excel Data Visualization
  4. Plots in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Add a Secondary Axis Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Add a Secondary Axis Excel Template

EDUCBA

डाउनलोड Add a Secondary Axis Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW