Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / May 2008

Tip: Looking for answers? Try searching our database.

Dynamic Data Series Selection from Data Validation Dropdown?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kris S - 23 May 2008 02:43 GMT
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...)
Shane Devenshire - 23 May 2008 23:17 GMT
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

> 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
[quoted text clipped - 15 lines]
>
> I need a solution or I will have to (use) JMP (heh...)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.