Does anyone have any suggestions?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks