Excel Pivot Chart Colors Keep Changing? Fix the Cause

Excel PivotChart colors usually change because filtering, refreshing, or rearranging fields changes which series are displayed or their order, so Excel reapplies chart colors. To stabilize them, set the chart’s color palette first, then format each series individually; if the chart must keep exact colors through changing fields, consider a regular chart built from a stable helper range instead.

Why PivotChart colors change

A PivotChart is tied to a PivotTable, and the chart responds when that table’s fields, filters, or source data change. A series that appears as the first series today may become the second tomorrow, or a series may disappear when a slicer or filter excludes its data. Excel can then assign colors according to the chart’s current series order and theme palette. The result can look like Excel randomly changed a color, even though the chart’s structure changed.

For example, imagine a chart with one series for each product: Bikes, Helmets, and Locks. If a filter hides Bikes, Helmets may move into the first visible position. Depending on the chart and how its series are represented, the color sequence can shift. When Bikes is shown again, the chart may not display the exact color arrangement you expected.

Other triggers include adding a new field to the Legend (Series) area, changing the chart type, changing the workbook theme, copying the chart, or applying a chart style. A refresh alone may not always change colors, but it can expose a change in the PivotTable’s items or series that causes the chart to be redrawn.

How Excel assigns chart colors

For a typical column, bar, or line PivotChart, Excel assigns colors to data series using the chart’s color scheme and theme. In a chart with several product series, each product is a series. In a chart with one series and many categories, the categories may share one color. Pie and doughnut charts are different: their individual slices are points in a single series, and Excel commonly gives those points separate colors.

This distinction matters when applying a fix. If every product needs a specific color, format the series. If every department or region is a category within one series, changing the series fill may color every column alike. For charts that use distinct colors for individual points, select the specific point rather than the whole series before changing its fill.

Theme colors also matter. The workbook theme supplies the chart’s coordinated palette. Applying a different theme, choosing a different option under Chart Design > Change Colors, or applying a chart style can change the colors shown. A custom color may remain in place in many situations, but changing the chart design or altering the series structure can still affect how the chart is displayed.

Check what is actually changing

Before reformatting the chart, identify whether the change follows a refresh, a filter, a field rearrangement, or a theme change. If colors change only after selecting a slicer, the likely cause is that the visible series set or order has changed. If every chart in the workbook changes at once, check whether the workbook theme or chart color palette was changed. If only one series changes after a refresh, check whether its name or position in the PivotChart changed.

Also check whether the color change is limited to one chart type. Switching between a line chart and a stacked column chart can change which series or points Excel treats as independently colored. A chart style can alter more than color, so compare the chart before and after applying it.

Note which action happened immediately before the color changed: refresh, filter, slicer selection, field movement, or theme change.
Look at the PivotChart’s Legend (Series) entries and confirm that the series names and order are still what you expect.
Check whether the chart uses one series with many categories or several series. That determines what you need to format.
Try clearing the filter or selecting all slicer items. If the original colors return, the change is linked to the visible series arrangement.

Set colors for individual series

In Excel for Microsoft 365 on Windows, select the PivotChart and click one data point once to select its series. Right-click and choose Format Data Series. In the formatting pane, open Fill & Line, expand Fill, choose Solid fill, and select a color. Repeat for each series that needs a fixed color. For a line chart, you may also need to set the line color under the Line controls; a fill color alone does not recolor a line.

Take care when selecting. One click on a column generally selects the whole series; clicking the same column again selects just that individual point. If the chart contains many overlapping series, use the Current Selection list on the Format tab to choose the intended series, then choose Format Selection. Once selected, verify the series name in the formatting pane before changing its color.

A practical order is to settle the chart type, theme, and color palette first, then assign the individual series colors. This reduces the chance that a later palette change will undo or visually alter your chosen scheme. Use color names or a documented mapping—for example, North = blue and South = orange—so it is easier to restore the intended design if a structural change does reset it.

Excel for Mac has comparable chart formatting controls, although the ribbon and pane placement can differ by release. Select the series and use the Format Data Series controls to set its fill or line. In Excel for the web, available chart-formatting options may be more limited; if a control you need is missing, open the workbook in the desktop app.

Choose a palette before applying custom colors

For a coordinated set of colors, select the chart and go to Chart Design > Change Colors. Choose a palette that fits the workbook and is easy to read, then apply custom series colors if needed. This is useful when the chart has several series and you want consistent contrast without choosing every shade from scratch.

