• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • iOS
  • Mac
  • Android
  • Office
  • Windows
  • iOS
  • Mac
  • Android
  • Office

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
    • Microsoft Excel Has Blocked Macros from Running
      Fix: Microsoft Excel Has Blocked Macros from Running Error
      • 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

Primary Sidebar

Twitter
Facebook



Recent Posts

  • How to Set Static IP Address in Windows 11
  • Compass Not Working on iPhone: How to Fix?
  • How to Remove Login Password in Windows 11
  • Fix: Do Not Disturb Keeps Turning Automatically on iPhone
  • Downloads Folder Missing from Finder Sidebar on Mac



About | Privacy Policy | Disclosure | Terms | Contact
© 2023 Techbout.com · All Rights Reserved