Hi,

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

Cheers
Andy

rdickfos wrote:
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, Microsoft MVP - Excel
http://www.andypope.info