Excel Charts - Toggle Series On/Off

[scottiegee]

I would like to easily/quickly toggle series in an Excel chart on an
off. What I would really like to have is some way to click on a serie
in the legend next to my chart and have that series data disappear fro
my graph. Then I need to be able to click that series again in th
legend and have the data reappear on the graph. I don't think Exce
has this capability built-in, so I'll have to create an add-in o
macro. Any ideas

 

[Andy Pope]

Hi,

Have a look at Jon Peltier's example of using controls to display
certain data in chart.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

 

[ruth]

I have the same problem. I tried to create a macro using check boxes t
clear the colors on the graph. Now I am writing a user form that wil
generate the list of all the series into a list box and then clear th
colors on the graph. If you have found another solution please let m
know.

Thanks,
~RUTH~

*I would like to easily/quickly toggle series in an Excel chart o
and
off. What I would really like to have is some way to click on
series
in the legend next to my chart and have that series data disappea
from
my graph. Then I need to be able to click that series again in the
legend and have the data reappear on the graph. I don't think Excel
has this capability built-in, so I'll have to create an add-in or
macro. Any ideas?

-
rut

 

[ruth]

I think I have made a good solution. Check out the attachment.

~RUTH~

*I would like to easily/quickly toggle series in an Excel chart o
and
off. What I would really like to have is some way to click on
series
in the legend next to my chart and have that series data disappea
from
my graph. Then I need to be able to click that series again in the
legend and have the data reappear on the graph. I don't think Excel
has this capability built-in, so I'll have to create an add-in or
macro. Any ideas?

+----------------------------------------------------------------
| Attachment filename: graph series toggle.zip
|Download attachment: http://www.mcse.ms/attachment.php?postid=2282798
+----------------------------------------------------------------

-
rut