Pivot Chart

[Guest]

I want to maintain my selected color for the pivot chart. But, when i filter
the chart, the selected color will refresh back to default color.

Any idea to keep my selected color for the pivot chart even i refresh the
chart?

Thanks.

 

[Debra Dalgleish]

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:

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