Crazy Tech Tricks

  • Home
  • How To
  • Top 10
  • Android
  • iOS
  • Windows 10
  • Microsoft Office

How to Add a Secondary Axis in Excel – 3 Best Methods

Last updated on January 15, 2022 by Ekaant Puri Leave a Comment

You can add a secondary Axis in Excel by following these three methods. You can plot multiple data series on a same chart. Also display both column and line in same chart.How to Add a Secondary Axis in Excel

Secondary Axis is a more sophisticated method of visualizing data in analytics. A few examples include sales versus average cost, performance against conversion rate, sales versus profit, and so on. We are familiar with simple charts that use only one axis. If a second dataset is needed, it will require the formation of an additional axis in the chart. To help you get started, we will explain why you need to add a secondary axis in Excel

Why Add a Secondary Axis in Excel?

By adding a second vertical axis, we can enable multiple data series to be plotted on the same chart, increasing the flexibility of our data visualization. In addition to multiple charts, a secondary axis can be used to represent and visualize multiple data sets. This feature makes it very easy to compare data sets measured in different units or scales of comparison.

Read more: How to Insert Multiple Rows in Excel

Method 1. How to Add a Secondary Axis in Excel

The procedure outlined below will be beneficial for any MAC, PC, or laptop. Therefore, with these steps, two different things can be compared on an X and Y-axis.

  1. To begin, choose the line (or column) that corresponds to the second data series.
  2. After selecting an element on a chart, the Chart Tools tab appears in the ribbon.
  3. Click on the Format option.
  4. There should already be a series listed in the Current Selection box on the far left.
  5. Choose a format.
  6. Click Secondary Axis under Series option.
  7. Like the primary axis, this second axis can be changed after installation. You can customize the text by creating a unique axis label and selecting a different format for the numbers.
  8. After that, the right-side secondary axis will be visible, and Excel will even make some reasonable assumptions about scale for you automatically.

Read more: How to Use Exponents in Excel

Method 2. Using the Recommended Chart

In every version of Excel, you may easily add a second axis. If you have Excel 2013 or higher (Excel 2016, 2019, and Office 365), you can build charts using the suggested chart function. This function instantly analyses your data and gives you a few choices.

  1. Choose a Datesheet.
  2. Click on the Insert tab.
  3. You will see the Insert Chart dialog box if you select the Recommended Charts option in the Charts group.
  4. Select a chart with a secondary axis from the left pane
  5. Choose OK.

Read more: How to Export Outlook Calendar to Excel

Method 3. Manually Add a Secondary Axis in Excel

This is how you manually add a secondary axis in Excel:

  1. Choose a Data set.
  2. The Insert tab will appear. Click on it.
  3. Select the Insert Columns or Bar chart option from the Charts group.
  4. Select “Clustered Columns” from the drop-down menu.
  5. Now, Click on the profit margin bar. The tab key can be used to choose any of the blue bars if these are too small to pick.
  6. Select ”Format data series”.
  7. In the format series, click the Secondary Axis option. In this, you will get two bar option.
  8. Now, select the Profit margin bar> ‘Change Series Chart Type’.
  9. Set the chart type from ‘Line with Markers’ to ‘Profit Margin’.

There you go, it’s as simple as that. You will see a secondary axis and a line chart in your chart.

Read more: How to Group Worksheets in Excel

Conclusion

The above procedure may differ slightly depending on the kind of Excel program you are using. Although if the sequence of these procedures differs, the final result is the same throughout. Besides Excel, you can apply the Secondary axis to Google sheets, Power BI, Tableau, and other similar programs. Therefore, we hope that this blog will benefit you, and we appreciate your time and effort in reading it.

Was this article helpful?
YesNo

Filed Under: HOME, HOW TO, Microsoft Excel

About Ekaant Puri

I love to write about the latest technology. My work is to write on HowTo, Top 10 and tech solving topics.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

DMCA.com Protection Status

Recommended

  • How to Change Brightness on Windows 10 – Adjust Brightness – Top 9 Best Methods
  • What Does 1 Tick mean on WhatsApp – 2 Tick & Blue Tick Meaning
  • How to Reduce Data Usage While Tethering to PC/Laptop Browsers – Best Methods for Internet Browsers
  • Latest 200+ Happy New Year 2018 Pics/DP – Download Now
  • How to Take a Screenshot on a Mac – Full Screen or Selected Area

We’re Social

Facebook  Twitter  Instagram  Pinterest  YouTube

Crazy Tech Tricks © 2015-2022. All rights reserved. All logos and trademarks belongs to their respective owners.

  • About Us
  • Disclaimer
  • Privacy Policy
  • Cookie Policy
  • Advertise With Us