Excel Combo Chart Not Working? Fix the Common Causes

To create a combo chart in Excel for Microsoft 365 on Windows, select your data, choose Insert > Recommended Charts > All Charts > Combo, assign a chart type to each series, and select Secondary Axis for any series that needs a separate scale. If the Combo option is missing or the chart looks wrong, the usual causes are an unsupported chart or data source, an unsuitable selection, or series that need different axes.

Try the quickest route first

A combo chart combines two or more chart types in one chart—for example, columns for monthly sales and a line for the percentage growth rate. The easiest way to build one is to select a rectangular data range that includes the category labels and all the series you want to plot, then open Excel’s chart insertion options.

Select the data, including its header row and the labels for the horizontal axis.
Choose Insert > Recommended Charts, then open the All Charts tab in the dialog.
Select Combo, choose a chart type for each series, and check Secondary Axis where appropriate.
Choose OK. Select the chart afterward to add a title, labels, or other formatting.

If you already have a chart, select it and choose Chart Design > Change Chart Type > Combo. This changes the existing chart rather than inserting another one. The Chart Design tab is a contextual tab, so it appears only when a chart is selected. If you cannot see it, click the chart once.

Check the data layout and selection

Excel needs to identify which values are categories and which are separate data series. A simple layout—with one header row, one label column, and numeric values in the body—makes that easier. For example, put months in column A, Sales in column B, and Margin % in column C. Select all three columns, including their headers, before inserting the chart.

If Excel treats each month as a separate series, or plots the series names as categories, the selection may be incomplete or oriented the wrong way. Select the chart and use Chart Design > Switch Row/Column to see whether the alternative arrangement makes sense. You can also use Chart Design > Select Data to inspect the chart’s data range, edit a series, or correct the category labels.

Look for these common layout problems before changing chart settings:

Missing headers: Without clear series names, the legend may show generic labels or incorrect entries.
Numbers stored as text: Values that Excel reads as text may not plot as expected. Check for leading apostrophes, imported spaces, or inconsistent decimal separators.
Blank or mixed rows: Extra title rows, totals, or blank columns can cause Excel to guess the wrong range.
Unwanted totals: A grand-total row can distort the scale. Exclude it if it is not a genuine category to compare.
Dates treated as labels: Confirm that the first column contains the intended dates or category names, not a second numeric series.

For a useful example, imagine monthly revenue values near 20,000 and a margin percentage between 10% and 30%. Plotting both as columns on one axis makes the percentage appear tiny or makes the chart scale confusing. A column series for revenue and a line series for margin, with a secondary axis for the percentage, communicates the two measures more clearly.

Understand chart types and series

A combo chart is not a single fixed design. It lets you choose a type for each data series, so one series might be a clustered column while another is a line. Excel’s available combinations depend on the chart options supported by the application and the chart you are editing. Start with familiar two-dimensional types such as column and line if a more unusual combination is unavailable.

In the Combo settings, each series has its own chart-type choice. Make sure you assign the type to the intended series by checking the series names in the list; do not rely only on the order you remember from the worksheet. A common design is columns for volume or totals and a line for a rate, target, or trend. The visual distinction helps readers compare unlike measures without suggesting that they are the same kind of quantity.

Some chart types and chart sources have restrictions. Three-dimensional chart types are not suitable for a standard combo chart, and Excel does not offer every possible pairing in every context. If a requested type is missing, change the existing chart to a supported two-dimensional type first, or start with a standard chart and then select Change Chart Type. Avoid forcing a visually elaborate combination when a simple column-and-line chart answers the question more clearly.

When to use a secondary axis

A secondary axis gives one series a separate scale on the right side of the chart, while the primary axis remains on the left. It is useful when series use different units or have very different magnitudes, such as revenue and a percentage rate. In the Combo dialog, select the secondary-axis checkbox for the series that needs its own scale. You can also select a series in the chart, open its formatting options, and choose a secondary axis there.

Use the second axis thoughtfully. It can make a small-valued series visible, but two independent scales can also create a misleading impression: changing either axis limits may make lines look more or less closely related without changing the data. Label both axes with their units, and make the scale ranges clear. If the series share units and comparable values, a single axis is usually easier to interpret.

For the revenue-and-margin example, label the left axis as revenue in dollars and the right axis as margin percentage. Do not assume Excel’s automatic axis bounds are the best choice: inspect the starting and ending values, especially if a line appears flat or its fluctuations seem exaggerated. Readers should be able to tell which axis applies to each series from the labels and chart design, not just from color.

Why the Combo option may be missing

