Toggle on/off switch for x-y graph

[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

 

[Bernard Liengme]

Let's say series 3 in is D222
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 D222 (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

 

[Jon Peltier]

Here's an illustrated description of Bernard's approach:

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Brad]

Jon and Bernard,

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

 

[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