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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
> 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