pivot table chart color formatting wont stay

[Guest]

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!

 

[Guest]

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

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q215904