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 ?
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.