Hi,
This is a know problem.
Changing a PivotChart removes series formatting in Excel
http://support.microsoft.com/default...;EN-US;Q215904
Cheers
Andy
Rob E wrote:
I am using pivot charts to make lots of mini charts from a large set of data.
Every time I add to the data and refresh the charts they lose their
formatting and I have to go through and reformat everything! I have to change
the colours and the font size, its driving me crazy.
Is there a way to stop it reformatting everything and making it keep my
changes?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info