How to Add a Secondary Axis in Excel (and When You Should)

You have revenue in dollars and margin in percentages, and Excel has crammed them onto one axis where the margin line runs flat along the floor of the chart like it’s hiding from you. The fix is a secondary axis — a second vertical scale on the right side of the chart. It takes about thirty seconds. This guide shows you the modern way to do it, the older way that still works in every Excel version, and — because almost nobody else will tell you this — the situations where a secondary axis is the wrong answer and will quietly mislead everyone who reads your chart.

The Modern Method: Add the Secondary Axis While You Build the Chart

If you’re creating a new chart, don’t build it first and fix it afterward. Excel’s Combo Chart dialog lets you assign each series to an axis at creation time, and it’s the cleanest workflow in any current version of Excel.

Select your data, including headers — for example, a Month column, a Revenue column, and a Margin % column.

HomeInsertPage LayoutFormulas

0.15

Month	Revenue	Margin %
Jan	$120,000	15%
Feb	$135,000	18%
Mar	$142,000	14%
Apr	$150,000	20%

Go to Insert > Recommended Charts, then click the All Charts tab.
Choose Combo at the bottom of the list.
Excel shows every series with two controls: a Chart Type dropdown and a Secondary Axis checkbox. Set Revenue to Clustered Column, set Margin % to Line, and tick the Secondary Axis box next to Margin %.
Click OK. Done — columns read against the left axis in dollars, the line reads against the right axis in percentages.

This is the method to reach for by default. You see the result in the preview pane before committing, you assign chart types and axes in one pass, and you never end up with the classic mess where two column series overlap on different scales. If you want the full treatment of mixing chart types, our combo chart guide goes deeper on which combinations work and which just confuse people.

The Works-Everywhere Method: Format Data Series

Already have a chart? You don’t need to rebuild it. This method works in every Excel version from 2010 through Microsoft 365, on an existing chart of any type that supports it.

Click once on the data series you want to move — the line or columns that are currently unreadable. All its data points should show selection handles.
Right-click the selected series and choose Format Data Series.
In the pane that opens on the right, under Series Options, select Secondary Axis.
The series immediately re-plots against a new axis on the right side of the chart.

One practical trap: if both series are the same chart type — say, two column series — putting one on the secondary axis makes them overlap, because Excel draws secondary-axis columns in front of primary-axis columns in the same plot space. The fix is to change one series to a different chart type (right-click the series > Change Series Chart Type), which lands you back at the Combo dialog from the first method. In practice, a dual-axis chart almost always wants two different chart types: columns for the big absolute numbers, a line for the rate or percentage.

Label Both Axes — This Part Is Not Optional

A dual-axis chart with unlabeled axes is a guessing game. Which series belongs to which scale? Your reader shouldn’t have to work that out.

Select the chart and click the Chart Elements button (the + at the top-right corner).
Check Axis Titles.
Type a clear title for each vertical axis — “Revenue ($)” on the left, “Gross Margin (%)” on the right.

A stronger technique: color-match the axis labels to their series. If the margin line is orange, format the right-hand axis text orange (click the axis, then set the font color on the Home tab). The reader’s eye connects series to scale without reading a single title. It’s a small touch that separates a chart people trust from one they squint at.

When You Should Use a Secondary Axis

A secondary axis earns its place in exactly one situation: two related series measured in genuinely different units, where the relationship between their movements is the story. The classic cases:

Revenue ($) vs. margin (%) — you want to see whether growth is coming at the cost of profitability.
Units sold vs. average selling price — volume/price trade-off over time.
Website traffic vs. conversion rate — is more traffic converting, or diluting?
Headcount vs. revenue per employee — scaling efficiency.

Notice the pattern: one absolute measure, one rate or ratio, and a real analytical question that requires seeing both at once. If your chart fits that pattern, a secondary axis is the right tool and you should use it without apology.

When You Shouldn’t — and Here’s Where We Take a Position

