Jon Peltier has instructions for using a check box to hide/show a series:

http://www.peltiertech.com/Excel/Cha...ByControl.html

SPYREN wrote:
I have a XY Line chart that contains 9 Series, ploted at the same time. Due
to visual clutter in this chart, I would like to have the option to enable or
disable these lines by using a check box for each of the series.
Is this possible? and how can this be done programatically?.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html