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:
HansVogelaar THANK YOU!! You are amazing.
It looks like I was following your steps correctly. I think my issue is that my defined names contain OFFSET functions.
I attached an edited version of what you sent me with the edited ranges - after this change it no longer works. Any ideas?
You have been SO helpful<3
A new attempt:
HansVogelaar Oh wow, this is so much better. Now I only need the two defined names "Dates" and "Source". This is working perfectly for me. You are a life saver!!