[Question] Setting up a graph that has toggleable series.

[exce]

Hi all,


I have a graph on one sheet and another sheet has 20 sets of data (or 20 series of data). What I want to do is have a drop down, toggle box, a list or something that allows for a user to select any number (1-20) of those 20 series and have them displayed on the graph.


I know how to use a checkbox to toggle true/false which can then be used in conjunction with an IF statement to display the series. My problem with this method is that the check boxes dont make for a nice interface like a drop down list would. Also when I use this method, every series (all 20) is displayed in the legend below, whether they are checked (being displayed) or not.

So plain and simple, can I have a drop down list (or something similar) that can allow me to select which data to display on a graph. It must be able to display multiple series.


Thanks for your time.

 

[exce]

Bump

 

[Datsmart]

Take a look at Peltier's downloadable workbooks here:
http://peltiertech.com/Excel/Charts/ChartByControl.html

 

[exce]

Thanks for the response. I looked those over. They still display the untoggled series in the legend. I need a solution that does the same thing but when the series is not checked or selected, it is not displayed in the legend.