Hi:
Your first question is relatively easy to do, with the IF command. Make a
copy of yr series (so you have two of each, X and Y). X is yr basic data,
and Y is calculated depending on a value in yr "trigger" cell (say this is
cell A1, and the value is 0 or 1).
Series Y is then for instance IF(A1=1,"X",NA()). Now plot Series Y, not X.
It either shows the values (if A1=1) or nothing (the effect of the NA()
command.

Your second question, the "chart flip": I think it is possible with the help
of the CHOOSE command, but frankly I don't see how this can be a time-saver -
the only sensible reason for this. I use CHOOSE when I want to change my
chart's appearance triggered by an event or value (e.g. change the chart area
into red for alerting purposes).
Just in case you are not awa you don't have to remake a chart from
scratch once you have one: you can always right click the existing chart and
choose a different Chart Type and .. voila. Having said this, you may wish
to see my answer on the post of Rich earlier today in case you use
time-consuming chart formats that you don't like to make over again each
time.
HTH,
GL,
Henk
"name" wrote:


How can I have a chart that *only* plots series chosen by the user. For
example:

I would like to have a on/off (1/0) switch for each series of data. I
want the chart to only plot series with the on switch value. Also, I'm
looking for a true solution, not one that plots the off series on the
axis.

All help is, as always, greatly appreciated.


--
name
------------------------------------------------------------------------
name's Profile: http://www.excelforum.com/member.php...o&userid=34115
View this thread: http://www.excelforum.com/showthread...hreadid=559455