Hi Tim Richards,

Check out my and Jon Peltier's answers to 'Click Boxes for each series in a
graph' on Tuesday, 18 October 2005 5:56 AM in this forum.

If you want to explore conditional formatting for charts look at the sample
at http://edferrero.m6.net/charting.aspx or check out Jon's pages at
http://peltiertech.com/Excel/Charts/...html#CondChart

Ed Ferrero
http://edferrero.m6.net/

I don't agree with my boss's ideas regarding Excel Charts - I think that
they
are to cluttered and become less effective. So, I would like to apply
conditional formatting via a checkbox to "turn off"(apply
white/transparent
properties)to one or more series in a chart, effectively eliminating the
overlapping series from view temporarily. Can this be done? Is the answer
VB?I think this could be very effective in clarifying data that is
consistently overlapping each other. (Actually I would just make 3
separate
charts on the same page, but nobody is asking me!)
Tell me what you think...
Thanks,
Tim