pivot table chart color formatting wont stay

Hi,

I have a bar chart based on a pivot table. I have changed the colours of the
bars from the default that Excel used. But if I change the values in the x/y
axis e.g by unclicking one option then the default colours are restored! how
can i stop this happening?

e.g. I have 5 dates on the x axis, if i unselect one to dissplay only 4, the
coulour for the bars of the remaining 4 all revert back to the default, weird
isnt it?

thanks for any help!

this is a knows problem with a not very effective workaround:

http://support.microsoft.com/default...;EN-US;Q215904

"confused" wrote:

> Hi,
>
> I have a bar chart based on a pivot table. I have changed the colours of the
> bars from the default that Excel used. But if I change the values in the x/y
> axis e.g by unclicking one option then the default colours are restored! how
> can i stop this happening?
>
> e.g. I have 5 dates on the x axis, if i unselect one to dissplay only 4, the
> coulour for the bars of the remaining 4 all revert back to the default, weird
> isnt it?
>
> thanks for any help!