Excel Combo Pivot Chart: How to Build One in Microsoft 365

Excel does not support a true combo chart as a PivotChart: you cannot combine chart types such as columns and a line directly in a PivotChart. The practical workaround is to build a regular combo chart from a helper range linked to the PivotTable, so the chart can show PivotTable results while using different chart types and, if needed, a secondary axis.

What a combo PivotChart means

A PivotChart is a chart tied to a PivotTable. Its fields can be rearranged, filtered, and grouped using PivotChart field controls, and it responds to PivotTable filters and slicers. A combo chart, by contrast, puts different chart types in one chart—for example, clustered columns for sales and a line for profit margin. It can also place one series on a secondary vertical axis when its scale differs greatly from the other series.

People often search for a combo PivotChart because the two features seem like a natural match: use a PivotTable to summarize a large dataset, then compare measures in a single chart. The catch is an Excel charting limitation, not a problem with the data. PivotCharts support several chart types, but Excel does not offer the regular chart dialog’s custom combination of chart types for a PivotChart. A PivotChart therefore cannot provide the usual column-and-line combination or its corresponding independent series settings.

The reliable workaround: chart a helper range

Create a small range of ordinary worksheet cells that displays the categories and values you want to chart, then make a regular chart from those cells. The helper range can refer to the PivotTable, which means the chart can reflect refreshed or filtered PivotTable results without being a PivotChart itself. This separation is useful: the PivotTable summarizes and filters; the regular chart handles the combination of chart types.

For example, suppose a PivotTable shows monthly revenue and profit. A regular chart could use columns for revenue and a line for profit margin. If you already have the required measures in a PivotTable, use the following general process in Excel for Microsoft 365 on Windows:

Create or refresh the PivotTable from your source data. Select a cell in the data and choose Insert > PivotTable, then choose where to place it and arrange the fields.
Set up the PivotTable with one row per category, such as month, and the measures the chart needs. Confirm that values are summarized appropriately, such as Sum of Revenue rather than Count of Revenue.
Make a separate helper range with a heading for each chart series and one row for each category. Link its cells to the PivotTable results using cell references, or copy the results and use Paste Special > Values if a non-refreshing snapshot is sufficient.
Select the helper range and choose Insert > Combo > Create Custom Combo Chart. In the chart dialog, assign a chart type to each series, such as Clustered Column for revenue and Line for margin.
If the series use very different units or scales, select Secondary Axis for the appropriate series. Confirm the chart, then add a clear title, axis titles, and a legend if they help readers interpret it.

The exact label on the Combo control can vary slightly with the ribbon layout, but the custom combination option is in the standard chart insertion options. If you start by selecting the PivotTable itself and insert a PivotChart, Excel creates a PivotChart rather than the ordinary chart needed for this workaround. Build the chart from the separate helper cells instead.

Choosing measures and axes

Choose chart types based on what the measures represent, not merely on what looks different. Columns work well for comparing totals across discrete categories, while a line can make a trend easier to follow. A secondary axis is useful when a series has a different unit or magnitude—for example, dollars alongside a percentage. It is not a way to make every series look more dramatic.

Use consistent definitions in the source and helper range. A particularly common mistake is averaging percentages when the desired result is a combined percentage. If monthly profit margins are 10% and 30%, their simple average is 20%, but the overall margin for those months depends on each month’s revenue. For a total-period margin, use total profit divided by total revenue; do not assume that averaging the monthly percentages produces the correct result. The right calculation depends on what the measure is meant to describe.

Label both axes and state the units. A line on a secondary axis can appear to track the columns closely even though the scales are different. Readers should be able to tell at a glance which axis belongs to which measure. If the chart compares measures that have no meaningful relationship, separate charts may communicate the results more honestly than a combo chart.

Keeping the chart linked to PivotTable results

A helper range made with cell references can update when PivotTable values change, but the chart is still an ordinary chart. Its category and series ranges must continue to cover the helper cells as the PivotTable changes size. If a refresh adds more months or categories than the chart range includes, the new rows may not appear automatically. If the PivotTable layout changes, fixed cell references can point to the wrong cells.

Plan the helper range around the expected categories, and check it after refreshing or changing the PivotTable layout. A fixed-size helper area can be easier to maintain than charting directly from a PivotTable that grows and shrinks. For a report with a known set of categories, reserve enough rows and make sure unused rows do not create misleading blank categories. For a report with an unpredictable number of categories, consider a more deliberately managed source range or a standard chart built directly from the underlying summarized data.

