Excel Combo Chart Secondary Axis: Setup and Tips

To put a series on a secondary axis in an Excel combo chart, select the chart, choose Chart Design > Change Chart Type > Combo, select a chart type for each series, and check Secondary Axis beside the series that needs its own scale. A secondary axis is useful when you want to show different measures together—such as sales dollars and a percentage—without forcing them onto one incompatible scale.

What a secondary axis means

A combo chart combines two or more chart types in one chart, commonly columns for one measure and a line for another. A secondary axis is a second vertical value scale, usually displayed along the right edge of the chart. Excel plots the series assigned to it against that scale, while the other series use the primary vertical axis, usually shown on the left.

The axes can use different units and ranges. For example, monthly sales might range from $8,000 to $18,000 while a conversion rate ranges from 2% to 5%. If both series used the same vertical scale, the percentage values would be tiny compared with the sales values and difficult to read. Putting the rate on a secondary axis makes both series visible.

The categories along the horizontal axis—such as months—are normally shared. The secondary axis does not create a second dataset or change the underlying values. It changes the scale Excel uses to draw a selected series. Readers should be able to identify which scale belongs to which series, so include clear axis titles and retain a useful legend.

When a combo chart with two axes is useful

Use a secondary axis when the measures are meaningfully related by category or time but differ substantially in units or scale. The chart can help readers follow both series across the same dates or product groups. Common examples include:

Revenue in dollars and profit margin as a percentage.
Units sold and average selling price.
Website visits and conversion rate.
Rainfall and temperature, when each measure needs a different unit or range.

A secondary axis is not automatically the right answer whenever one series looks small. First check for a data-entry mistake, an inappropriate chart type, or an outlier that stretches the primary scale. If the purpose is to compare the sizes of two measures, using different scales may obscure that comparison. A second axis is most defensible when readers need to see the patterns of both measures, not directly compare their numerical magnitudes.

Create a combo chart and assign the secondary axis

For Microsoft Excel for Microsoft 365 on Windows, arrange the source data with category labels in the first column and a header above each data series. For example, put months in column A, Sales in column B, and Margin in column C. Select the full range, including its headers, then create and configure the chart:

Select the data range. Check that each row represents the same category or time period across all series.
On the ribbon, choose Insert > Insert Combo Chart > Create Custom Combo Chart. If that command is not visible, choose Insert > Recommended Charts, open All Charts, and select Combo.
In the combo chart dialog, use the chart-type list beside each series to choose an appropriate type. A common setup is Clustered Column for sales and Line for margin.
Check Secondary Axis on the row for the series that needs a separate scale. In this example, assign Margin to the secondary axis.
Choose OK. Add or edit axis titles so the left and right scales are unmistakable.

Excel may suggest a combo chart when the selected data has series with very different scales, but check the assignments rather than assuming the suggestion is correct. Available chart types and the dialog’s layout can vary with the data and Excel build. The key is to choose the type and secondary-axis setting for each series in the combo chart controls.

Add a secondary axis to an existing chart

If the chart already exists, you can change its type rather than rebuilding it. Select the chart, then choose Chart Design > Change Chart Type > Combo. Set the desired type for each series and check Secondary Axis for the one that needs a separate scale. This is often the clearest route when you want to turn an existing column chart into a column-and-line chart.

For a quick adjustment, select the specific series in the chart, right-click it, and choose Format Data Series. In the formatting pane, open Series Options and select Secondary Axis under Plot Series On. This assigns the selected series to the right-hand scale; it does not, by itself, change the series from a column to a line. To change its visual type, use the combo chart dialog.

Be careful to select the series rather than an individual data point or the chart background. If the formatting pane shows options for a single point, click the series again or use the chart’s selection controls to select the whole series. After the change, confirm that the expected series appears against the right axis.

Choose chart types and axis assignments

Choose chart types that make the data easy to distinguish. Columns are effective for comparing values across separate categories; a line is often easier to follow across an ordered timeline. If both measures are lines, make them visually distinct with contrasting colors or markers. Avoid adding a third or fourth series just because Excel permits it: crowded legends and overlapping shapes make the chart harder to interpret.

A practical example is a report of monthly revenue and gross margin. Use columns for revenue on the left axis, labeled Revenue ($), and a line for margin on the right axis, labeled Gross margin (%). The labels should name both the measure and the unit. A legend saying Series 1 and Series 2 is not enough, and color alone may not communicate which scale to read.

