You’ll be able to add a secondary axis in Excel by making your chart a combo chart, enabling the “Secondary Axis” choice for a sequence, and plotting the sequence in a special type than the first axis. Should you resolve to delete the second axis later, simply choose it and press Delete.
If in case you have a chart the place you might be plotting various kinds of information or the values differ, contemplate including a second axis for simpler visualization. We’ll present you methods to seamlessly create a two-axis chart in Excel.
When to make use of a secondary axis
You’ll be able to have a mixture of knowledge sequence with currencies, percentages, decimals, or entire numbers. Or maybe the values you are displaying differ by better quantities than the chart can adequately show. In these instances, including a second vertical axis to the chart can symbolize the info extra successfully.
For instance, now we have our information set that features bills and revenue for our places. We even have the variety of workers for every location to point out how these numbers have an effect on bills and income. This graph has two issues.
First, the values for workers are nicely under the smaller quantities for bills and revenue. Second, now we have a mixture of forex and quantity codecs. The info isn’t solely almost not possible to see, however it’s meaningless with out the numerical values.
As you possibly can see, plotting this information with out a secondary axis doesn’t present a passable or helpful image.
Add a secondary axis in Excel
If you have not created your chart but, you possibly can add the secondary axis instantly by making a combo chart from scratch. But when you have already got your chart and also you simply need to add the second axis to it, it would flip your chart, in a way, right into a combo chart.
RELATED: The right way to create a combo chart in Excel
To start the conversion to a two-axis chart, choose one of many measures for the axis you need to make a secondary axis. Then right-click and select “Change Sequence Chart Sort.”
You will note the Change Chart Sort window open with Combo chosen on the left. On the appropriate, you have got your present chart kind with the info under it.
Use the Chart Sort dropdown field subsequent to the info sequence you need to change. Normally it really works fantastic to make use of a line or a line with markers for the second axis. Nevertheless, you possibly can select an alternative choice like space or scatter with traces for a novel look if you would like.
Then verify the field to the appropriate of the identical sequence for “Secondary Axis”.
You’ll then see a preview of the up to date graph. As you possibly can see, the second axis stands by itself and likewise consists of the values alongside the appropriate hand aspect. Each make the info a lot simpler to grasp.
Be aware: Mixture charts usually work with the column chart kind. So you could want to regulate this in case you are utilizing a bubble chart or different kind of chart.
While you’re achieved, click on “OK” to use the change to the chart in your sheet. You’ll be able to then add axis titles or set information labels for readability.
RELATED: 6 Ideas for Making Microsoft Excel Charts Stand Out
Delete a secondary axis in Excel
Should you resolve later that you just now not need a secondary axis in your chart, the way you take away it will depend on the way you need to show the remaining information.
Delete the y-axis information from the chart
You’ll be able to take away the y-axis corresponding information out of your two-axis chart rapidly and simply. Choose the secondary axis on the chart and press the Delete key.
You’ll then see that each are faraway from the graph.
Convert axis to a special kind
You’ll be able to maintain the info within the chart and alter its kind as within the earlier instance to make it a combo chart.
Proper-click the info sequence and select “Change Sequence Chart Sort.”
Then select the kind from the dropdown menu. Make sure to uncheck the field for Secondary Axis. Click on “OK” to use the change.
Convert the secondary axis to a main axis
An alternative choice is to transform the secondary axis to a main axis. Relying on the kind of chart you utilize for the secondary axis, this could be the best choice for you.
Proper-click on the info sequence and select “Format Knowledge Sequence”.
When the sidebar opens, choose the Foremost Axis choice within the Sequence Choices part. Be aware that you just should be directed to this actual location from the context menu.
Once more, relying on the chart kind, you could want to vary the type of the axis after changing. You are able to do this by right-clicking, deciding on “Change Sequence Chart Sort” and selecting the type as described above.
By including a secondary axis in Excel, you possibly can enhance the readability of your chart to make it a extra helpful image. For extra data, see How to decide on a chart that matches your information in Excel.