Keep Pivot Table custom chart type

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!
 
Assuming the pivot chart is on a chart sheet, you can use the
Chart_Calculate event.
 
Back
Top