Excel Pivot tables and charts

[Pauleze]

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]

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.aspx?scid=kb;EN-US;Q215904 >

Cheers
Andy