Adding another axis to an Excel chart makes it possible to accurately display the composite chart data in bar chart format. Here are the steps for adding a secondary axis in Excel.
The visual elements that we use most to convey data to the other party are undoubtedly graphics. When we want to show the values that are very different from each other in a bar or column chart, one series looks very clear due to this difference, while the other series will be very small, so we cannot see it clearly. In this case, we need a second axis to make the graph more understandable.
Add the Secondary Axis in Excel
The easiest way to add secondary axes in Excel is to use the recommended charts feature available in Excel 2013 and later versions; you can easily add secondary axes with the recommended features.
- Now select one of the bars showing the amount, right-click, and select the “format data series” command from the menu.
- In the window that appears, activate the “secondary axis” option in the “serial drawing location” section and click the “close button.”
- Notice that the left-hand and right-hand axes have changed in the graph. Now, finally, select the amount text in the chart data labels section, right-click and select the “change serial chart type” command.
- Select the line chart in the window that appears and click the ok button. The newly formed graphic allows us to show two values together and see the harmony between them.
That’s how easily you can add a secondary axis.
How to Remove the Secondary Axis in an Excel Chart?
To remove the secondary axis from the Excel Bar Chart, all it takes is to select the secondary axis and press the Delete key.
- Click on it and select the secondary axis option.
- Press the delete key on the keyboard.
- Alternatively, you can right-click the secondary axis and click the Delete option in the context menu.
FAQ About How to Add Secondary Axis in Excel
Click anywhere in the chart where you want to add axis titles. On the Layout tab, click Axis Titles in the Tags group and add a title.
Also known as the x-axis of the chart, the horizontal axis shows text labels instead of numerical ranges, and the y-axis offers fewer scaling options than those provided for the vertical axis of the chart.
Two perpendicular lines are taken on the 2-dimensional coordinate system. One of them is the “x-axis,” while the line perpendicular to it is the “y-axis.”
It means the axis that constitutes the vertical dimension in a system of axes and usually represents the dependent variable.
The horizontal axis is called the x-axis or the abscissa axis; the vertical axis, the y-axis is called the ordinate.
Conclusion on How to Add Secondary Axis in Excel
The secondary axis will appear on the right, and Excel will even take some default estimates about scale. Compared to the first version of this chart, the addition of a second axis makes it much easier to compare trends. If you need a broader guide on the subject, then our post, “How to Use Excel” is for you.