Copying and pasting values creates a static chart source: later PivotTable refreshes will not change those copied numbers. That approach is suitable for a report snapshot, but it is not a refreshable link. Cell references preserve a connection to worksheet cells, though they require attention when the PivotTable’s shape changes. Decide which behavior you want before building the chart.

What happens with filters and slicers

A regular chart does not inherit PivotChart behavior just because its source cells are near a PivotTable. A slicer connected to the PivotTable filters the PivotTable; if the helper cells reference the displayed PivotTable results, the chart can reflect those changed cell values. However, the regular chart does not acquire PivotChart field buttons or become directly controlled as a PivotChart. Its chart source still needs to cover the relevant helper range.

Test the complete report by selecting each slicer option, refreshing the PivotTable, and checking the chart’s categories and series. Pay attention to categories that disappear after filtering, empty rows, and totals. PivotTables can show grand totals that are useful in a table but inappropriate as an extra chart category. Keep those totals out of the helper range unless the chart is specifically meant to include them.

PivotChart versus a regular combo chart

Use a PivotChart when interactive PivotTable-style field filtering and rearranging are more important than combining chart types. Use a regular combo chart when the central requirement is to show different types of series together or to assign one series to a secondary axis. The helper-range method provides a middle ground: the PivotTable remains responsible for summarizing the source, while the ordinary chart supplies the combo-chart options.

There is a trade-off. A PivotChart’s close connection to its PivotTable makes it convenient to explore fields, but it does not have the combo-chart flexibility in question. A normal combo chart supports the desired visual mix, but it does not automatically gain PivotChart field controls. A chart based on a pasted snapshot is simplest but becomes stale; one based on linked helper cells can update but needs maintenance when the PivotTable structure changes.

Common problems and fixes

The Combo option is unavailable or the chart will not combine series: check whether you created a PivotChart. Create a standard chart from the helper range instead.
The line looks flat or the columns dominate: check the units and scale. If the series genuinely use different units, enable a secondary axis for the relevant series and label it clearly.
New categories are missing: expand or revise the ordinary chart’s source range after the PivotTable adds rows. The chart is not guaranteed to resize with the PivotTable.
The chart shows Grand Total as a category: exclude the total row from the helper range unless it belongs in the comparison.
Filtering produces blanks or unexpected categories: inspect the helper cells and the chart’s selected range. A regular chart can plot blank helper rows depending on its settings and source layout.
The percentage does not match the overall result: verify whether the intended statistic is a weighted overall percentage or an average of category percentages. Those are not generally the same calculation.

Excel for Mac and Excel for the web

The main limitation is not unique to Windows: a PivotChart is not the route to a standard custom combo chart on Mac either. Menu and ribbon placement can differ by Excel version and window size, so look for the regular chart’s Combo or combination-chart command after selecting the helper cells. The Windows ribbon path described above is for Microsoft 365 on Windows.

Excel for the web has a different interface and may not expose every chart-formatting control available in the Windows desktop app. If you cannot find the custom combo or secondary-axis controls in the browser, open the workbook in desktop Excel to build or refine the chart. A chart saved in the workbook can still be viewed in the web app, but available editing options can differ.

Frequently Asked Questions

Can you make a combo chart directly from a PivotTable?
No, not as a true PivotChart with different chart types assigned to its series. Create an ordinary chart from a separate helper range that references the PivotTable results.

Can a regular combo chart update when I refresh a PivotTable?
Yes, if its helper cells use references to the PivotTable’s displayed results and the chart range still covers those cells. A chart based on copied values will not update when the PivotTable refreshes.

Can I use a secondary axis with a PivotChart?
The normal custom combo-chart setup with a secondary axis is not available through a PivotChart. Use a regular combo chart based on helper cells when you need that combination.

Will a slicer control the workaround chart?
A slicer can filter its connected PivotTable, and a regular chart may reflect the changed values through linked helper cells. The chart itself is not a PivotChart and does not gain PivotChart field buttons.

Why can’t I see the Combo chart option?
You may have selected or created a PivotChart, or you may be looking in a different ribbon layout. Select the ordinary helper range and open the standard chart insertion options to choose a custom combo chart.

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.