Excel Charts - Toggle Series On/Off

  • Thread starter Thread starter scottiegee
  • Start date Start date
S

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
 
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?
Click to expand...


-
rut
 
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?
Click to expand...

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

-
rut
 
Back
Top