Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a Line chart and it has Fast Change functionality to change it to Pivot table also. In place of clicking the "Fast Change" icon in caption, I want to have a button which will change the chart type from Line to Pivot and vice-versa.
Can anyone provide me the macro code/technique how to do it in best possible way?
I have provided a sample qvw here.
Regards,
Sharma
Try this attachment:
Experimentation will tell you the chart types.
The object types are:
0=Unknown
1=List Box
2=Multi Box
3=Statistics Box
4=Table Box
5=Button
6=Text Object
7=Current Selections Box
8=Input Box
9=Line/Arrow Object
10=Pivot Table
11=Straight Table
12=Bar Chart
13=Pie Chart
14=Scatter Chart
15=Line Chart
16=Combo Chart
17=Custom Object
18=Bookmark Object
19=Slider/Calendar Object
20=Grid Chart
21=Radar Chart
22=Gauge Chart
Hi Sharma,
I don't know the code you are asking for, but i tried some other options to get the same result.
Take a look at the atteched file and tell me what you think ok?
Good luck,
Dennis.
Thanks for looking into this Dennis. I can see that you have got two different charts and the button is just changing the charts. But I dont want this. I will have only one chart and I want to trigger the Fast change on the press of a button i.e. If I Press the button, the chart should change from Line to Pivot table and vice versa.
I dont want to do this with two charts.
Regards,
Sharma
see the attached file
hope this helps
or
you can see this attached file
hope this will help
Try this attachment:
Experimentation will tell you the chart types.
The object types are:
0=Unknown
1=List Box
2=Multi Box
3=Statistics Box
4=Table Box
5=Button
6=Text Object
7=Current Selections Box
8=Input Box
9=Line/Arrow Object
10=Pivot Table
11=Straight Table
12=Bar Chart
13=Pie Chart
14=Scatter Chart
15=Line Chart
16=Combo Chart
17=Custom Object
18=Bookmark Object
19=Slider/Calendar Object
20=Grid Chart
21=Radar Chart
22=Gauge Chart
Hi Sunil,
Thanks for you effort on this. But as I said earlier, I dont want to use two charts. I want to have only one chart and since Fast change options are checked, I want to suffle between line and Pivot table by the use of button(as if clicking on Fast Change icon on title bar).
Thanks
Sharma
Hello mwoolf,
This is working great and is what I needed. Nice concept though. Thanks for this.
But I just want to know about the integer you have set in the code like below:
chart.SetChartType 2
chart.SetChartType 4
How you have arrived at these numbers? Also if you see from the list you have given up, there is no relation. Your explanation will of very much help.
Regards,
Sharma
FastChange Chart Types
0=Bar
1=Pie
2=Pivot
3=Scatter
4=Line
5=Straight Table
6=Combo
7=Radar
8=Gauge
9=Grid
10=Block
11=Funnel
mwoolf its not working hwen we remove the fas change option i.e icon on title bar of chart.
is there any example for without check for fast change.