The first question is whether you are working with an ordinary chart or a PivotChart. Excel does not support combo chart types for PivotCharts. If the chart is based directly on a PivotTable, create a separate, regular summary range and make a standard chart from that range instead. You can prepare the summary as values or use worksheet references to the PivotTable results, then build the combo chart from those cells.

Also check whether the chart is three-dimensional or uses a chart type that cannot be combined. Select the chart and try Chart Design > Change Chart Type; if a suitable Combo option still does not appear, create a new chart from a clean range of ordinary worksheet data. A chart copied from another workbook or an older file may retain settings that make editing less straightforward.

Excel for the web, Mac, and Windows can differ in the location and completeness of chart-editing controls, and the available commands may vary with the Excel release. On Mac, select the chart and look for the chart design or chart type controls in the ribbon; the exact dialog presentation can differ from Windows. If the browser version does not show the needed combo settings, open the workbook in the Excel desktop app. Do not confuse a different ribbon layout with proof that the data itself is invalid.

Fix a chart that appears wrong

If Excel creates a chart but the result is confusing, diagnose one issue at a time rather than rebuilding it immediately. Select Chart Design > Change Chart Type > Combo and review the type and axis assignment for each series. Then use Select Data to confirm the plotted ranges and category labels.

A series is missing: Check that its cells are included in the source range and contain numeric values Excel can plot.
The legend is wrong: Edit the series name in Select Data, or correct the header cell in the worksheet.
The line is almost flat: The series may be much smaller than the primary-axis values. Assign it to a secondary axis if its units or scale justify one.
The categories run in the wrong direction: Check the source range and try Switch Row/Column.
The chart has too many marks: Reduce the number of series or categories shown. A chart with many lines and columns can be technically valid but hard to read.
Labels overlap: Widen the chart, simplify the category labels, or adjust axis-label formatting.

After changing the worksheet data, verify that the chart range still includes new rows or columns. A chart based on a fixed cell range may not automatically include data added beyond that range. Excel tables can help keep related data together as rows are added, but check the chart after expanding the table, particularly if the new data changes the number or meaning of series.

Make the result easier to read

A working combo chart still needs a clear visual hierarchy. Use columns for values that readers compare across categories and a line for a rate, target, or continuous trend. Keep the legend names concise, give the chart a descriptive title, and label axes with units such as dollars, units sold, or percent. A reader should not have to infer what the two scales represent.

Color alone is not always enough to distinguish series. Combine color with line styles, markers, or different chart forms, and check that text and marks remain legible at the chart’s intended size. If the chart is for a presentation or report, resize it after formatting; a chart that looks clear while selected and enlarged may become unreadable when placed in a document.

Consider whether the chart answers one question. A combo chart can show how two measures move together, but it does not prove that one causes the other. If the audience needs to compare exact values, a table or two separate charts may be clearer than dual axes. The best fix is sometimes to change the visualization, not to add more formatting.

Alternatives when a combo chart is not suitable

If your data comes from a PivotTable and the chart must remain a PivotChart, use a supported PivotChart type or build a separate regular chart from a summary range. If the two measures have very different units and a secondary axis would confuse readers, consider two aligned charts with matching category labels. The shared horizontal axis lets readers compare timing while keeping each measure’s scale independent.

A table with conditional formatting can be better when people need exact values, while a line chart can work when both series share units and scale. For a rate and a count, showing the rate in a separate panel may be clearer than placing it on a second axis. Choose based on the comparison readers need to make, not simply because Excel offers a combo option.

Frequently Asked Questions

Why can’t I find Combo under Change Chart Type?
Check whether the chart is a PivotChart or a 3-D chart, and try a standard chart built from a normal worksheet range. Excel’s chart controls also vary by platform and release; open the workbook in the desktop app if the web interface lacks the setting you need.

Can I combine a column chart and a line chart in Excel?
Yes. Select the data and use Insert > Recommended Charts > All Charts > Combo, then choose a column type for one series and a line type for the other. Assign a secondary axis only if the units or scales call for it.

Can a PivotChart be a combo chart?
No. Excel does not support combo chart types for PivotCharts. Make a separate regular chart from a worksheet summary range if you need to combine chart types.

Why does my percentage line look flat?
The line may be plotted against an axis scaled for much larger values, such as sales revenue. In the Combo settings, assign the percentage series to a secondary axis and label that axis clearly. Check the scale so the chart does not exaggerate the relationship.

Can I make a combo chart in Excel for the web or Mac?
Chart controls differ across Excel for the web, Mac, and Windows, and some options may not appear in the same place. On Mac, select the chart and look for chart design or chart type controls. If the browser version lacks the required options, use the Excel desktop app.

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.