How to Add Secondary Axis in Excel - Practical Guide

Learn to add a secondary axis to your Excel charts to compare datasets with different scales or units. This technique lets you overlay two data series on one chart, making it easy to visualize relationships between metrics like sales volume and profit margin simultaneously.

Why This Matters

Secondary axes are essential for comparing disparate metrics in a single visual, improving dashboard clarity and stakeholder communication.

Prerequisites

•An existing Excel chart with at least two data series
•Understanding of basic chart creation and data selection

Step-by-Step Instructions

Select your chart

Click on the chart to activate it; the chart border will show selection handles.

Right-click the data series to convert

Right-click on the specific data series line or bar that you want to move to a secondary axis.

Open Format Data Series dialog

Select 'Format Data Series' from the context menu to open the formatting panel.

Navigate to Series Options

In the Format pane on the right, click the chart icon (Series Options) to expand axis settings.

Change to Secondary Axis

Under 'Plot Series On,' select the radio button for 'Secondary Axis,' then close the pane.

Alternative Methods

Using the Chart Design tab

With the chart selected, go to Chart Design > Add Chart Element > Axes > Secondary Horizontal/Vertical Axis, then assign your data series manually.

Excel 365: Quick Layout option

Some chart templates in Excel 365 include pre-built dual-axis layouts; select the chart and explore Quick Layout in Chart Design.

Tips & Tricks

✓Use different chart types (column + line) for each axis to distinguish series visually.
✓Format axis labels with units (e.g., '$' vs '%') to clarify the difference in scales.
✓Keep secondary axis series count low; more than two series becomes confusing.

Pro Tips

★Sort your data ascending or descending before charting to improve readability and avoid misleading visual trends.
★Use contrasting colors and line styles for secondary axis series so viewers instantly recognize the difference.
★Double-check axis scaling; a secondary axis with poor scale can visually exaggerate or downplay real correlations.

Troubleshooting

Secondary axis option is grayed out

Ensure your chart is a combo chart type (XY Scatter, Column, or Line). Some chart types like Pie don't support secondary axes. Convert your chart type via Chart Design > Change Chart Type.

Secondary axis doesn't appear after selection

Right-click the data series again and confirm the radio button is selected for 'Secondary Axis.' Excel may require you to deselect and reselect the series.

Axis labels overlap or are illegible

Right-click the axis > Format Axis > Axis Options and adjust Label Position to 'Low' or 'High,' or increase chart size.

Frequently Asked Questions

Can I add a secondary axis to a pie or doughnut chart?

No, secondary axes only work with chart types that have categorical or value axes, such as Column, Bar, Line, or Combo charts. Pie and Doughnut charts don't support secondary axes.

How many secondary axes can I add to one chart?

Excel supports only one secondary axis per chart. If you need to compare more than two data series, consider creating separate charts or using a combo chart with different visual styles.

How do I remove a secondary axis?

Right-click the data series on the secondary axis, select Format Data Series, and switch the radio button back to 'Primary Axis.' The secondary axis will disappear if no other series use it.

Can I have different axis labels on primary and secondary axes?

Yes, right-click each axis separately and use Format Axis > Axis Options to customize titles and number formats independently for clarity.