"dvt" wrote in message ...


I don't understand exactly what you're charting. But let me throw out a few
suggestions.

First, you could transpose your data...

No, no. I'm sorry I wasn't clear. I have a page (meaning worksheet)
of inputs. Imagine row1 being something like "NaCl concentration",
row2 being "starting temperature", row3 being "voltage", etc., and
each column contains a different set of these parameters. There's a
column with values for a scenario called "Option A", one to its right
called "Option B", etc., each column containing some value for each of
the input parameters.

Those inputs feed into several pages of models. The models do lots of
analysis and send their outputs to several summary worksheets. Imagine
one summary worksheet with the rows labeled Time 0, Time 1, Time 2...,
Time 1000. The columns show the output data for Option A, Option B,
.... Option Z. The cells show temperature, for example. Another summary
chart might show some other property at time 0 thru time 1000 --
chemical concentration or whatever.

Now I want to chart these outputs, but I have too many scenarios to
include them all on the charts simultaneously. Twenty lines ("series")
is too many for one chart. I might want to take a look at the
temperature curves of just Options A, D, E, and G on the charts. Then
I might want to remove G and add H and I. Then remove them all and
look at Options B vs. C.

What I'd like to do is just go to the input page and put either "yes"
or "no" at the top of each column to indicate whether I want the
charts to include the outputs from that scenario.

But I don't know how to create charts that dynamically add or remove
series depending on the value in some cell at the top of the input
columns on the input page.

I'd be grateful for any suggestions.