How to Add a Second Axis in Excel (And When You Actually Need One)

Excel charts are powerful, but they hit a wall when you're trying to display two data series that use completely different scales. Plotting monthly revenue alongside customer count on the same axis produces a chart where one series gets squashed into near-invisibility. That's exactly what a secondary axis solves — and understanding when and how to use one makes the difference between a chart that informs and one that confuses.

What a Secondary Axis Actually Does

A standard Excel chart uses a single Y-axis (the vertical axis) shared by all plotted data series. Every series is scaled relative to that one axis, which works fine when your values live in the same numerical range.

A secondary axis adds a second Y-axis on the right side of the chart. Each axis scales independently, so a series showing values in the thousands and a series showing values between 0 and 100 can coexist in the same chart without one drowning the other out.

The horizontal X-axis is almost always shared. You're stacking two independently scaled views of the same time period or category set — not creating two entirely separate charts.

How to Add a Second Axis in Excel: Step by Step

Method 1: Using the Format Data Series Pane (Most Reliable)

1. Create your chart with both data series included. A combo chart or clustered bar/line works best.
2. Click once on the data series you want to move to the secondary axis. Make sure you've selected that specific series (look for selection handles on just those data points).
3. Right-click and choose "Format Data Series" from the context menu.
4. In the Format Data Series pane that opens on the right, find the "Series Options" section (it's usually the first tab, represented by a bar chart icon).
5. Under "Plot Series On," select "Secondary Axis."
6. Excel immediately adds the right-hand Y-axis and rescales that series against it.

Method 2: Via the Change Chart Type Dialog

1. Right-click anywhere on the chart area and select "Change Chart Type."
2. Navigate to the "Combo" category at the bottom of the left-side list.
3. Excel displays a table showing each data series, its chart type, and a checkbox labeled "Secondary Axis."
4. Tick the "Secondary Axis" box for whichever series needs it.
5. You can also change chart types per series here — for example, keeping one series as a column and switching another to a line, which is the most common secondary-axis layout.
6. Click OK to apply.

The Combo chart dialog is particularly useful when you're setting up secondary axes and mixed chart types at the same time.

Formatting the Secondary Axis After Adding It

Adding the axis is step one. Making the chart readable is step two.

• Axis labels: Double-click the secondary Y-axis to open its Format Axis pane. You can set custom minimum and maximum bounds, adjust the display units (showing values in thousands, for example), and control tick mark intervals.
• Axis title: Go to Chart Design → Add Chart Element → Axis Titles → Secondary Vertical to add a label explaining what the right axis measures.
• Series color and style: When two series share a chart, visual distinction matters. Use contrasting colors and consider making one a line and one a bar so readers can immediately tell which scale applies to which series.

Common Scenarios Where a Second Axis Makes Sense 📊

The common thread: two related metrics, fundamentally different scales, same time dimension.

When a Secondary Axis Creates More Problems Than It Solves

A secondary axis isn't always the right tool. A few situations where it backfires:

• More than two scales: Excel supports only one secondary axis per chart. Three or more incompatible series need a different approach — often multiple charts displayed side by side.
• Unrelated data: If the two series don't share a meaningful relationship, a dual-axis chart implies a connection that may not exist. This is a well-documented source of misleading data visualization.
• Audience unfamiliarity: Secondary axes require the reader to consciously check which axis belongs to which series. For non-technical audiences, two separate simple charts often communicate more clearly.

Excel Version and Platform Differences 💡

The steps above apply to Excel for Microsoft 365, Excel 2019, Excel 2021, and Excel 2016 on Windows — all of which use the same Format Data Series pane layout.

Excel for Mac follows the same core process, though pane layouts and right-click menu labels differ slightly between versions.

Excel Online (the browser version) has limited chart formatting options. Secondary axis support exists but the controls are more constrained — some formatting steps that are straightforward in the desktop app may require a workaround or aren't available at all.

Google Sheets, while not Excel, does support secondary axes through a similar Series settings panel in the chart editor — worth knowing if your workflow spans both tools.

The Variables That Shape Your Result

How well a secondary-axis chart actually works depends on factors specific to your situation: the relationship between your two data series, how wide the scale gap between them is, who's reading the chart and how much chart literacy they bring, and whether the chart will be viewed in Excel, exported as an image, or embedded in a presentation where axis labels might be harder to read at smaller sizes.

A secondary axis that works perfectly in a detailed analyst report might create confusion in a boardroom slide viewed from ten feet away. The mechanics of adding the axis are straightforward — but whether it serves your specific data story and your specific audience is a question your own setup and context will answer.