This Automatic Weekly 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 Weekly Gantt Chart will automatically display the duration of tasks based on the start and end dates in your chosen colour by week number so that you can track tasks over weeks. 
 
If you're looking for a Gantt Chart visualised by day, check out this template: Automatic 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.