View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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.