Reference lines

[jduenyas]

Hi all

Under Presentation / Reference Lines I can add a Y axis (horizontal) reference line. No big deal.

Is it possible to create an X axis reference line (vertical) that will move with passage of time in the chart?

I need to set a "marker" on July 2016 to distinguish all that was prior and after July.

Thanks

[vishsaggi]

Can you share a sample app if possible please ?

[jduenyas]

I cannot share the application as it is too large but here is a snapshot of what I need:

Vertical line on July 2016 that will move with the month until it falls off the chart unless wider range of dates is selected.

Does r this help?

[agomes1971]

Hi,

please see this:

Reference Line

HTH

André Gomes

[stigchel · Accepted solution]

Yes, but you must set the x axis to continuous in the axes tab and then set the reference line in the presentation tab like this

[jduenyas]

Beautiful!

However, it changes the dates on the X axis to numerical value instead of the Month's name.

How do I show the month name then?

[jduenyas]

OK I got it. In number set up

Thanks you!!!