Add a Reference Line for Todays Date

[denwo2010]

Hi,

I want to add a Reference Line for todays date on the attached chart, but for some reason it is not setting this?

Thanks

[SunilChauhan]

see the attached file

hope this helps

[denwo2010]

Hi,

I want the line to appear vertical.

Thanks

[Anonymous]

I think this is what you need:

=Month(today()) + Day(today())    /   Day(MonthEnd(today()))

Take a look at the attechment and let me know if it works for you ok?

Good luck,

Dennis.

[Anonymous]

Extra information:

Continuous X requires that you have a numeric value on the X-axis and have chosen to display it as continuous on the axis tab.

[denwo2010]

Hi Dennis,

So I take it is not possible to do with the graph that I have now as I do not have numeric values on thex axis?

Thanks

[Anonymous · Accepted solution]

Not like this no. Your X-axis needs to be numberic because it need to count/calculate where the line should show up.

Can't you make your dimension numeric?

[denwo2010]

OK Thanks Dennis