Hi

This is a know problem.

XL2000: Changing a PivotChart Removes Series Formatting (215904)
http://support.microsoft.com/?id=215904

Cheers
Andy

TonyJD wrote:
When I create a pivot bar chart there are preset default colours. I can
change the colours but when I refresh the data the colours change back to the
original ones. How do I keep the same colours?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info