Prevent auto recoloring of chart when using Pivot Table data

[Erica Andersson]

I have crated a Pivot tabel with data I want to show in a Chart. My problem
is when I refresh data the colours of the "data series" changes.

For exaple I want one of my series "OK" always be shown in green colour, but
after a refresh of pivot all colours changes.

This problem is not only colouring. If I have made changes to my chart so
that one series ar plotted on a secondary axis, and I change it to another
chart type (e.g. the secondary should be shown as a line instead of column)
this also changes when refreshing the data. Most irritating!

Anyone that knows how to prevent this "auto-changing" of Chart??

Thanks
Erica

 

[Debra Dalgleish]

Loss of formatting is a known problem with pivotcharts. There's some
info in the following MSKB article, which supports your idea of
recording a macro as you apply the formatting:

XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/?id=215904