Hi folks,

I've created a pivot chart and formated it to look how I need it to be displayed.
The problem I'm facing is that anytime I change one of the perametres of the chart (ie. Date or Customer) the colour formating which I have applied to the chart automatically chages.

Any suggestions on this?

I'm useing 2003