Methods to Add or Take away a Secondary Axis in an Excel Chart


You’ll be able to add a secondary axis in Excel by making your chart a combo chart, enabling the “Secondary Axis” possibility for a collection, and plotting the collection in a mode totally different from the first axis. For those who resolve to take away the second axis later, merely choose it and hit Delete.

For those who have a chart the place you’re plotting several types of information or the values differ, take into account including a second axis for simpler viewing. We’ll present you find out how to painlessly create a two-axis chart in Excel.

When to Use a Secondary Axis

You’ll have a mix of information collection with currencies, percentages, decimals, or entire numbers. Or possibly the values you’re displaying differ by higher quantities than the chart can adequately present. In these circumstances, including a second vertical axis to the chart can depict the info extra successfully.

For instance, we now have our information set together with bills and income for our areas. We even have the variety of staff for every location to point out how these numbers have an effect on the bills and income. This chart has two issues.

Chart data and chart without a secondary axis

First, the values for the workers are effectively beneath the smallest quantities for bills and income. Second, we now have a mixture of foreign money and quantity codecs. Not solely is the info nearly unattainable to see, however it’s meaningless with out the quantity values.

Chart without a secondary axis

As you’ll be able to see, plotting this information with out a secondary axis doesn’t present a profitable or helpful image.

Add a Secondary Axis in Excel

For those who haven’t but created your chart, you’ll be able to add the secondary axis instantly by making a combo chart from the beginning. But when you have already got your chart and easily wish to add the second axis to it, you’ll convert your chart, in a way, to a combo chart.

RELATED: Methods to Create a Combo Chart in Excel

To start the conversion to a two-axis chart, choose one of many indicators for the axis you wish to flip right into a secondary axis. Then, right-click and choose “Change Sequence Chart Sort.”

Change Series Chart Type in the shortcut menu

You’ll see the Change Chart Sort window open with Combo chosen on the left. On the suitable, you have got your present chart sort with the info beneath.

Current chart with combo chart settings

Use the Chart Sort drop-down field subsequent to the info collection you wish to change. Generally, utilizing a line or line with markers for the second axis works effectively. Nonetheless, you’ll be able to select an alternative choice like space or scatter with strains for a novel look in the event you like.

Chart types for a series

Then, test the field to the suitable of the identical collection for “Secondary Axis.”

You’ll then see a preview of the up to date chart. As you’ll be able to see, the second axis stands out by itself and in addition contains the values alongside the suitable facet. Each of which make the info a lot simpler to grasp.

Secondary axis added using a line chart

Be aware: Combo charts usually work with the column chart sort. So, you might have to regulate this in the event you’re utilizing a bubble chart or different sort of graph.

Whenever you end, click on “OK” to use the change to the chart in your sheet. You’ll be able to then add axis titles or arrange information labels for much more readability.

Updated chart with a secondary axis in Excel

RELATED: 6 Ideas for Making Microsoft Excel Charts That Stand Out

Take away a Secondary Axis in Excel

For those who resolve later that you just now not desire a secondary axis in your chart, the best way you take away it is dependent upon the way you wish to show the remaining information.

Take away the Axis and Knowledge From the Chart

You’ll be able to take away the axis and corresponding information out of your two-axis chart rapidly and simply. Choose the secondary axis on the chart and press your Delete key.

You’ll then see each faraway from the chart.

Before and after deleting a chart's second axis

Convert the Axis to a Completely different Sort

You’ll be able to maintain the info on the chart and alter its sort similar to the instance above for changing it to a combo chart.

Proper-click the info collection and choose “Change Sequence Chart Sort.”

Change Series Chart Type in the shortcut menu

Then, select the sort within the drop-down menu. Make sure you uncheck the field for Secondary Axis. Click on “OK” to use the change.

Changed chart series secondary axis type

Convert the Secondary Axis to a Main Axis

One different possibility is to flip the secondary axis right into a major axis. Relying on the chart sort you’re utilizing for the secondary axis, this is perhaps the best possibility for you.

Proper-click the info collection and choose “Format Knowledge Sequence.”

Format Data Series in the shortcut menu

When the sidebar opens, choose the Main Axis possibility within the Sequence Choices part. Be aware that you ought to be directed to this actual spot from the shortcut menu.

Primary Axis selected in the Format Data Series sidebar

Once more, relying on the chart sort, you might want to alter the type of the axis after you change it. You are able to do this by right-clicking, selecting “Change Sequence Chart Sort,” and selecting the type as described earlier.

By including a secondary axis in Excel, you’ll be able to enhance your chart’s readability to make it a extra helpful visible. For extra, have a look at find out how to select a chart to suit your information in Excel.

Supply hyperlink