A secondary axis in Excel is a specialized vertical or horizontal axis that allows you to plot data series with significantly different scales or units within a single chart. This feature is indispensable when you need to compare metrics that do not share the same measurement system—such as plotting total revenue in millions of dollars alongside a growth rate expressed as a percentage. Without a secondary axis, the smaller values (like the percentage) would appear as a flat line at the bottom of the chart, rendered invisible by the massive scale of the revenue bars.

Using a secondary axis correctly transforms a cluttered spreadsheet into a professional visualization that reveals correlations, trends, and outliers that would otherwise remain hidden in raw data.

When Should You Use a Secondary Axis?

In our professional data visualization workflows, we apply a secondary axis in three specific scenarios to ensure clarity and accuracy.

Comparing Different Units of Measure

If your dataset contains currency values (USD) and count values (Number of Units), these cannot share a single vertical axis. For example, if you are analyzing a retail store's performance, you might want to see "Total Sales" ($500,000) and "Customer Footfall" (1,200 people). Plotting these on a single axis would force the 1,200 figure to be nearly zero relative to the half-million mark.

Visualizing Vastly Different Scales

Even if the units are the same, the magnitudes might differ. Consider a parent company with $1 billion in revenue and a small subsidiary with $50,000. To see the growth trends of both on the same timeline, a secondary axis allows the subsidiary's data to be "scaled up" visually so its fluctuations are as apparent as those of the parent company.

Creating Combo Charts for Correlation Analysis

This is the most frequent application. By using a clustered column for one metric (like monthly production volume) and a line for another (like defect rate), a secondary axis helps observers see if an increase in volume correlates with a drop in quality.

Step-by-Step: Adding a Secondary Axis Using the Combo Chart Method

For most users, the most efficient way to implement this is through the "Combo Chart" feature. This method is preferred because it allows you to define the chart type and the axis placement simultaneously.

  1. Select Your Data Range: Highlight the cells containing your labels and the two data series you wish to compare. Ensure your data is organized in clean columns or rows with clear headers.
  2. Navigate to the Insert Tab: Click on the Insert tab on the Excel Ribbon.
  3. Open the Combo Chart Menu: In the Charts group, look for the small icon that looks like a bar and line chart combined. Click it and select Create Custom Combo Chart at the bottom of the dropdown.
  4. Assign the Secondary Axis: A dialog box titled "Insert Chart" will appear with the Combo category selected. You will see a list of your data series at the bottom.
    • For the first series, choose Clustered Column.
    • For the second series, choose Line.
    • Check the box under the Secondary Axis column for the series you want to appear on the right side of the chart.
  5. Finalize: Click OK. Excel will generate a chart with a primary vertical axis on the left and a secondary vertical axis on the right.

How to Add a Secondary Axis to an Existing Chart

Often, you may have already built a standard column or line chart and realized later that the data is unreadable. You do not need to start over.

  1. Select the "Invisible" Series: If one series is so small it is hard to click, go to the Format tab under Chart Tools. On the far left, in the Current Selection group, click the dropdown menu and select the specific series name (e.g., "Series 'Profit Margin'").
  2. Open Format Data Series: Once the series is selected, right-click any visible part of it (or use the shortcut Ctrl+1) to open the Format Data Series pane on the right.
  3. Toggle the Axis: Under the Series Options tab (the icon that looks like three bars), select the radio button for Secondary Axis.
  4. Adjust Chart Type (Optional but Recommended): To make the chart more readable, right-click the newly scaled series and select Change Series Chart Type. Switch it to a Line chart if the primary series is a Column chart.

Professional Formatting for Dual-Axis Charts

Adding the axis is only half the battle. To meet professional standards, you must format the chart so the viewer immediately understands which data belongs to which axis.

Adding Descriptive Axis Titles

A dual-axis chart without labels is a major cause of data misinterpretation.

  1. Click the chart to activate Chart Elements (the "+" icon).
  2. Check the box for Axis Titles.
  3. Ensure you have a title for the Primary Vertical (e.g., "Revenue in USD") and the Secondary Vertical (e.g., "Conversion Rate %").

Synchronizing Colors

