Hi,

Loss of chart formatting wwith regards to pivot charts is a know
problem, which requires VBA to re apply recorded formatting.

XL2000: Changing a PivotChart Removes Series Formatting (Q215904)
<http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

Pauleze wrote:
How do I retain pivot chart formats that I have made (esp. column colours)
after refreshing the data on the source pivot table?

--

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