Forum Discussion
Solved
Referencing a Defined Name in a Graph
Hello Friends, I am trying to create an interactive line graph in a report. I created defined name ranges for the data I want to showcase in my graph. However, my idea is to have a drop-down li...
A new attempt:
If "Source" refers to my drop down cell, and my y-axis values refers to that as well, where does the reference to my named ranges come in? I might be misunderstanding:(
All my named ranges are all on the same sheet (currently named "Sheet1"), while my drop down cell and graph are located on my main sheet (currently named "SOF Report")
All my named ranges are all on the same sheet (currently named "Sheet1"), while my drop down cell and graph are located on my main sheet (currently named "SOF Report")
The SERIES function that creates charts is very limited in terms of what it will accept. In particular, any formula must be hidden within a defined Name (here I have defined a sheet-local name
"Sheet1!selectedSeries"). There are a number of ways in which the name may be associated with a data range, including your idea of using INDIRECT which accepts a string and returns a named range. SWITCH would do a similar job, as would XLOOKUP.