How to Add a Secondary Axis in Excel (And When You Actually Need One)
Adding a secondary axis in Excel sounds like a minor formatting tweak, but it's one of those features that can completely transform how a chart communicates data. If you've ever tried to plot revenue alongside customer count on the same chart and ended up with a flat line squashed at the bottom, you already know the problem a secondary axis solves.
What Is a Secondary Axis, and Why Does It Matter?
A secondary axis is a second vertical (Y) axis that appears on the right side of an Excel chart. It uses a different scale than the primary axis on the left, allowing two data series with very different value ranges to be displayed meaningfully on the same chart.
Without it, Excel forces both data series onto the same scale. If one series ranges from 0 to 1,000,000 and another ranges from 0 to 100, the smaller series becomes nearly invisible — visually useless.
The secondary axis gives each data series its own scale, so both appear with readable detail side by side.
When Should You Use One?
A secondary axis makes sense when:
- Your data series have significantly different value ranges (e.g., dollar figures vs. percentages)
- You want to compare trends rather than absolute values
- You're combining different units of measurement on a single chart (e.g., temperature and rainfall)
It's less useful — and can actually mislead — when the two data series share the same unit and similar range. In that case, a standard chart communicates more honestly.
How to Add a Secondary Axis in Excel 📊
The steps vary slightly depending on your version of Excel, but the core workflow is consistent across Excel 2016, 2019, 2021, and Microsoft 365.
Step 1: Build Your Chart First
Select your data, including both data series, and insert a chart. A combo chart or line chart works best for secondary axis use cases. A clustered bar or column chart also supports it.
Step 2: Select the Data Series You Want on the Secondary Axis
Click once on the chart to activate it, then click directly on the specific data series (the line, bar, or column) that you want to move to the secondary axis. You should see selection handles appear on that series only — not the whole chart.
Step 3: Open Format Data Series
Right-click the selected series and choose "Format Data Series" from the context menu. A panel will open on the right side of your screen.
Step 4: Switch to Secondary Axis
In the Format Data Series panel, under Series Options, you'll see two radio buttons:
- Primary Axis
- Secondary Axis
Select Secondary Axis. Excel immediately redraws the chart with a new Y-axis on the right side scaled to that data series.
Step 5: Adjust Chart Type Per Series (Optional but Recommended)
With a secondary axis in place, it often helps to differentiate the two series visually. Right-click the chart and choose "Change Chart Type". This opens the combo chart dialog, where you can set one series as a bar/column and the other as a line — a classic and readable combination.
Using the Combo Chart Shortcut
In Excel 2013 and later, there's a faster route. When inserting a chart:
- Select your data
- Go to Insert → Charts → Combo Chart (the icon showing a bar and line together)
- Choose "Create Custom Combo Chart"
- In the dialog, check the "Secondary Axis" box next to whichever series needs it
This skips the manual reformatting step and lets you configure the axis assignment before the chart is even created.
Common Variables That Affect the Result
The secondary axis feature behaves consistently, but how useful it is in practice depends on several factors:
| Variable | How It Affects the Secondary Axis |
|---|---|
| Data series count | Works best with exactly two series; three or more gets visually cluttered |
| Chart type | Combo charts (bar + line) work best; pie and 3D charts don't support secondary axes |
| Excel version | Combo chart shortcuts available from Excel 2013+; older versions require manual setup |
| Data range gap | The larger the gap between series scales, the more a secondary axis helps |
| Audience | Business audiences familiar with dual-axis charts read them accurately; general audiences may misread them |
A Note on Misinterpretation Risk ⚠️
Dual-axis charts are powerful but carry a known risk: the visual relationship between the two lines or series can imply correlation even when none exists. If one line goes up while the other goes up, viewers may assume one causes the other — or that the scales are comparable.
Being transparent with labels matters. Always title each axis clearly, include units, and consider whether a dual-axis chart is the clearest choice or whether two separate charts would communicate more honestly.
Formatting the Secondary Axis After Adding It
Once the secondary axis is visible, you can format it the same way as the primary:
- Double-click the right-side axis to open Format Axis
- Adjust minimum/maximum bounds manually if Excel's automatic scaling doesn't serve your data
- Change number formatting (percentages, currency, decimals) to match what the series represents
- Add an axis title via Chart Elements (the + icon next to the chart) to label what each axis measures
How much formatting you'll need depends on your data, your audience, and whether the chart is for a quick internal review or a formal presentation. Those three factors alone will shape whether a clean default is enough or whether precise manual scaling is worth the extra time.