Excel Combo Chart Not Available? Causes and Fixes

Yes—Excel for Microsoft 365 on Windows includes combo charts. If the Combo option is missing, try selecting a regular chart and choosing Chart Design > Change Chart Type > Combo; if the source is a PivotChart or you are using Excel for the web, the feature may be unavailable or limited there.

What a combo chart does

A combo chart displays two or more data series using different chart types in the same chart area. A common example is columns for monthly sales and a line for profit margin. The columns make it easy to compare sales totals, while the line shows how the margin changes over time.

Combo charts are especially useful when series have different units or scales. Excel can put one series on a secondary vertical axis, such as dollars on the left and a percentage on the right. That can make both series readable, but the extra axis needs clear labels: it changes the scale viewers use to interpret the line.

A combo chart is not simply any chart with two series. If both series use the same type, such as two column series, it is an ordinary chart. The combo option lets you assign a chart type to each series—for example, clustered columns for revenue and a line for margin.

Where to find Combo in Excel for Windows

In the Microsoft 365 desktop app for Windows, the quickest route is to select the data and use Insert > Insert Combo Chart in the Charts group. Choose a suggested combination, such as Clustered Column – Line. If you do not see that button, use the chart-type dialog instead:

Select the chart, or select the data range if you have not made a chart yet.
Choose Insert > Recommended Charts, then open the All Charts tab. Alternatively, select an existing chart and choose Chart Design > Change Chart Type.
Select Combo in the list of chart categories.
For each series, select a chart type. Tick Secondary Axis for a series that needs its own scale, then select OK.

The exact button layout can vary with window size and ribbon customization. The Change Chart Type dialog is a useful fallback because it gives access to combo settings even when the prominent Insert Combo Chart button is not visible. If the ribbon is simplified or collapsed, expand it or use the command search box to look for Change Chart Type.

Prepare the data so Excel can combine series

Excel needs a clear category field and numeric series. For a monthly chart, put month names in the first column and values for each measure in separate columns, with a header above each measure. For example, use columns named Month, Revenue ($000s), and Gross margin (%). Select the headers and data together before inserting the chart.

When Excel guesses the series orientation incorrectly, select the chart and choose Chart Design > Switch Row/Column. This can correct a chart that treats each month as a separate series rather than using the months as categories. Check that the horizontal axis shows the intended categories and the legend names correspond to the measure headers.

Use one row or column for category labels, such as dates or product names.
Keep each measure in its own series and use numeric values, not numbers stored as text.
Include headers so Excel can name the series in the legend.
For a line over columns, make sure the table has at least two measures to display.

A common example is monthly revenue of 42, 47, and 44 thousand dollars alongside gross margins of 31%, 34%, and 32%. A column-and-line combo can show the revenue amounts as columns and the margin values as a line. If the line looks flat because the revenue values are much larger, assign the margin to a secondary axis and label that axis as a percentage.

Why the Combo option may be missing

First check which Excel app and chart you are using. The desktop Windows application has the full combo-chart workflow described above. Excel for the web and older or restricted installations may offer fewer chart-creation controls. If a command is not present in the web app, open the workbook in desktop Excel and check the chart there. A managed work computer can also have a customized or simplified ribbon, so a missing ribbon button does not necessarily mean the chart type is unsupported.

Next check the chart source. Combo charts are not supported as PivotCharts in the same way as ordinary charts. If the chart is tied directly to a PivotTable, create a regular chart from a separate range containing the PivotTable results, or copy the summarized values to a normal worksheet range and build the combo chart from that range. Refresh or update that separate range as needed when the PivotTable changes.

Other common causes are a selection that does not include the intended series, an existing chart that has not actually been selected, or an unfamiliar ribbon layout. Select the chart border before opening Chart Design, and verify that the underlying range includes the category labels and both measures. If the workbook is in an older file format, save a separate copy as an .xlsx workbook and check whether the chart options become available; keep the original until you have confirmed the copy behaves as expected.

Set the chart types and secondary axis

