| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Click Boxes for each series in a graph | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
