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:
• How To Create A Gantt Chart With A Pr...
Excel Charts Playlist:
• Excel Charts - The Excel Hub
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Gantt Chart – Add Vertical Line To Re...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
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:
[email protected]
Overview: (0:00)
Assign co-ordinates: (0:35)
Add Vertical Line: (1:20)
Impact of co-ordinates: (3:03)