Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as
you apply the formatting:
XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/?id=215904
Or, you could create a normal chart from the data. On Jon Peltier's
site, there are instructions for creating a normal chart from pivot data:
http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm
Mark Allen wrote:
Can links between Excel 2003 Pivot Charts and their pivot table be turned off
or on? I am trying to show pivot charts for each page variable and if any
formating is changed in one of the charts they all revert back to the default
chart formatting.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html