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!