Pivot Table Issues

Keep an Excel Combo Pivot Chart After Refreshing Data

Ayan MasoodAyan Masood Nov 20, 2026 868 views

Question details

The user wants an Excel combo PivotChart to retain its chart types after filtering or refreshing its source data.

Keep an Excel Combo Pivot Chart After Refreshing Data
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user filters or refreshes the data behind a combo PivotChart.
Observed behavior
The combo chart may revert to a standard bar chart after filtering or refreshing.
Before you start

Identify which series use each chart type and whether any series uses a secondary axis. Note the filter or refresh action that causes the chart to change.

Solution 1Recommended

Check the chart configuration and reproduce the refresh issue

Use these checks to determine whether the behavior is specific to the chart configuration, workbook, or Excel version.

1
Record the Excel version

In Excel, select File > Account and note the version and build shown under Product Information.

2
Inspect the chart types

Select the chart, then open Chart Design > Change Chart Type. Record the chart type assigned to each series and any secondary-axis settings.

3
Reproduce the behavior

Create a small PivotTable and chart in a new workbook using Insert > PivotTable and Insert > PivotChart. Apply the same chart configuration, then use the same filter or refresh action that caused the original chart to change.

4
Document the results

Capture the chart before and after the change, and record the exact steps used. If the issue persists, provide these details and the Excel version when contacting Microsoft Support.

Check the chart configuration and reproduce the refresh issue
Chart type availability: Available PivotChart types and combinations can vary by Excel version and chart configuration. If the desired combination is unavailable, try a regular chart based on PivotTable results.
Free Microsoft Office alternative

Work with spreadsheet data and charts in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move existing workbooks. It does not fix an Excel-specific PivotChart refresh issue, so check chart behavior when opening complex files.

Create and edit spreadsheet charts in a familiar interfaceOpen and work with Microsoft Excel XLSX and XLS filesUse a free, lightweight alternative for everyday spreadsheet workMove existing workbooks into WPS Office without starting from scratch
microsoft office alternative - wps office

Frequently Asked Questions

Why does my combo PivotChart change after a refresh?

The cause is not established from the reported behavior. Record the series types and axis settings under Chart Design > Change Chart Type, then test the same configuration in a new workbook to help isolate the issue.

Where can I find my Excel version?

Select File > Account and look under Product Information for the version and build. Include those details if you contact Microsoft Support.

Can I use a regular combo chart instead of a PivotChart?

Yes. Create a helper table that references the PivotTable results, select it, and choose Insert > Combo Chart. Test it after refreshing or filtering because missing categories can affect the helper formulas.

How do I restore the chart combination manually?

Select the chart and choose Chart Design > Change Chart Type. If the desired combination is available, select the type for each series and set any secondary axis, then test another refresh.