Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line Charts have no lines | Charts and Charting in Excel | |||
charts - 1 column and 2 lines | Charts and Charting in Excel | |||
Smooth lines for 3-D pie charts? | Charts and Charting in Excel | |||
lines on bar charts | Charts and Charting in Excel | |||
Charts with many lines | Excel Discussion (Misc queries) |