Combo Pivot Chart in Excel: What Works and How

A combo PivotChart cannot be created directly in Excel for Microsoft 365: PivotCharts do not support combining chart types, such as columns and a line. To get the same result, build a regular combo chart from a helper range linked to or copied from the PivotTable; the chart can then show, for example, sales as columns and a percentage as a line.

What a combo PivotChart means

A combo chart displays two or more data series using different chart types in one chart. A common arrangement uses columns for amounts and a line for a rate or percentage. The purpose is to compare measures that share categories but may have different scales. For instance, monthly revenue and monthly profit margin can appear together, even though revenue is measured in dollars and margin is measured as a percentage.

A PivotChart is a chart connected to a PivotTable. Its fields and categories can respond to PivotTable filtering, grouping, and slicers. That interactivity is useful, but Excel restricts some chart options for PivotCharts. In particular, you cannot set one PivotChart series to columns and another to a line through the normal Combo chart setup. This is not a matter of choosing the right chart style: the combo option is unavailable for a PivotChart.

People often use “combo pivot chart” to mean either a PivotChart that combines chart types or a combo chart made from PivotTable results. The first is not supported directly; the second is a practical workaround, provided you understand how the chart responds when the PivotTable changes.

When a combination chart is useful

Use a combo chart when you want to compare measures that belong together but communicate differently. A column series is usually good for totals or counts, while a line can make a trend or rate easier to follow. A secondary vertical axis may help when the measures have very different numerical ranges, but it should be used carefully because two scales can make a relationship look stronger or weaker than it is.

Imagine a PivotTable summarizing monthly sales by region. It contains total sales and the percentage of sales returned. A chart with sales as columns and return rate as a line can reveal months when high sales coincide with a higher return rate. A chart with both series as columns might make the small percentage values hard to see, while plotting both against one axis would make their scales difficult to compare.

Columns plus a line: Compare a total, such as units sold, with a rate, such as conversion percentage.
Columns on separate scales: Compare two totals with substantially different magnitudes, if the second axis is clearly labeled.
Two lines: Compare trends where the order and movement over time matter more than individual totals.

A combo chart is not automatically clearer. If the measures do not have a meaningful relationship, placing them together can confuse readers. A separate chart, a small table, or a carefully labeled single chart may be more honest and easier to read.

Prepare the PivotTable output

First, make the PivotTable summarize the fields the chart needs. For a monthly example, place Month in Rows and Sales and Returns in Values. If the second measure is meant to be a percentage, make sure it is actually calculated as a rate rather than a raw count. A percentage of total and a percentage change answer different questions, so choose the calculation that matches the story you want the chart to tell.

Keep the summary simple. A chart based on many row categories, subtotals, and grand totals can become cluttered or plot totals as though they were ordinary months. Decide whether the chart should include all regions or one selected region, and whether totals should be excluded. Check that each category has one value per series and that blank cells or text entries are not being treated as numbers.

For the most predictable workaround, create a helper range outside the PivotTable. Give it clear headings such as Month, Sales, and Return rate. You can copy the displayed PivotTable results and paste them as values when you want a static snapshot, or build a linked range that refers to the relevant PivotTable cells if you want the displayed values to update. Keep the helper range separate from the PivotTable so a refresh or expansion does not overwrite it.

Create a regular combo chart from the results

On Excel for Microsoft 365 on Windows, select the helper range, including its headings, and choose Insert > Recommended Charts > All Charts > Combo. Choose the chart type for each series—for example, Clustered Column for Sales and Line for Return rate. If the units differ greatly, select the secondary-axis option for the rate series. Confirm the chart setup, then give the chart a descriptive title and label the axes so readers can tell what each scale represents.

Prepare a clean range with categories in the first column and one column for each measure.
Select the full range, including the column headings.
Open Insert > Recommended Charts, then choose the All Charts tab and Combo.
Assign a chart type to each series and enable a secondary axis only where it improves legibility.
Review the legend, axis labels, number formats, and chart title before sharing the workbook.

Do not select a cell inside the PivotTable and then choose Insert PivotChart expecting the combo option to appear; that creates a PivotChart, which has the limitation described above. Use a separate helper range to make a standard chart instead. Excel for Mac offers chart-insertion options through the Insert tab as well, although the exact layout can vary by release. The key distinction is the same: create a regular chart from a separate range, not a PivotChart. Excel for the web may expose fewer chart-formatting controls than the desktop application, so use desktop Excel if you cannot find the combo settings.

Keep the chart current after a refresh

