Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm having a mental block on how to do this.
I have a boatload of named ranges in my workbook. I have one worksheet that has two data validation cells and a graph. I want the two data validation cells to be used to select the named range to use to populate the graph series. My named ranges pull from a large variety of locations (not orderly) so I put the named range names in a table format for easier reference; here is an example with named ranges by month and location- the user selects a month and location, and the graph should use the named range with the name in the corresponding cell: Jan Feb Mar Apr etc Loc1 Jan1 Feb1 Mar1 Apr1 Loc2 Jan2 Feb2 Mar2 Apr2 Loc3 Jan3 Feb3 Mar3 Apr3 etc I can find the target cell no problem (Apr, Loc2 = E3) but I can't seem to figure out how to use the cell value from my table as the named range that feeds the graph. I tried "indirect" but either that isn't the correct approach, or my syntax is bad (I tried it both in the graph itself, and in a 'master' named range to feed the graph). If it were my choice, I'd just do this in VBA and have no problems, but this workbook will be distributed internally and most folks won't enable VBA, but will still expect the graph to dynamically update based on their two selections. I appreciate any help you can give me! Thank you, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using INDIRECT in named range for chart data series | Charts and Charting in Excel | |||
INDIRECT function to reference a named range | Excel Worksheet Functions | |||
named range in sum formula (indirect, offset, worksheet name) | Excel Worksheet Functions | |||
Indirect to Named range | Excel Worksheet Functions | |||
How do I use indirect when referring to a named range in a closed | Excel Worksheet Functions |