Keep Pivot Table custom chart type

[Guest]

I'm creating a pivot table custom chart type "Line - Column on 2 Axes". The
chart looks great when I create it. The problem is when the user does
anything to the chart (filters the data, adds a new flield of data, etc.),
the chart changes to where both data series are displayed as bar charts and
the second axis is gone. I can't find an event that fires when they modify
the chart, so I don't know that I can programatically change it back. Is
there a way to keep it from changing in the first place? I'm using Excel 2003.

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
http://support.microsoft.com/?id=215904

 

[Guest]

Thanks for the reference. The problem is that I've written an application
that sits on a user's desktop. When the user changes the data, what event is
raised that I can use to kick off the macro?

Thanks!

 

[Debra Dalgleish]

Assuming the pivot chart is on a chart sheet, you can use the
Chart_Calculate event.