Hi Hui,
I tried doing it, but I am sorry it doesn't works. It would require chart events to be tracked, but I am not familiar with the use of it. Hope someone knows about it and he/she would help me explain and make me acheive doing it.
Thanks.
I want to toggle between chart types on my dashborad charts, like say I already have a bar graph depicted on the worksheet and if a user clicks on the graph the same graph with the same data gets changed to a line graph or xy scatter and it keeps inter-changing.