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
|
|||
|
|||
Pivot Chart - default chart type
I created a Pivot chart from Pivot table, however, as the user changes the
options (from pivot fields), then the chart type changes back to default one (I want the line-column 2 axes one). I figured I could go to VBA properties to default the chart type by choosing the chart code, however under that list, there is no chart code for that combination chart (line chart + column chart with 2 axes). How can I do this? Can someone help... as I am not good at VBA? Thanks! |
#2
|
|||
|
|||
If you turn on the macro recorder as you apply the custom chart type,
you'll get code similar to the following: ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, _ TypeName:="Line - Column on 2 Axes" Rav99 wrote: I created a Pivot chart from Pivot table, however, as the user changes the options (from pivot fields), then the chart type changes back to default one (I want the line-column 2 axes one). I figured I could go to VBA properties to default the chart type by choosing the chart code, however under that list, there is no chart code for that combination chart (line chart + column chart with 2 axes). How can I do this? Can someone help... as I am not good at VBA? Thanks! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
OK... I tried.. but it doesn't work... What I did ... I open VBE and click on
the Chart, on my right, I have Chart_Activate(), so I put the script you provided underneath it and saved... but it doesn't work. Did I do something wrong? "Rav99" wrote: I created a Pivot chart from Pivot table, however, as the user changes the options (from pivot fields), then the chart type changes back to default one (I want the line-column 2 axes one). I figured I could go to VBA properties to default the chart type by choosing the chart code, however under that list, there is no chart code for that combination chart (line chart + column chart with 2 axes). How can I do this? Can someone help... as I am not good at VBA? Thanks! |
#4
|
|||
|
|||
If you put the code in the Chart_Calculate event, it should work.
Rav99 wrote: OK... I tried.. but it doesn't work... What I did ... I open VBE and click on the Chart, on my right, I have Chart_Activate(), so I put the script you provided underneath it and saved... but it doesn't work. Did I do something wrong? "Rav99" wrote: I created a Pivot chart from Pivot table, however, as the user changes the options (from pivot fields), then the chart type changes back to default one (I want the line-column 2 axes one). I figured I could go to VBA properties to default the chart type by choosing the chart code, however under that list, there is no chart code for that combination chart (line chart + column chart with 2 axes). How can I do this? Can someone help... as I am not good at VBA? Thanks! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
yeh! Wow wow... it works...But now I have another problem of fixing the value
of my 2nd Y axis from 0 to 100%, but everytime I change the choice, it changes accordingly based on the logarithmic method. Please ... after this... I am really done with my project. Any thought? Woowww woooow ... You really make my day! "Debra Dalgleish" wrote: If you put the code in the Chart_Calculate event, it should work. Rav99 wrote: OK... I tried.. but it doesn't work... What I did ... I open VBE and click on the Chart, on my right, I have Chart_Activate(), so I put the script you provided underneath it and saved... but it doesn't work. Did I do something wrong? "Rav99" wrote: I created a Pivot chart from Pivot table, however, as the user changes the options (from pivot fields), then the chart type changes back to default one (I want the line-column 2 axes one). I figured I could go to VBA properties to default the chart type by choosing the chart code, however under that list, there is no chart code for that combination chart (line chart + column chart with 2 axes). How can I do this? Can someone help... as I am not good at VBA? Thanks! -- 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 |
copy pivot chart from pivot chart view in MS Access to word | make a VBA to export pivot chart to word | Using Forms | 0 | September 1st, 2005 03:28 PM |
pivot chart format | Valeria | Charts and Charting | 1 | January 14th, 2005 01:19 PM |
How do I print the details view | David | Running & Setting Up Queries | 5 | August 28th, 2004 12:17 AM |
Pivot table and buble chart | mbobro | General Discussion | 5 | July 23rd, 2004 08:17 AM |
Chart from Pivot table | Adam | General Discussion | 1 | June 23rd, 2004 12:58 PM |