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