Most dual-axis charts in circulation shouldn’t exist. Not because the feature is bad, but because of how it gets used. Here’s the core problem: the point where two lines cross on a dual-axis chart means nothing. Each series is plotted against its own arbitrary scale, so by adjusting either axis’s minimum and maximum, you can make the lines cross anywhere you like — or not at all. The crossover that looks like a dramatic inflection point is an artifact of scaling choices, not a fact about the data. Readers instinctively assign meaning to it anyway. That’s how dual-axis charts mislead: not by lying about values, but by manufacturing visual relationships that aren’t there.

So, three rules we’d defend in any meeting:

Don’t use a secondary axis for two series in the same units. Revenue for Product A and revenue for Product B belong on one axis, full stop. If one dwarfs the other, that gap is the finding — hiding it with separate scales is spin, not analysis. If the small series genuinely needs its own view, give it its own chart.

Don’t use one to fake a correlation. With free rein over four axis limits, you can make almost any two vaguely-trending series look locked in step. If you want to claim two measures move together, show a scatter plot or state the correlation — don’t stage-manage two lines into agreement.

Don’t stack three or more scales. Excel only offers two vertical axes for good reason. If you’re tempted to overlay a third series in different units, you need a panel chart — separate small charts stacked with a shared horizontal axis. Less clever-looking, dramatically clearer.

When a dual-axis chart isn’t safe, the panel chart is nearly always the honest alternative: each series gets its own scale and its own visual space, so nobody misreads a crossover. It costs a bit more vertical room and about two minutes of layout work. Cheap insurance. And if you’re unsure whether this data even wants a line-and-column treatment in the first place, start with our guide to choosing the right chart before committing.

Fine-Tuning the Secondary Axis Scale

Excel auto-scales both axes independently, and its choices are serviceable but rarely ideal. To take control: double-click the secondary axis, and under Axis Options set Minimum and Maximum bounds manually. Two tips worth the effort:

Align the gridlines. If the left axis runs 0–500,000 in five steps, set the right axis to a range that also divides into five clean steps (0–50% in steps of 10, say). Otherwise Excel draws two clashing sets of intervals and the chart looks subtly broken.
Start percentage axes at zero unless you have a stated reason not to. A margin axis running 42%–48% makes a one-point wobble look like a cliff. If you must truncate the scale to show detail, say so on the chart.

If your chart stops reflecting new data after all this formatting work, that’s a separate (and common) problem — see Excel chart not updating? 7 fixes that actually work.

FAQ

How do I add a secondary axis in Excel with one click? There’s no true one-click route, but the fastest path on an existing chart is: click the series, press Ctrl+1 to open Format Data Series, select Secondary Axis. Two clicks and a keystroke. You can also ask Copilot to do it in plain language — our Copilot charting guide covers what it handles well and where it fumbles.

Why is the Secondary Axis option grayed out? Usually the chart type doesn’t support it — 3-D charts, and some specialty types like treemaps and sunbursts, can’t take a secondary axis. Convert to a standard 2-D chart type first. Also confirm you’ve selected a data series, not the whole chart or the plot area.

Can I add a secondary horizontal (X) axis? Yes. Once any series is on the secondary vertical axis, go to Chart Elements (+) > Axes and enable Secondary Horizontal. It’s genuinely useful in rare cases (dual date ranges, for instance) but it doubles the misreading risk of everything discussed above. Treat it as expert-mode.

How do I remove a secondary axis? Click the secondary axis itself and press Delete — but note the series stays scaled to the now-invisible axis, which is a trap. The cleaner removal: right-click the series, Format Data Series, switch it back to Primary Axis.

Why did my columns disappear behind the other series? Because Excel draws secondary-axis series in front of primary-axis series within the same plot area. If both series are columns, the front one covers the back one. Change one series to a line (Change Series Chart Type) or, if both genuinely must be columns, adjust the gap width on the front series so the rear columns peek out — though at that point a paired panel chart is honestly the better design.

Does this work the same way in Excel for Mac and Excel for the web? The Format Data Series method works in both, with minor pane layout differences on Mac. The full Combo Chart creation dialog is a Windows desktop feature; in Excel for the web, build the chart first and then move a series to the secondary axis afterward.