Dynamic Target Line for Bar Chart based on a Bookmark
I am trying to create a target line for my bar chart based on year 2012 to compare against data prior and post 2012. I have created the bookmark BM2012 to help. What I am expecting from my formula is that the target line remains the same for any given set of listbox selections where the only difference is the year selected.
To illustrate, my intention is that:
The target line should stay the same for these two selections: