If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot table/ Pivot chart view | TRS_JC | General Discussion | 0 | February 2nd, 2005 08:47 PM |
Pivot Table Zero Value | jcliquidtension | General Discussion | 0 | January 13th, 2005 04:21 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Chart from Pivot table | Adam | General Discussion | 1 | June 23rd, 2004 12:58 PM |
Pivot Chart affected when refresh data | Ailing | Charts and Charting | 1 | January 15th, 2004 11:20 AM |