Maintaining colours in a pivot chart

K

Kelly H

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?
 
H

Herbert Seidenberg

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