How to add date to the scale marker to indicate current date

user037471

I Have a scatter chart holding the Month in X scale and amount in Y scale.i want to add a scale marker which indicates the Current date .

 

The option i have is to select "Line" , "Manual" and Value, I am not seeing the scale marker moving to the current date .can you please guide what is the format i have to enter to set this option ?

 

jaeW_at_Onyx

you may have to use a different chart type  (chart / line) or bullet chart, but then just create a beast mode with the current date, a series, and a value.

 

yeah... that's ugly.  

 

you could use a data label with a custom value (setup a beast mode) that's only populated on the current date.

 

I've had clients change the chart formatting for historical vs projected data.