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.

Access the templates featured in The Excel Hub’s video tutorials here:

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!

🌍 The Excel Hub website:
📸 Instagram:

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:
theexcelhub@outlook.com

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