L
LSMark
I would like to change a range name refernced in a charted
series by using a control combobox so that if i want to
see a differnt series, all i have to do is select it.
I was thinking of using a lookup function that refernces
the numerical output of the control but the series formula
won't read the formula or a cell reference as text.
=SERIES(OAS!$A$11,'Index-HistoricalPricing ML Vers 2.xls'!
DATE,'Index-HistoricalPricing ML Vers 2.xls'!Chemicals,1)
Chemicals is the range name, is there a way to replace it
with a formula or cell refernce.
I can probably code this but I always try to exhaust XL
functionality first.
Your Help is greatly appreciated
Thanks
series by using a control combobox so that if i want to
see a differnt series, all i have to do is select it.
I was thinking of using a lookup function that refernces
the numerical output of the control but the series formula
won't read the formula or a cell reference as text.
=SERIES(OAS!$A$11,'Index-HistoricalPricing ML Vers 2.xls'!
DATE,'Index-HistoricalPricing ML Vers 2.xls'!Chemicals,1)
Chemicals is the range name, is there a way to replace it
with a formula or cell refernce.
I can probably code this but I always try to exhaust XL
functionality first.
Your Help is greatly appreciated
Thanks