View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Tuang Tuang is offline
external usenet poster
 
Posts: 2
Default turning lines on/off on a set of charts

I have a set of columns and each contains a list of parameters that
describe a scenario. (Not any Excel-specific meaning of "scenario" (I
think there is such a thing), but just the ordinary meaning of "it
could be like this, or like this, or this...." parameter lists).

I may input the descriptions of ten different scenarios, and then I
have a set of charts for viewing the various implications of the
scenarios. Having ten lines on a single chart is way too confusing.
I'm usually interested in contrasting just two or three of them at a
time. If this were an ordinary app, I'd have a checkbox above each
column of parameters that would stand for "include in charts? yes or
no?".

I'm not quite sure how to do such a thing with Excel. I'm a programmer
(C++, C#, Lisp, etc.), but I'm a novice at Excel, so the simpler the
solution, the better. I realize that I can get the macro recorder to
write some useful code for me, and then I can try to tweak the code,
but I'm not even sure what I would do manually that I could record to
get code for adding and removing series from a set of charts (not just
one) in response to a "yes" or "no" in a cell.

I'd be grateful for any suggestions.

Thanks.