A normal chart does not inherit all of a PivotChart’s field behavior. If you copy the PivotTable output as values, the chart will continue to show that snapshot until you replace the helper data. This is simple and reliable for a report that is refreshed manually, but it is not a live connection to the PivotTable.

A linked helper range can display updated values when the referenced PivotTable cells change. However, a PivotTable may gain or lose categories after a filter change or refresh. If the helper range does not account for those changes, the chart may omit new categories, include blank rows, or continue to show old categories. Check the chart’s source range after changes to the PivotTable layout.

For a stable monthly report, one useful routine is to refresh the PivotTable, check the categories, update or review the helper range, and then inspect the chart. If the chart must respond immediately to PivotTable filters and slicers, a PivotChart may be more suitable, but you will need to choose a chart type it supports rather than a combo. Another option is to create separate charts for the measures and place them together with consistent category order and formatting.

Choose axes and formatting carefully

A secondary axis can make a rate visible beside a large total, but it creates two vertical scales. Readers may assume that the apparent height or crossing point of a line has a direct numerical relationship with the columns, even though each series is scaled independently. Label both axes with units, such as “Sales ($)” and “Return rate (%)”, and explain the measures in the chart title or a note.

Use the secondary axis because the units or ranges genuinely require it, not merely to make every series prominent. If the measures use the same unit and are close in range, a single axis may be clearer. If a percentage line is hard to read, check the percentage values and axis bounds before changing the scale; an unnecessarily compressed or truncated axis can exaggerate small differences.

Also use color and markers consistently. A distinct line color, visible markers, and a concise legend help distinguish the rate from the columns. Avoid relying on color alone when the chart may be printed in grayscale. Remove redundant gridlines and avoid a three-dimensional chart style, which can make comparisons harder rather than more informative.

Common problems and how to fix them

The Combo option is missing or unavailable: Check whether the selected chart is a PivotChart. Make a regular chart from a separate helper range instead.
The line is almost flat: The series may be plotted against the scale for a much larger measure. Consider a secondary axis and label it clearly.
The chart includes Grand Total: Exclude the total from the helper range unless comparing a total with individual categories is intentional.
New months do not appear: The helper range or chart source may not include the new PivotTable rows. Expand or update the range and review the chart.
Filtering does not change the chart: A regular chart based on a static copy is not connected to PivotTable filtering. Use linked helper data, update the copy, or use a PivotChart with a supported chart type.
Percentages look like decimals: Check the number format and verify that the source measure is a rate. Formatting a count as a percentage does not convert it into a meaningful rate.

When the chart looks wrong, inspect the source data before adjusting colors or scales. A missing month, a duplicated category, or a subtotal included as a data point can create a misleading chart that formatting cannot repair.

Alternatives to a combo PivotChart

If interactive filtering is the priority, use a standard PivotChart and select a chart type appropriate for the main measure. You can put the related percentage in a separate line chart beside it, using the same categories and filter context where possible. This keeps the visual scales independent and avoids implying that the two measures share an axis.

If the combo appearance is essential, the regular chart plus helper range is usually the most direct option. Use a static copy when you need a fixed report or presentation; use linked cells or another maintained helper range when updated values matter. If you need a dashboard that reacts to slicers while showing mixed chart types, consider whether separate charts, a carefully designed dashboard layout, or a different reporting tool better meets the requirement. A workaround should not be presented as a native PivotChart feature.

Frequently Asked Questions

Can you make a combo chart directly from a PivotTable?
Excel does not support a combo chart as a PivotChart. You can create a regular combo chart from a separate range containing PivotTable results, but it will not have every PivotChart interaction automatically.

How do I add a secondary axis to a PivotChart?
You cannot use the secondary-axis setting to turn a PivotChart into a combo chart. Make a regular chart from helper data, open the Combo chart setup, and assign the relevant series to a secondary axis.

Will a combo chart update when I refresh the PivotTable?
It depends on how the helper range is built. A pasted-values range stays as a snapshot until updated. A linked range can reflect changed cell values, but may need attention if the PivotTable gains or loses categories.

Can slicers control a regular combo chart?
A slicer is designed to filter connected PivotTables and PivotCharts, not an ordinary chart directly. A regular chart can reflect changes if its source helper range updates, but do not assume that selecting a slicer will control it like a PivotChart.

Should the line always use a secondary axis?
No. Use a secondary axis only when the measures’ units or ranges make a shared scale unreadable. Label both axes and consider separate charts if two scales could mislead the audience.

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.