Keep an Excel Combo Pivot Chart After Refreshing Data
Question details
The user wants an Excel combo PivotChart to retain its chart types after filtering or refreshing its source 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.
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.
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.
In Excel, select File > Account and note the version and build shown under Product Information.
Select the chart, then open Chart Design > Change Chart Type. Record the chart type assigned to each series and any secondary-axis settings.
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.
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.

Create a regular combo chart from PivotTable results
Use a regular chart as a workaround when the PivotChart does not retain the desired combination.
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.

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.




