How do I lock the colours in a chart (red, amber, green)

C

czapla2209

I have a Pivot Table Chart that is showing the red, amber and green status of
accounts. But everytime I refresh my data I loose the chart colours so I
have to change the colours back to red, amber and green. Is there a way of
locking those colours so that when I refresh the data the colour formatting
isn't lost?
 
P

Peter T

You could customize your workbook's palette colours
Tools, Options, Color

I guess you may want to customize the first three in 6th row of the palette,
chart fills.

Having done that you shouldn't need to reformat your chart colours.

Regards,
Peter T
 

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 charts background with 3 different colours? 0
Conditional chart 1
Colour gradients in charts 2
How can I customise colours used in charts and keep those colours. 2
How do I change the shadow color on a 3-D chart/Graph 2
How do i define cells in different colours 1
Default Colours in a Bar Graph 2
How do i change the stack of colours chart to values not percent? 1

Top