ExcelBanter - Maintaining colours in a pivot chart

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Maintaining colours in a pivot chart (https://www.excelbanter.com/excel-discussion-misc-queries/212050-maintaining-colours-pivot-chart.html)

Kelly H[_2_]

Maintaining colours in a pivot chart

I have changed the colours in my pivot chart but every time I refresh my data
it reverts back to the original colours. How can I stop this from happening
please?

Herbert Seidenberg

Maintaining colours in a pivot chart

Excel 2007
PivotTable Options:
Check: Preserve cell formatting on update.

All times are GMT +1. The time now is 09:48 PM.