Does anyone know if it possible to have formulas embedded in the SERIES
formula that defines a chart series. For example, what I'd like to have is

=SERIES(Sheet1!$C$18,Sheet1!$D$16:$F$16,INDIRECT(D 12),1)

where D12 is a valid text range.

This does not seem to work. Essentially, I am trying to set up the chart so
I can toggle what is charted without needing to alter the chart references OR
set up a separate set of cells that are charted and that in turn refer to the
(changing) data set I want to chart.

Any thoughts are welcome!