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

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.

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

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.