software

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

Hi,

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

Cheers
Andy

Raul wrote:
gt; Is there a way to use radio buttons (or any other controls or forms) to
gt; display, or not display, individual series of a chart seriescollection? I
gt; have a number of charts that display a lot of information, and it would be
gt; very useful to be able to toggle off some number of the chart series and then
gt; toggle them back on again.
gt;
gt; Thanks in advance,
gt; Raul

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

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,
Raulquot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; See Jon Peltier's page for the details.
gt; peltiertech.com/Excel/Charts/ChartByControl.html
gt;
gt; Cheers
gt; Andy
gt;
gt; Raul wrote:
gt; gt; Is there a way to use radio buttons (or any other controls or forms) to
gt; gt; display, or not display, individual series of a chart seriescollection? I
gt; gt; have a number of charts that display a lot of information, and it would be
gt; gt; very useful to be able to toggle off some number of the chart series and then
gt; gt; toggle them back on again.
gt; gt;
gt; gt; Thanks in advance,
gt; gt; Raul
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;