How can I solve this problem if I am using the PivotChart webpart in
Sharepoint?

"Debra Dalgleish" wrote:

This is a known problem with PivotCharts. There's information in the
following MSKB article, which suggests recording a macro as you apply the
formatting:

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

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


"EOCLCV" wrote:

How can I stop a chart reformatting when I refresh a pivot table