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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Brad" wrote in message
...
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