show today on chart

[omid5ive]

hi

i have a chart with values of sales in past and predict of my sales on future and sale of current date

how can i have a vertical line on my chart on current date?

[fvelascog72]

Hi,

You can use a reference line using the conditional for de current day.

Cheers

[effinty2112]

Dear Omid,

                    In the Axes tab of your chart check the box to make the dimension box continuous. Then in the Presentation tab add a reference line =today() for Continuous X.

Cheers

Andrew

[ahaahaaha · Accepted solution]

Hi,

Another option in the attached fileю

Regards,

Andrey