Dynamic Data Series Selection from Data Validation Dropdown?

  • Thread starter Thread starter Kris S
  • Start date Start date
K

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