Chart & Visualization Issues

Prevent Excel Pivot Chart Formatting from Changing After Refresh

Jason MillerJason Miller Nov 14, 2026 868 views

Question details

The user wants an Excel Pivot Chart to retain its colors, chart type, and other formatting after the underlying PivotTable is refreshed.

Prevent Excel Pivot Chart Formatting from Changing After Refresh
Product
Microsoft Excel
Device & OS
not provided
Scenario
Refreshing a PivotTable that supplies data to a Pivot Chart.
Observed behavior
The Pivot Chart's colors and structural formatting revert to defaults after refresh, even after the user changes the PivotTable formatting options.
Before you start

Select the PivotTable connected to the chart and note its current fields, filters, and chart design. Check whether the refresh adds, removes, or rearranges data series, as this can affect how chart formatting is applied.

Solution 1Recommended

Restore the Pivot Chart design and check its series

Use this approach when PivotTable formatting options have already been tried but the chart still changes after refresh.

PivotTable cell-formatting settings do not guarantee that Pivot Chart formatting will persist. Changes to fields or series during refresh can also affect the chart's appearance.

1
Refresh and inspect the fields

Right-click the PivotTable and select Refresh. Select the Pivot Chart and check the fields and filters in the PivotChart Fields pane for changes to its series.

2
Restore the chart type

Select the chart, open Chart Design, and choose Change Chart Type. Select a supported chart type and apply it.

3
Reapply colors and formatting

On Chart Design, select Change Colors or a chart style. To adjust individual bars or lines, right-click a data series and select Format Data Series.

4
Test another refresh

Right-click the PivotTable and select Refresh again. Compare the chart with the design you applied and check whether any series were added, removed, or reordered.

Restore the Pivot Chart design and check its series
Formatting may need to be reapplied: If the chart continues to reset, standardize its design or consider rebuilding it. These steps help restore the appearance but do not guarantee that every setting will survive future refreshes.
Free Microsoft Office alternative

Work with spreadsheets and charts in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility for easier migration. Use WPS Spreadsheets to work with workbook data and charts; it does not fix Excel's Pivot Chart refresh behavior.

Create and format spreadsheet charts in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX filesUse a familiar interface for everyday spreadsheet workWork in a lightweight office suite with free features
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Pivot Chart colors change after a refresh?

A refresh can change the chart's data series, and Excel may assign formatting differently. Select the chart and check the PivotChart Fields pane, then use Chart Design > Change Colors to restore the palette.

Where is Preserve cell formatting on update?

Right-click a cell in the PivotTable, choose PivotTable Options, and open the Layout & Format tab. Select Preserve cell formatting on update and click OK.

Will disabling Autofit column widths preserve my chart colors?

No. Clearing Autofit column widths on update helps prevent PivotTable column widths from changing, but it does not guarantee that Pivot Chart colors or chart types will stay the same.

How can I restore a Pivot Chart's bars or lines after refresh?

Select the chart and choose Chart Design > Change Chart Type to restore a supported chart type. Right-click a series and select Format Data Series to adjust its appearance.