hiding data series with check/uncheck boxes
 

hi, we've got lots of data series we want to graph out in a line graph.
value on Y axis, and time on x axis. we want to link over 50 series to one
graph, then be able to check / un-check boxes so we can compare one line from
a series to another, and switch the series were looking at on the fly by
clicking show/don't show check boxes.

Excel 2003

I've searched the discussion base and havn't found anything. Thanks.
--
We sell mannequins to retailers.
They smile, laugh, and kiss!
www.bigsmile.ca

hiding data series with check/uncheck boxes
 

Hi,

Try Jon Peilter's example,
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

BigSmile Mannequins Inc. wrote:
hi, we've got lots of data series we want to graph out in a line graph.
value on Y axis, and time on x axis. we want to link over 50 series to one
graph, then be able to check / un-check boxes so we can compare one line from
a series to another, and switch the series were looking at on the fly by
clicking show/don't show check boxes.

Excel 2003

I've searched the discussion base and havn't found anything. Thanks.