In the Combo settings, choose the type separately for each series. A typical pairing is Clustered Column for a total and Line for a rate. Tick Secondary Axis for the rate if its values are difficult to see against the total’s scale. The secondary axis is a second vertical scale, usually shown on the right side of the chart.

You can also change an individual series after creating the chart. Select the chart, open Chart Design > Change Chart Type > Combo, and adjust the series settings. To refine the axis, right-click the relevant axis and choose Format Axis. Set an appropriate number format—such as Percentage for margin—and add axis titles using Chart Design > Add Chart Element > Axis Titles.

Do not use a second axis just because Excel offers one. It is most defensible when the measures have different units, such as dollars and percentages, and the chart labels make the distinction obvious. Two independent scales can make a small movement in one series appear as large as a major movement in another. State the units, preserve the data labels or legend where useful, and avoid implying that the two axes share a common scale.

Excel for Mac and Excel for the web

Excel for Mac also has combo-chart controls in current desktop releases, though the ribbon arrangement can differ from Windows. Select the chart and look under Chart Design > Change Chart Type for the Combo category. If creating a chart from data, use the Insert chart options and then change its type if Combo is not offered directly. The key check is whether the chart-type dialog includes per-series types and a secondary-axis choice.

Excel for the web does not always expose the same chart types and detailed per-series controls as desktop Excel, and availability can depend on the current web experience. If you can view a chart but cannot create or configure its combination, choose Open in Desktop App and make the change in Excel for Windows or Mac. When the workbook is later opened in the browser, check that the chart still displays as intended.

Alternatives when you cannot use a combo chart

If your chart source must remain a PivotChart, or you cannot access desktop Excel, choose an alternative that preserves the message without disguising the data:

Use two charts: Put the measures in aligned charts with the same category axis. This is often clearer than a dual-axis chart when readers need to compare trends.
Use a single measure: If one series is only supporting context, show it as a label, a separate KPI, or a note instead of forcing it into the chart.
Create a regular chart from summarized values: Copy or reference the PivotTable output in a normal range, then build a combo chart from that range. Remember that a copied snapshot will not automatically reflect later PivotTable changes unless the values are refreshed or linked.

A secondary axis is not itself an alternative chart type; it is an option within many combo charts. If a chart is meant for a report, test whether the intended pattern is still understandable in grayscale and when printed or resized. Separate charts can be more accessible and less likely to confuse readers when scales differ substantially.

Frequently Asked Questions

Why is Combo grayed out in Excel?
Check whether you selected a PivotChart, whether the chart itself is selected, and whether the data includes multiple series. If you are in Excel for the web, open the workbook in the desktop app to check for the full chart controls.

Can I make a combo chart from a PivotTable?
A PivotChart does not support the normal combo-chart workflow. Make a regular chart from a separate range of summarized values instead, and plan how that range will be updated after the PivotTable refreshes.

Can I add a secondary axis without changing chart type?
Some chart types allow a series to use a secondary axis, but the usual combo workflow is to open Change Chart Type, select Combo, and tick Secondary Axis for the relevant series. Label the axis with its units.

Why does my combo chart show the wrong series or categories?
Confirm that the selected range includes the intended headers and category labels. Then try Chart Design > Switch Row/Column and review the legend and horizontal axis labels.

Is a combo chart available in Excel for the web?
Web chart controls may not include the full combo options available in desktop Excel. If you cannot choose chart types per series or set a secondary axis, open the workbook in the desktop application.

A quick troubleshooting order

When Combo appears unavailable, use this sequence rather than rebuilding the workbook immediately:

Confirm that you are using desktop Excel, if possible, and that the workbook is not being opened in a restricted view.
Select the chart and try Chart Design > Change Chart Type > Combo.
Check whether it is a PivotChart; if so, use a normal worksheet range as the source for a regular chart.
Verify that the selected data contains the category labels and at least two numeric series.
Try saving a copy in .xlsx format if the workbook uses an older format, then check the copy.

These checks distinguish a hidden command from a genuine limitation of the chart source or Excel version. Once the chart is available, choose a type for each series and use a secondary axis only when it improves readability.

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.