A high-level design trick we use is color-coding the axis text to match the data series. If your revenue bars are blue, format the left axis text in blue. If your margin line is orange, format the right axis text in orange. This creates an intuitive visual link for the reader.

Adjusting Axis Bounds

Sometimes Excel’s automatic scaling starts the axis at a strange number or extends the range too far, flattening the data.

  1. Right-click the secondary axis values and select Format Axis.
  2. Under Bounds, manually set the Minimum and Maximum. For percentages, setting the maximum to "1.0" (100%) rather than "1.2" often makes the chart look cleaner.

Troubleshooting Common Secondary Axis Issues

The "Disappearing Line" Problem

If you have assigned a series to the secondary axis but the line does not appear, check your data for empty cells or text strings hidden in numeric columns.

  • The Fix: Right-click the chart, choose Select Data, and click Hidden and Empty Cells. Select Connect data points with line to bridge gaps in your data.

Overlapping Bars

If you try to use two sets of clustered columns on two different axes, they will overlap each other, making the primary series invisible.

  • The Fix: Use different chart types. The gold standard for secondary axes is a Column + Line combination. If you must use two column series, you will need to adjust the Gap Width and Overlap settings in the Format Data Series pane, but this is often confusing for the end-user.

Scale Distortion (The Ethical Component)

A secondary axis can be used to "lie" with statistics by manipulating the scale to make a tiny growth look massive.

  • The Fix: Always start your axes at zero unless there is a compelling reason not to. Ensure the gridlines of the primary and secondary axes align if possible to avoid a "busy" visual grid.

Advanced Techniques: Secondary Horizontal Axis

While rare, Excel also supports a secondary horizontal axis. This is useful when comparing two series that share the same vertical scale but have different X-axis intervals (e.g., one series recorded daily and another recorded monthly).

  1. Follow the steps to add a secondary vertical axis first.
  2. Go to the Chart Design tab.
  3. Click Add Chart Element > Axes > Secondary Horizontal.
  4. This allows you to plot data across two different timelines or categories simultaneously.

Alternatives to the Secondary Axis

In our experience, sometimes a secondary axis adds too much cognitive load for the audience. Before finalizing your chart, consider these alternatives:

  1. Normalization (Index to 100): Convert all data points to a percentage of their starting value. This allows you to plot everything on a single 0-100% axis. This is particularly effective for comparing the growth of stocks with different prices.
  2. Small Multiples: Instead of one chart with two axes, create two small charts side-by-side with a shared X-axis. This prevents the "which axis am I looking at?" confusion entirely.
  3. Panel Charts: Using a single axis but stacking the data in separate vertical regions of the chart area.

Summary

The secondary axis is one of Excel’s most powerful visualization tools, provided it is used with intent. By following the Combo Chart method, you can quickly integrate disparate data types into a cohesive narrative. Remember that the ultimate goal of a chart is to reduce complexity, not increase it. Always label your axes clearly, use contrasting chart types for the two series, and be mindful of scale manipulation to maintain data integrity.

FAQ

Can I have more than two vertical axes in Excel?

No, Excel natively supports only a Primary and a Secondary vertical axis. If you need a "Tertiary" axis, you would need to use complex workarounds like invisible series or third-party Excel add-ons.

How do I remove a secondary axis?

To remove it, right-click the data series plotted on the secondary axis, select Format Data Series, and change the selection back to Primary Axis. Then, click on the secondary axis values on the right side of the chart and press the Delete key.

Why is my secondary axis option greyed out?

This usually happens if your chart type does not support multiple axes (like a Pie chart or a Treemap). Ensure you are using a 2D Column, Line, or Scatter chart.

Does a secondary axis work in Excel Online?

Yes, the web version of Excel supports viewing and basic editing of secondary axes, though the full "Format Data Series" pane might have fewer advanced customization options compared to the desktop version.

How do I sync the gridlines of both axes?

This is a common frustration. To sync them, you must ensure that both the primary and secondary axes have the same number of "Major Units." For example, if the primary axis goes from 0 to 100 with a major unit of 20 (5 segments), set the secondary axis to go from 0 to 50 with a major unit of 10 (5 segments).