How to Add a Second Axis in Excel (Secondary Y-Axis Guide)
When you're plotting two data series that measure completely different things — say, monthly revenue in dollars alongside customer satisfaction scores on a 1–10 scale — a single axis makes one dataset look almost flat or wildly distorted. A secondary axis solves this by giving each data series its own scale, so both tell their story clearly on the same chart.
Here's exactly how it works, what affects the outcome, and where your own data setup becomes the deciding factor.
What a Second Axis Actually Does
Excel charts use a primary vertical axis (Y-axis) on the left by default. When you add a second axis, Excel creates a secondary Y-axis on the right side of the chart. Each axis has its own scale, independently calibrated to the data series assigned to it.
This is different from simply adding a second data series to a chart. Without a secondary axis, both series share the same scale — which only works when the values are in comparable ranges. The moment you're combining units like percentages with raw counts, or temperatures with sales figures, a shared axis actively misleads the reader.
How to Add a Secondary Axis in Excel (Step by Step)
The process is straightforward in modern versions of Excel (Microsoft 365, Excel 2019, Excel 2016):
- Create your chart with both data series already included. A combo chart or line/bar chart works best.
- Click on the data series you want to move to the secondary axis. Click directly on a bar, line, or data point — not the chart border.
- Right-click the selected series and choose "Format Data Series" from the context menu.
- In the Format Data Series pane that opens on the right, look for "Series Options."
- Under Plot Series On, select "Secondary Axis."
- Excel immediately adds a second Y-axis on the right and rescales the selected series to it.
You can also access this through the Chart Design tab → Change Chart Type, where Excel lets you assign axis placement per series using a dropdown — often the cleaner route when building combo charts from scratch.
On Mac vs. Windows
The steps are nearly identical on both platforms, but the pane layout differs slightly. On Mac, the Format Data Series pane may appear as a floating window rather than a sidebar. The "Secondary Axis" radio button is in the same Series Options section either way.
Which Chart Types Support a Secondary Axis 📊
Not every chart type handles a secondary axis gracefully — or at all.
| Chart Type | Secondary Axis Support | Notes |
|---|---|---|
| Line chart | ✅ Full support | Clean and readable with two Y-axes |
| Bar/Column chart | ✅ Full support | Works well; watch for visual overlap |
| Combo chart | ✅ Designed for it | Best practice for mixed series |
| Scatter (XY) | ✅ Supported | Can add secondary X and Y axes |
| Pie/Donut | ❌ Not supported | Single-value charts; no axis to add |
| 3D charts | ❌ Not supported | Excel disables the option entirely |
Combo charts — where one series displays as a column and another as a line — are the most common use case for secondary axes, and Excel has a built-in Combo chart type specifically for this purpose.
Factors That Affect How Your Chart Behaves
Adding the axis is the easy part. Getting it to communicate clearly depends on several variables that differ from one dataset to the next.
Scale range mismatch — If one axis runs from 0 to 1,000,000 and the other from 0 to 100, Excel auto-scales each independently. That's usually helpful, but you may want to manually set axis minimums and maximums (right-click the axis → Format Axis → Bounds) to prevent misleading visual comparisons.
Data series type — Assigning a line to the secondary axis while keeping bars on the primary is visually intuitive. Putting two lines on separate axes with no color or label distinction causes confusion. Clear axis titles (Chart Design → Add Chart Element → Axis Titles) are essential.
Number of data series — Excel supports a maximum of one secondary Y-axis and one secondary X-axis. If you're working with three or more series that all need different scales, a single chart with secondary axes may not be sufficient.
Excel version — Older versions (Excel 2010 and earlier) follow the same general logic but use dialog boxes instead of the Format pane. The "Format Data Series" → "Axis" tab approach applies in those versions.
Chart purpose and audience — A secondary axis adds interpretive complexity. For internal analysis, that's fine. For a presentation or a report read by non-technical stakeholders, the extra axis can create confusion if the labels and titles aren't immediately clear.
Where Individual Setups Start to Diverge
The mechanics of adding a secondary axis are consistent across Excel versions and platforms. What varies significantly is whether a secondary axis is actually the right solution for a given dataset — and how much manual adjustment it needs afterward.
A dataset with two series in completely different units almost always benefits from a secondary axis. But if your series are in the same units and simply differ in magnitude, logarithmic scaling on a single axis might communicate more accurately. If your goal is comparison rather than trend, a separate panel chart (two stacked charts aligned) sometimes reads more cleanly than a dual-axis chart.
How your data is structured, what story you're trying to tell, and who's reading the chart all shape whether the secondary axis you've added is doing useful work — or adding visual noise. 🎯