This Automatic Daily & Weekly Gantt Chart is a powerful and easy-to-use Google Sheets Template to manage a Project Timeline or Task Tracker. 
 
The Gantt Chart will automatically display the duration of tasks based on the start and end dates in your chosen colour by day or week. 
 
When the 'Day' view is chosen, you can also view the timeline with Weekdays (Mon to Fri) or Weekdays and Weekends (Mon - Sun) to really visualise your tasks over time. 
 
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. 
 
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 contains functions only found in Google Sheets, such as the QUERY function.