I've made a line chart that I'd like to add some formatting to (see STP.jpg), specifically the large "year" and year divider dashed lines shown. Is this possible?
Attached is also the chart as far as I've gotten it.
Thanks,
RL
How's this (attached)?
I added Reference lines to your axis to get the dotted lines and then added area annotations to get the year number.
That's really great help, Aaron.
From an automation and updating perspective- is there any way to make the parameters for the reference bars dynamic, so that they appear whenever there's an end of year condition- sort of an IF DATEPART('month', [Date]) = "december" THEN ... ?
I tried to make the area annotation dynamic by using the year of date <YEAR(Date)>, which yields "ALL", but <MONTH(Date)> works, apparently.
Thanks,
RL
