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.