How to Add a Second Vertical Axis in Excel (Secondary Y-Axis Guide)

When your chart data includes two very different value ranges — say, monthly revenue in the thousands alongside a conversion rate between 0 and 100 — plotting both on a single vertical axis turns one of them into a nearly invisible flat line. Adding a secondary vertical axis solves this by giving each data series its own scale, making both readable and meaningful on the same chart.

What a Secondary Vertical Axis Actually Does

Excel charts use the Y-axis (vertical) to represent value scales. By default, all data series in a chart share one Y-axis, which works fine when the values are proportionally similar.

A secondary Y-axis adds a second scale on the right side of the chart. Each axis can have its own minimum, maximum, and interval settings. The data series assigned to it plots against that right-hand scale instead of the left. Visually, the chart looks the same — same plot area, same X-axis — but each series is now truthfully represented at its own scale.

This is especially useful for:

• Combining a bar chart with a line chart (a common "combo chart" setup)
• Showing percentages alongside raw counts
• Comparing temperature and rainfall, sales volume and profit margin, or any two metrics with different units

How to Add a Secondary Vertical Axis in Excel

Step 1: Start with a Chart That Has at Least Two Data Series

You need at least two data series plotted on your chart before a secondary axis makes sense. If you haven't built the chart yet, select your data range and insert a chart (a clustered bar, line, or combo chart type works well here).

Step 2: Select the Data Series You Want to Move

Click once on the chart to activate it, then click directly on the data series you want to assign to the secondary axis. You should see selection handles appear on just that series — bars, line, or data points highlighted.

If clicking on the series is tricky, use the Chart Elements dropdown in the top-left corner of the screen (appears when a chart is active) to select the specific series by name.

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.

Alternatively, you can press Ctrl+1 after selecting the series to open the format panel directly.

Step 4: Switch to Secondary Axis

In the Format Data Series pane, look for the "Series Options" section (represented by a bar chart icon at the top of the pane). You'll see two radio buttons:

• Primary Axis
• Secondary Axis ✅

Select Secondary Axis. Excel immediately redraws the chart, and a second Y-axis appears on the right side of the plot area.

Step 5: Adjust Chart Type for Clarity (Optional but Recommended)

When two series share a chart with different axes, it's often cleaner to give them different chart types. A common approach: keep one series as a column/bar and change the other to a line.

To do this, right-click on the chart and choose "Change Chart Type". Select "Combo" from the list on the left. Excel will show dropdowns for each series, letting you set the chart type and check a box to confirm the secondary axis — all in one place. 📊

This Combo Chart dialog is often the fastest route if you're setting up a dual-axis chart from scratch.

Formatting the Secondary Axis

Once the secondary axis appears, you can format it independently:

• Double-click the right-side axis to open its format pane
• Set custom minimum and maximum bounds to prevent misleading visual compression
• Adjust number formatting (percentages, currency, decimals) to match what that series represents
• Add an axis title by clicking the chart, selecting the "+" icon (Chart Elements), and enabling Axis Titles

Keeping axis titles and distinct colors for each series is important — without them, readers may not realize two different scales are in use.

Factors That Affect How This Works for You

Not every setup produces the same result, and a few variables determine what you'll encounter:

When a Secondary Axis Isn't the Right Fix

A secondary axis solves a specific problem, but it can also mislead readers if used carelessly. Two independent scales on one chart can make trends look artificially correlated just by adjusting one axis's range.

Some situations where a secondary axis may not be ideal:

• When the two metrics have no meaningful relationship — separate charts may be clearer
• When the audience isn't data-literate — dual axes require careful labeling to avoid confusion
• When you're working in Excel Online, which has more limited chart formatting options compared to the desktop application

The Variable That Only You Can Resolve 🎯

The mechanics of adding a secondary axis are consistent, but whether it's the right choice — and how to configure it — depends on what your data is actually showing, who's reading the chart, and what comparison you're trying to make. The scale ranges you set, the chart types you combine, and even whether a dual-axis chart is appropriate at all come down to your specific dataset and communication goal. That's the part no general guide can decide for you.