Toggle Chart Series Objects On/Off

[Guest]

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]

Hi,

See Jon Peltier's page for the details.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

 

[Guest]

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