Gantt Chart – Add Vertical Line To Represent Today’s Date In Excel

We cover how to add a vertical line to show today’s date in a Gantt chart in Excel. In our example, we have a Gantt chart which shows our progress towards achieving certain tasks. What we want to do is have a line showing today’s date so that we know where in the project plan we currently are. To do this, we'll need to add a series representing today's date, formatted as a scatter chart.

How To Create A Gantt Chart With A Progress Bar To Show Percentage Completion Of Tasks In Excel:

Excel Charts Playlist:

Subscribe for weekly Excel tutorials, techniques and examples:

Please share this video with others that may find it useful:

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:

Overview: (0:00)
Assign co-ordinates: (0:35)
Add Vertical Line: (1:20)
Impact of co-ordinates: (3:03)

[tomjackson]

Excellent, thanks! Once I'd added the scatter I found I had to adjust the maximum and minimum, otherwise the line didn't reach the top.

[lizlima]

Very simple. It helped a lot. Many thanks!

[kennygo]

Thanks dude. Can the bar reach the top of the cart? I set it 0, 9 but the top of bar stay around middle of the chart.

[lefterisx.]

That's exactly what I was looking for to fine tune my Gantt chart ! Thanks a lot 🙏

[floijer]

Perfect, this was exactly what I needed!

[razvanyke]

Great work, man. I appreciate your effort and you got a sub from me, take care !

[LT]

Thank you:) i am now trying this and your other tutorial on how to make a gantt chart, but for a 50 task chart and over 8 months haha. lets see how it does. But the real question is, do i have to change that date every day or can excel update it?

[dawnrobinson]

Having issues adding the “today’s date” in a combo chart. Excel won’t let me do a stacked combo & line chart together for some reason

[pipo]

You can change/adjust in Series options and put 9 hence the today's date line will hit the top of the chart...

[tomatatwo]

Thank u for the video it is so useful but its not on the correct date on the time line its back for years

[FlyFly-ddbz]

It changes chart into a line rather than keeping my chart