LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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...)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic chart format & data selection? [email protected] Charts and Charting in Excel 5 April 7th 08 06:45 PM
Data Validation Update Validation Selection PCreighton Excel Worksheet Functions 3 September 11th 07 03:32 PM
data validation invalid in dynamic validation list ilia Excel Discussion (Misc queries) 0 November 7th 06 12:54 PM
data validation invalid in dynamic validation list ilia Excel Worksheet Functions 0 November 7th 06 12:54 PM
Dynamic data series Tom Ulincy Charts and Charting in Excel 1 July 16th 06 02:13 AM


All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"