Toggle on/off switch for x-y graph

  • Thread starter Thread starter Brad
  • Start date Start date
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
 
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
 
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
 
Back
Top