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.
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.
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).