Maintain colour changes in a Pivot Chart when changing Pivot value

[rdickfos]

How do i maintain colour changes and formatting in a Pivot Chart when I
change or update the pivot table (or drop down boxes)?

 

[Andy Pope]

Hi,

See MSKB article, XL2000: Changing a PivotChart Removes Series
Formatting (Q215904) .
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q215904

Cheers
Andy