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 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
CONTENTS
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
Видео How to Create a Gantt Chart in Google Sheets канала Vertex42
https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html
CONTENTS
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
Видео How to Create a Gantt Chart in Google Sheets канала Vertex42
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![How to Make a Gantt Chart in Excel](https://i.ytimg.com/vi/un8j6QqpYa0/default.jpg)
![10 Google Sheets Tips You DON'T Want to Miss (2021)](https://i.ytimg.com/vi/O0k9uE4xnD0/default.jpg)
![Creating a Gantt Chart in Google Sheets](https://i.ytimg.com/vi/-crraoSMxc0/default.jpg)
![Make an awesome Project Management Dashboard with Excel (Free download ~ Part 1)](https://i.ytimg.com/vi/FXnyKU6xZeI/default.jpg)
![5 Google Sheets Tips Every User Should Know!](https://i.ytimg.com/vi/3Ea_QXJlgN8/default.jpg)
![TOP 10 Outlook Tips EVERY Professional NEEDS To Know (in 2021)](https://i.ytimg.com/vi/At6mrBp4Myg/default.jpg)
![](https://i.ytimg.com/vi/gYRPSWFZ8gA/default.jpg)
![Google Sheets IF & IFS Functions - Formulas with If, Then, Else, Else If Statements](https://i.ytimg.com/vi/hG5vKMb0Lpo/default.jpg)
![Design a fully automated Task Tracker using Google Sheets & Forms with no access to Team Members](https://i.ytimg.com/vi/xVhcQNRs-UA/default.jpg)
![How to build Interactive Excel Dashboards](https://i.ytimg.com/vi/K74_FNnlIF8/default.jpg)
![How to Create Gantt Chart in Excel with Pending, In Progress and Completed Status](https://i.ytimg.com/vi/94vJ1qew1Zg/default.jpg)
![Google Sheets Advanced Tutorial](https://i.ytimg.com/vi/t0B0Tgz0b-0/default.jpg)
![PERT CPM Gantt Chart using Sparkline in Google Sheets Part 1](https://i.ytimg.com/vi/g3wWsfyqaCo/default.jpg)
![☑️ Top 30 Advanced Excel Tips and Tricks](https://i.ytimg.com/vi/Hj4PVFYhqhQ/default.jpg)
![Power Gantt Chart (Project Planner) for Project Management](https://i.ytimg.com/vi/4H77Lvx2pQc/default.jpg)
![How to Make a Gantt Chart in Excel - Step by Step Tutorial - Gantt Chart Excel](https://i.ytimg.com/vi/ZeNvtzZLv80/default.jpg)
![Create a Progress Bar Chart inside a Cell in Google Sheets](https://i.ytimg.com/vi/jZVwtiFVcDM/default.jpg)
![Interactive Excel Project Management Dashboard - FREE Download](https://i.ytimg.com/vi/5qtSioTE2wY/default.jpg)
![Gantt Chart Excel Tutorial - How to make a Basic Gantt Chart in Microsoft Excel 2016](https://i.ytimg.com/vi/xsxi4qaEnOg/default.jpg)
![Google Sheets Gantt Chart Template | Instagantt](https://i.ytimg.com/vi/1VrnIc2xYLc/default.jpg)