Toggle on/off switch for x-y graph

B

Brad

I have an x-y graph with a number of data series displayed. All good so
far, but I would like to know a way to "toggle" on and off a few of the
series at the same time, say three out of seven, so that as I view the
graph, I can limit the view a bit as needed.

My thanks for any ideas on how best to move forward. Cheers! Brad
 
B

Bernard Liengme

Let's say series 3 in is D2:D22
In any empty cell (say J1) type a 1
In J2 enter =IF(J1=1,D2,NA()), copy to D22
Now adjust the chart to use J2:J22 in place of D2:D22 (right click chart;
select Source Data, select third series and make the needed change)
Look at chart; change J1 to 0: did it work?
best wishes
 
B

Brad

Jon and Bernard,

Thanks for the information. It's exactly what I was looking for. Brad
 
J

Jerry W. Lewis

As an alternate approach, if you hid the columns (or rows) that contain
the some of those series, the corresponding series will be hidden on the
chart.

Jerry
 
Top