I am adding in reference lines in targets in a few charts and the logic is getting quite complex. I was hoping that there was another way to get the same result.
The intent is to add targets based on Tower and Fiscal Year. What is getting complex is that I need to not show the reference line if 1-3 work types are selected or if any Depts are selected. I also have different targets for each tower depending on the fiscal year. Is there an easier way of accomplishing this other than a whole lot of reference lines?
For each tower and FY for graph 1: