Click Boxes for each series in a graph

I have a chart with three series over time. Lets say the range is C2:Z5.
The time is expressed in row 2 and the series data in rows 3,4,5. I want to
be able to turn the series on with click boxes. I have the graph set up on a
worksheet so that some of the cells of the worksheet are visible. I want to
avoid VBA code (for now). So I would like to set up checkboxes on the
spreadsheet itself (if possible). I want to be able to click the checkbox
for each series. When checkbox is click series is visible when not clicked
series not visible. Any ideas on how to do this? Thanks.

Hi ExcelMonkey,

If you want to do this without VBA, first insert rows betweeen the last two
series.
i.e. click on the row number 5 to select the whole row and use menu item
Insert - Rows, then click on roe number 4 and Insert - Rows.
The three series should now be in rows 3, 5, and 7.
Select Row 3 and use the menu item Data - Group and Outline - Group
this places a small box with a '-' sign next to Row 3.
Do the same for Row 5 and 7.
Now, clicking on a '-' sign will toggle visibility for the series.

Otherwise, use VBA.

Ed Ferrero
http://edferrero.m6.net/

>I have a chart with three series over time. Lets say the range is C2:Z5.
> The time is expressed in row 2 and the series data in rows 3,4,5. I want
> to
> be able to turn the series on with click boxes. I have the graph set up
> on a
> worksheet so that some of the cells of the worksheet are visible. I want
> to
> avoid VBA code (for now). So I would like to set up checkboxes on the
> spreadsheet itself (if possible). I want to be able to click the checkbox
> for each series. When checkbox is click series is visible when not
> clicked
> series not visible. Any ideas on how to do this? Thanks.
>

Try this example:

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

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


ExcelMonkey wrote:

> I have a chart with three series over time. Lets say the range is C2:Z5.
> The time is expressed in row 2 and the series data in rows 3,4,5. I want to
> be able to turn the series on with click boxes. I have the graph set up on a
> worksheet so that some of the cells of the worksheet are visible. I want to
> avoid VBA code (for now). So I would like to set up checkboxes on the
> spreadsheet itself (if possible). I want to be able to click the checkbox
> for each series. When checkbox is click series is visible when not clicked
> series not visible. Any ideas on how to do this? Thanks.
>