This Automatic Daily Gantt Chart is a powerful and easy-to-use Google Sheets Template to manage a Project Timeline or Task Tracker.
Find out more on YouTube
The Gantt Chart will automatically display the duration of tasks based on the start and end dates in your chosen colour by day.
If you're looking for a Gantt Chart visualised by week, check out this template: Automatic Weekly Gantt Chart Template
As you mark tasks as complete, the Gantt Chart will automatically update to hide past dates and show new dates at the end of the chart. You’ll never need to add new columns at the end, as the chart will constantly update as you progress through your tasks.
You can also visualise your progress on each task with the mini progress bar chart and filter the tasks to drill down to view essential information.
This Google Sheets template includes only two tabs: the main Gantt Chart and a settings tab to make everything work. It's effortless to use; just add your tasks and dates to see the timeline come to life, then update your progress to visualise task completion.
Instructions on how to use this template are included with the download link, which will be emailed to you following a purchase.
The language of this Google Sheets template is English.
Please note: This Google Sheet is not compatible with Microsoft Excel since it uses Google Apps Script to run the automation; plus, it also contains functions only found in Google Sheets, such as the QUERY function.
top of page
Rating is 4.5 out of five stars based on 2 reviews
SKU: W1011
£6.00Price
Frequently purchased
bottom of page
Reviews
This sheet is quite useful to learn from and with. After years or tools and office products, this tool was a good way for me to start learning a few new things in sheets with hands on. I have seen some areas where the sheet could have been better designed as a template or google could have made a smarter sheets product but all in all this sheet save me time (which is money) figuring out how to do a few of these things on my own.
Now I am off to make it my own.. (and see if works)
Great spreadsheet with easy to follow instruction sheet. Well thought out for project management and visualization. I had a few questions and the creator was very helpful, would recommend!