Toggle on/off switch for x-y graph
 

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
--
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

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/
_______


Bernard Liengme wrote:

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

Jon and Bernard,

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

"Jon Peltier" wrote in message
...
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/
_______


Bernard Liengme wrote:

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

Brad wrote:

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