toggle data series on/off on chart

Does anyone have any suggestions?

The attached shows how you can do this for your 5 curves. I've inserted a new column Q so that the Y values for the graph are now derived from column R. I've copied the Y values into column Q, then put this formula in R3:

=IF($V$35="Y",Q3,NA())

and copied this down. Similar formulae have been put in each block further down the column, but referring to V36, V37 etc.

So, change the values in V35:V39 from Y to something else (N ?) and the appropriate set of curves will disappear from the graph. You can apply similar logic to the other data sets.

Hope this helps.

Pete