Dynamic Data Series Selection from Data Validation Dropdown?

[Kris S]

I want to create a dynamic graph with dropdown selections for the varying
data series. I tried: Defined series names using the top cell of each
column, created a pull-down via a Data Validation List which chooses from the
top cell of each column of data, then created a chart and selected the
pull-down cell containing the desired data series. The result is apparently
"0" rather than the desired series name.

Is there a fix or alternative for this? I do not want to use OFFSET
function shown in many tutorials as my data set names and/or column order may
change with each data set inserted/replaced. The data may contain up to 75
columns of data - thus the desire to simplify repetitive graphing of several
columns for comparison.

I need a solution or I will have to (use) JMP (heh...)

 

[Shane Devenshire]

I'm not completely clear, but if I've got the correct idea try using
INDIRECT that will pick up the text entry displayed by the drop down and use
it as a range name.

Cheers,
Shane Devenshire
Microsoft Excel MVP