Keep Pivot Table custom chart type
 

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!

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



Jeff M wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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" wrote:

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



Jeff M wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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


Jeff M wrote:
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" wrote:


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



Jeff M wrote:

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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html