This content has been marked as final. Show 3 replies
Hi all. I'm trying to do something that should be pretty straight-forward, but can't quite get to it.
I have a line graph showing YOY revenue by month. But it can be misleading to the viewer if they don't realize what the current date is (this year's future months will obviously appear less than last year). So I'd like to put in a vertical reference line showing the current date. This will help the viewer understand that anything beyond that is scheduled revenue, and not final.
I created a "Today" field, but can't figure out how to use it as a reference line.
See packaged workbook of sample data.