|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
04-08-2005, 05:06 PM
|
|||
|
|||
|
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! 
|
|
#2
04-08-2005, 05:06 PM
|
|||
|
|||
|
Re: Keep Pivot Table custom chart type
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
|
|
#3
04-08-2005, 05:06 PM
|
|||
|
|||
|
Re: Keep Pivot Table custom chart type
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 > >
|
|
#4
04-08-2005, 05:06 PM
|
|||
|
|||
|
Re: Keep Pivot Table custom chart type
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
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
