• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Office
Home » Excel » How to Add Secondary Axis in Excel Chart

How to Add Secondary Axis in Excel Chart

By: Waseem Patwegar

Adding a Secondary Axis in an Excel Chart makes it possible to accurately represent mixed type of data in a Bar Chart Format. You will find below the steps to Add Secondary Axis in Excel.

Add Secondary Axis in Excel Chart

Add Secondary Axis in Excel Chart

If you take a look at the Data Set as listed below, you will notice that Monthly Sales are measured in Dollars, while the Profit earned is measured in percentage (%).

Sales Data For Bar Chart in Excel

When this type of mixed data is used to create a Bar Chart in Excel, we end up with a Chart that does not represent the complete information.

Single Axis Chart in Excel

In above Chart, the blue bars represent Monthly Sales ($) and the tiny Orange bars represent Profit Margins (%).

While this Chart does provide fair representation of Monthly Sales figures, it hardly provides any useful information about Monthly Profits earned.

This deficiency in an Excel Chart can be easily fixed by adding a Secondary Axis to accurately represent the under-represented data (Profit margin in this case).

So, let us go ahead and take a look at two different methods to add Secondary Axis in a Bar Chart.

1. Add Secondary Axis Using Recommended Charts Option in Excel

The simplest way to Add Secondary Axis to Chart in Excel is to make use of the Recommended Charts feature as available in Excel 2013 and later versions.

1. Select the Data Set > click on the Insert tab > Recommended Charts option in the ‘Charts’ section.

Recommended Charts Option in Excel

2. In the Insert Chart dialog box, go through recommended Charts in the left pane and select the Chart with a Secondary Axis.

Select Chart With Secondary Axis in Excel

3. Click on OK to close the dialogue box and you will end up with an Excel Chart having a primary and secondary axis.

Excel Chart With Secondary Axis

As you can see in above image, adding a Secondary Axis has led to a better representation of both Monthly Sales and Profit Margins.

2. Manually Add Secondary Axis to Chart in Excel

If you do not find a Chart with secondary axis, you can manually add a secondary axis by following the steps below.

1. Select the Data Set > click on the Insert tab and select 2-D Clustered Column Chart option.

Insert Clustered Columns Chart in Excel

2. In the inserted Chart, select the Minor bars (Profit bars). If the minor bars are tiny, select the Major or Larger bars (Sales Bars) and hit the Tab key.

Select Minor Bars in Excel Bar Chart

3. After selecting the Minor Bars, right-click and select Format Data Series option.

Format Excel Chart Data Series

4. In the right-pane that appears, select the Secondary Axis option.

Add Secondary Axis to Chart in Excel

This will add a secondary axis to the existing bar chart and you will end up with two overlapping bars.

5. Now, right-click on the Profit margin bar and select Change Series Chart Type option.

Change Data Series Option in Excel Charts6. In Change Chart Type dialog box, change the Profit Margin Chart type to Line with Markers.

Change Chart Type Option in Excel
7. Click on OK to save the changes.

You will now have a Bar Chart with a Primary Axis representing Sales Data ($) and a Secondary Axis representing Profit Margins (%).

Excel Chart With Secondary Axis

How to Remove Secondary Axis from an Excel Chart?

All that is required to remove secondary axis in an Excel Bar Chart is to select the secondary axis and press the Delete key.

1. Select the Secondary Axis by clicking on it.

2. Press the Delete Key on the keyboard of your computer

Alternately, you can also right-click on the secondary axis and click on the Delete option in the contextual menu.

Related
  • How to Create Gantt Chart in Excel
  • How to Create Waterfall Chart in Excel

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar

Twitter
Facebook



Popular Now

  • How to Reduce Cellular Data Usage on iPhone
  • How to Backup Registry in Windows 11/10
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Create Local Account in Windows 11



Gadget Guide

  • Mac vs PC Comparison: Should You Buy Mac or PC
  • Chromebook vs Windows Laptop
  • Kindle E-Reader Comparison | Which Kindle to Buy
  • iPad vs iPad Pro Comparison
  • Advantages of Chromebooks

About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2022 @Techbout.com · All Rights Reserved