Dynamic Data Series Selection from Data Validation Dropdown?
 

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...)

Dynamic Data Series Selection from Data Validation Dropdown?
 

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

"Kris S" <Kris wrote in message
...
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...)