Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Toggle Chart Series Objects On/Off
Is there a way to use radio buttons (or any other controls or forms) to
display, or not display, individual series of a chart seriescollection? I have a number of charts that display a lot of information, and it would be very useful to be able to toggle off some number of the chart series and then toggle them back on again. Thanks in advance, Raul |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Toggle Chart Series Objects On/Off
Hi,
See Jon Peltier's page for the details. http://peltiertech.com/Excel/Charts/ChartByControl.html Cheers Andy Raul wrote: Is there a way to use radio buttons (or any other controls or forms) to display, or not display, individual series of a chart seriescollection? I have a number of charts that display a lot of information, and it would be very useful to be able to toggle off some number of the chart series and then toggle them back on again. Thanks in advance, Raul -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Toggle Chart Series Objects On/Off
Andy,
Thanks for the tip. By the way, I've been using your methodology for scrolling charts which has turned out be an extremely useful and fairly elegant charting solution. Thanks again, Raul "Andy Pope" wrote: Hi, See Jon Peltier's page for the details. http://peltiertech.com/Excel/Charts/ChartByControl.html Cheers Andy Raul wrote: Is there a way to use radio buttons (or any other controls or forms) to display, or not display, individual series of a chart seriescollection? I have a number of charts that display a lot of information, and it would be very useful to be able to toggle off some number of the chart series and then toggle them back on again. Thanks in advance, Raul -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Excel chart series from vb6 | Charts and Charting in Excel | |||
Chart -- Source Data... -- Series dialog window | Charts and Charting in Excel | |||
Chart will not display complete series | Charts and Charting in Excel | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) |