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

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

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