I have a standard line chart that tracks sales versus target figure on a accumulated basis through the month. I need some way to highlight or draw attention to todays date on the chart, either on the x axis or on the actual line of the graph.
(This is in case you go a day or two with no sales, as the line is flat from today onwards anyway (as it is accumulated sales) , it is hard to spot at a glance.)
I've tried to conditional format the axis etc but this seems to change the entire axix figures, not just todays date.
Has anyone any ideas, or workarounds to make todays date or that point on the chart stand out.