how do I keep my data series colour when I refresh a pivot chart

I changed the colours on the data series on my pivot chart but when I
refreshed the data it switched the colours back to the defaults. How can I
stop this?

Hi,

Loss of formatting is a know bug.
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

reghog wrote:
> I changed the colours on the data series on my pivot chart but when I
> refreshed the data it switched the colours back to the defaults. How can I
> stop this?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info