chart of pivottable

[Guest]

I made a chart of a pivottable. This works. But when I have a selection in
page field (f.i. a country), that does not contain all the rows (f.i. only
three months out of 12), I get a graph with only that rows (3) selected. So
far no problems. But when I change the selection in page field again to a
complete pivot with all the rows(all 12 months) the format (colors,
graphtype, etc.) has changed. This is why, and how to avoid???

 

[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:

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