How to Create a Gantt Chart in Google Sheets
Learn how to create a Gantt Chart in Google Sheets to use as a simple and powerful project management tool. This video is a useful Google Sheets tutorial for...

Vertex42
1.1M views โข Jun 22, 2020

About this video
Learn how to create a Gantt Chart in Google Sheets to use as a simple and powerful project management tool. This video is a useful Google Sheets tutorial for project managers. You can follow it step-by-step, or you can get the free template from the link below:
https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html
See the PART II video for working with weekends:
https://www.youtube.com/watch?v=vbhOYo-b5Io
CONTENTS
0:00 Introduction
0:17 Add Tasks and Dates
0:52 Create Task Dependencies Using Formulas
1:26 Create the Timeline
3:08 Format the Data and Timeline
5:15 Add the Bars of the Gantt Chart using Conditional Formatting
6:33 Make the Timeline Dynamic (a scroll-like feature)
7:27 Highlight the Current Date using the TODAY function
7:57 Add Progress Bars for Each Task using the SPARKLINE function
9:26 Calculate the Start and End Dates for Summary Tasks
9:52 Use the Group Rows Feature to Show/Hide Sub Tasks
10:12 Correction: The shortcut to group rows is SHIFT+ALT+RightArrow
๐ Remember to Subscribe and Turn on Notifications (click on the bell)
MORE GANTT CHART TEMPLATES
Another free Gantt Chart for Google Sheets can be found here:
https://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html
MAKE A GANTT CHART IN EXCEL
Watch our popular video series on how to make a gantt chart in Microsoft Excel:
https://www.vertex42.com/ExcelTips/how-to-make-a-gantt-chart-in-excel.html
GANTT CHART TEMPLATE PRO:
A more feature-packed version for Google Sheets is available via the Pro package. It includes color-coding, more ways to define tasks and predecessors, and lets you change the timeline from daily to weekly or monthly. See the link below:
https://www.vertex42.com/ExcelTemplates/gantt-chart-template-pro.html
MUSIC CREDITS: Pixelate, by Zac Nelson, licensed via ArtList
https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html
See the PART II video for working with weekends:
https://www.youtube.com/watch?v=vbhOYo-b5Io
CONTENTS
0:00 Introduction
0:17 Add Tasks and Dates
0:52 Create Task Dependencies Using Formulas
1:26 Create the Timeline
3:08 Format the Data and Timeline
5:15 Add the Bars of the Gantt Chart using Conditional Formatting
6:33 Make the Timeline Dynamic (a scroll-like feature)
7:27 Highlight the Current Date using the TODAY function
7:57 Add Progress Bars for Each Task using the SPARKLINE function
9:26 Calculate the Start and End Dates for Summary Tasks
9:52 Use the Group Rows Feature to Show/Hide Sub Tasks
10:12 Correction: The shortcut to group rows is SHIFT+ALT+RightArrow
๐ Remember to Subscribe and Turn on Notifications (click on the bell)
MORE GANTT CHART TEMPLATES
Another free Gantt Chart for Google Sheets can be found here:
https://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html
MAKE A GANTT CHART IN EXCEL
Watch our popular video series on how to make a gantt chart in Microsoft Excel:
https://www.vertex42.com/ExcelTips/how-to-make-a-gantt-chart-in-excel.html
GANTT CHART TEMPLATE PRO:
A more feature-packed version for Google Sheets is available via the Pro package. It includes color-coding, more ways to define tasks and predecessors, and lets you change the timeline from daily to weekly or monthly. See the link below:
https://www.vertex42.com/ExcelTemplates/gantt-chart-template-pro.html
MUSIC CREDITS: Pixelate, by Zac Nelson, licensed via ArtList
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
1.1M
Likes
20.3K
Duration
10:41
Published
Jun 22, 2020
User Reviews
4.8
(229) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.
Trending Now