keep properties in pivot chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luz - 31 Mar 2004 21:05 GMT

How can I keep the properties in a pivot chart, like the
color of the graphic, after I choose other option on the
chart?

Reply to this Message

Debra Dalgleish - 31 Mar 2004 21:44 GMT

This is a known problem in Excel 2000. There's some info 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

> How can I keep the properties in a pivot chart, like the
> color of the graphic, after I choose other option on the
> chart?

Signature

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

Reply to this Message