Changing the workbook theme can affect more than one chart, which may be helpful for a whole report but is a poor quick fix for just one PivotChart. If only one chart needs different colors, use its chart palette or format its series rather than changing the workbook’s theme. Be cautious about applying a new chart style after custom formatting: some styles can change the chart’s appearance, and it is worth checking the series colors afterward.

For a report used by a broad audience, do not rely on color alone to distinguish important series. Add clear legend labels, use readable contrast, and consider markers or different line styles where appropriate. Similar shades can be difficult to tell apart, especially when a chart is printed in grayscale or viewed by someone with color-vision deficiencies.

What refresh settings do—and do not—preserve

Excel’s PivotTable setting Preserve cell formatting on update applies to formatting in the PivotTable cells. On Windows, right-click a cell in the PivotTable, choose PivotTable Options, open Layout & Format, and select Preserve cell formatting on update. This can help retain cell formatting when the PivotTable updates, but it is not a setting that guarantees PivotChart series colors will stay fixed.

Similarly, Refresh and Refresh All update PivotTable data; they are not color-lock commands. If a refresh adds a new product, removes an item, or changes which series are present, the PivotChart may need to redraw its legend and colors. Keeping the PivotTable cell-formatting option enabled is reasonable when you want the table’s own formatting preserved, but do not treat it as a solution to chart color changes.

After a refresh, check whether the series have kept their intended names and whether any new items have appeared. If the chart’s structure has genuinely changed, reapply the series formatting and then test the filters and slicers you expect people to use. Testing with more than one filter state helps reveal color shifts before sharing the workbook.

When a regular chart is a better alternative

If exact color-to-category mapping is essential and the PivotChart keeps reassigning colors as users filter or rearrange fields, a regular chart can offer more control. One approach is to create a stable helper range that displays the results you want to chart, then build a standard chart from that range. The helper range can refer to PivotTable results, but its rows and series should be arranged consistently so the chart’s series identities do not change unexpectedly.

A standard chart is not automatically immune to problems. If its source range expands, contracts, or changes order, colors can still be affected. The benefit is that you can design the chart around a fixed set of series rather than letting PivotChart field changes redefine the chart. This approach is often useful for a presentation or dashboard where the visual mapping must remain consistent. A PivotChart is usually more convenient when users need to explore and filter PivotTable fields directly.

Another option is to keep the PivotChart but limit which fields users can move into Legend (Series), and use slicers or report filters for the intended choices. That does not guarantee every color will remain unchanged, but it reduces structural variation. Choose the approach based on whether interactive PivotTable analysis or a stable visual design matters more.

Common mistakes to avoid

Formatting the PivotTable instead of the chart: Cell fill colors in the table do not set the PivotChart’s series colors.
Changing the palette after custom formatting: Choose the chart palette first, then apply individual colors and verify them afterward.
Selecting a point when you meant to select a series: A second click on a data point can select just that point, leaving the other points in the series unchanged.
Assuming a slicer only hides marks: Filtering can change which series are displayed, so it may also affect the chart’s color assignment.
Expecting Preserve cell formatting on update to lock chart colors: That option preserves PivotTable cell formatting, not a guaranteed PivotChart color mapping.

Frequently Asked Questions

Why do my Excel PivotChart colors change when I use a slicer?
A slicer filters the PivotTable and can remove or change the order of visible chart series. Excel may then apply its color sequence to the current series arrangement. If colors must remain fixed, format each series and test the chart with the slicer selections people will use.

Can I permanently lock a PivotChart color?
There is no general PivotChart setting that guarantees a series color will stay assigned through every field change and refresh. Manually formatting series can help, but structural changes may still require checking or reapplying the colors. A standard chart based on a stable helper range may be preferable when the mapping must be dependable.

Does Preserve cell formatting on update fix PivotChart colors?
No. That PivotTable option concerns cell formatting in the PivotTable. It does not promise to preserve the PivotChart’s series colors after filtering, refreshing, or changing fields.

Why does one category change color while the others do not?
That category may be a separate series, a newly displayed item, or an individual point in a single series. Check the legend and selection in the formatting pane. Format the whole series if all its points should match, or select one point if only that category needs a different color.

Will changing the workbook theme affect my PivotChart?
It can. Chart colors are tied to the workbook’s theme and chart palette, so changing the theme may alter chart colors. If you want to preserve a particular appearance, check the chart after a theme change and reapply any necessary series colors.

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.