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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Graphs 2
Pivot Chart Colours 3
Pivot Table Chart? 4
How do I lock the colours in a chart (red, amber, green) 2
Prevent auto recoloring of chart when using Pivot Table data 1
Pivot charts formatting 1
Chart Series Formats lost when list re -sorted 1
Epson Printer Problem 6

Top