2 Replies Latest reply on Feb 3, 2014 11:31 PM by . Indumon

    how to dynamically change the type of chart by providing a menu to the viewer to select from

    ramya c

      If I have data that can be displayed as different charts, how do I provide the viewer with a menu so that on selecting a particular chart( eg: pie chart, bar graph,line graph etc)  from the menu the data is displayed in the form of that particular chart only. so if the viewer selects pie chart a pie chart should be displayed, if he selects a bar graph a bar graph should be displayed.And this dynamic changing of charts should take place in a single worksheet only.