The data should also have a sound basis for sharing one horizontal axis. Revenue and margin by month fit because each pair describes the same month. Comparing unrelated category sets can imply a relationship that the data does not establish. A combo chart reveals how values move together visually; it does not prove that one measure causes changes in the other.

Format the axes and make the chart readable

Excel chooses axis bounds and intervals automatically, but automatic settings are not always the clearest choice. Right-click an axis and choose Format Axis to review its settings. Depending on the data, you can set minimum and maximum bounds, change major units, and adjust the number format. For a percentage series, format the secondary axis as a percentage and verify that the source values are stored as intended. For example, a stored value of 0.04 displays as 4% when formatted as a percentage.

Do not set bounds merely to make the lines appear to match or to create a dramatic visual effect. A truncated scale can make modest changes look large. If you use nonzero bounds, make the scale clear and consider whether the chart still communicates fairly. When readers need to compare levels, starting a column chart’s value axis at zero is usually important because column length visually encodes magnitude.

To label the scales, select the chart and use Chart Design > Add Chart Element > Axis Titles, then add the primary and secondary vertical titles that apply. Exact options depend on the chart and whether a secondary axis is present. Also use a descriptive chart title, readable number formats, and a legend with meaningful series names. A clean chart should let a reader identify the measure, unit, and axis without guessing.

Common problems and misleading interpretations

If the secondary axis is missing, confirm that the series is actually assigned to it. Select the chart and inspect the combo settings, or open Format Data Series > Series Options. Also make sure you selected a data series, not a chart element that does not have series options. The secondary vertical axis normally becomes visible when at least one series is plotted on it.

If a series appears flat, check its axis and number format before changing the data. It may be plotted against the primary scale by mistake, or its values may be stored in a different form than expected. A percentage entered as 4 rather than 0.04, for example, may not represent the intended 4% if the chart is formatted to display fractions as percentages. Verify the source values and labels rather than using formatting to conceal a data problem.

Two axes can also make unrelated trends look as if they match. Because each vertical scale can have different bounds, Excel can make two lines cross or move in parallel depending on the ranges chosen. That visual alignment is not evidence of equal values or a causal connection. Explain the scales, avoid cherry-picking bounds, and consider separate charts when the relationship is not central or could be misunderstood.

Alternatives when a secondary axis is not the best fit

A dual-axis combo chart is not the only way to show measures with different units. If exact comparisons are not needed, separate charts placed near each other can show the same time periods without competing scales. Small multiple charts—one panel per measure with consistent category order—are often easier to scan in a report or dashboard.

If the measures share a unit but differ in magnitude, consider whether a suitable single-axis chart can show them honestly, or whether a logarithmic scale is appropriate for the audience and purpose. A logarithmic axis changes how distances represent values and is not a casual fix; it needs clear labeling and values suitable for that scale. If the main goal is to compare direction or percentage change, a separate indexed view may help, but explain the baseline and transformation. Do not silently rescale values and present them as raw data.

In Excel for Mac, chart controls and dialog placement can differ from Windows, but the same principle applies: select a combo chart, assign each series a chart type, and enable its secondary axis in the chart settings. Excel for the web may offer fewer chart-editing controls than the desktop app; if the needed combo or axis options are unavailable, open the workbook in the desktop version of Excel and edit the chart there.

Frequently Asked Questions

How do I add a secondary axis in Excel?
Select the chart, choose Chart Design > Change Chart Type > Combo, and check Secondary Axis beside the series that needs its own scale. You can also right-click the series, choose Format Data Series, and select Secondary Axis under Series Options.

Can an Excel combo chart have two secondary axes?
A standard combo chart can use a primary and a secondary vertical value axis. The chart may also offer a secondary horizontal axis in particular chart configurations, but that is a separate setting and is not usually needed for a column-and-line chart. Avoid adding another scale unless it serves a clear purpose.

Why is the secondary axis option grayed out?
Check that you have selected a data series and are editing a chart type that supports the setting. Open the chart’s combo settings or select the series itself before opening Format Data Series. If you are using Excel for the web, try the desktop app if its available chart controls do not expose the option.

Can I use a secondary axis for percentages?
Yes. A common example is showing a count or dollar amount on the primary axis and a percentage on the secondary axis. Format the secondary scale as a percentage, label it clearly, and check whether the source values are stored as fractions such as 0.04 for 4%.

Does a secondary axis make two series directly comparable?
No. It makes both series visible using separate scales, but their positions and apparent slopes depend on each axis’s bounds and units. Use the chart to examine patterns only when appropriate, and use clearly labeled scales or separate charts when direct magnitude comparison matters.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.