Pivot Chart - Lost Formatting

[Deb]

Hi there,

I have created a pivot chart (stacked column) in which I
also use a secondary axis represented as a line. My
problem is this. Whenever I change my data or criteria
(via the pivot table drop downs)my secondary axis
disappears from the chart.

I am very new to the whole pivot chart thing so am I
missing something simple here?

Help!

Thanks,

Deb

 

[Debra Dalgleish]

This is a known problem pivot chart formatting. 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