Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic chart format & data selection? | Charts and Charting in Excel | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Dynamic data series | Charts and Charting in Excel |