software

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, it’s driving me crazy.

Is there a way to stop it reformatting everything and making it keep my
changes?

--
Thanks,
Rob E.

Hi,

This is a know problem.

Changing a PivotChart removes series formatting in Excel
support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

Rob E wrote:
gt; I am using pivot charts to make lots of mini charts from a large set of data.
gt; Every time I add to the data and refresh the charts they lose their
gt; formatting and I have to go through and reformat everything! I have to change
gt; the colours and the font size, it’s driving me crazy.
gt;
gt; Is there a way to stop it reformatting everything and making it keep my
gt; changes?
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info