View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Kris S Kris S is offline
external usenet poster
 
Posts: 1
Default 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...)