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:

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:

MAKE A GANTT CHART IN EXCEL
Watch our popular video series on how to make a gantt chart in Microsoft Excel:

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:

MUSIC CREDITS: Pixelate, by Zac Nelson, licensed via ArtList

[vertex]

FAQ I probably won't have time to answer specific questions, but I'll use this comment for some common questions. If you have problems getting things to work, see the link in the first paragraph of the description to download the template.
2. 10:12 - The correct shortcut for grouping rows is SHIFT+ALT+RightArrow
3. How do I display monthly instead of daily/weekly? See the answer to #1
4. How do you show milestones? If you mean showing the diamond symbol (◆) within the chart, you can do that using formulas within the cells of the chart to display the unicode diamond character. I use that technique in Gantt Chart Template Pro (not free) but it appears more like magic because of the use of spilling array formulas. If you want to display a milestone as a just a different color, that is much easier and see the answer to #1 for a video that shows changing the colors.

[mohammadhasani]

Some people don't need to spend $50/month for project management tools and all they need is a simple Gannt chart to track their tasks. You just saved everyone so much money. You're awesome! What a great video

[JustinFranzUy]

Can I just say this is probably one of the best tutorial videos I've ever seen on youtube. Simple, easy to understand, straightforward, good video quality, not too long. It goes over each procedure in a way that is easy to understand and doesn't over explain. Learned so much from this one video. Thank you, I hope you make more videos in the future.

[robinmcgrother]

What 5 people disliked this video? A free service that is brilliantly done and offers nothing but help. I despair for humanity.

[kelrickds]

This tutorial is honestly one of the best I've ever seen for making material relatable and interesting. The entire video passed without me being pulled away to check email/focus on another project because I was engrossed.
The use ofgraphics and motion really helps guide the eye and maintain interest, the music choice was unobtrusive but assisted in maintaining interest, and the visual of the shortcut keys was brilliant!
Thank you!

[andreafernandez]

This was BY FAR THE ABSOLUTE BESTTTT explanatory video i have seen in my entire life. I am stunned at how easy and well it was all explained, i did it perfectly.

[Avinash]

Probably the most crisp and effective tutorial I watched on any subject, ever.

[Bob-jnjt]

You have no idea, how much this has helped me out. Working on multiple projects that are very large and complex with very long timelines. This made it easy for me to wrap my head around all of it and clearly communicate that to the team.

Thank you very very much for your work! Much love and appreciation.

[w.v.]

Wow, what a video: awesome display of skills both with sheets and with video creation. Good speed, good audio, great sheets knowledge applied to Gantt Charts. No wasted time, no unnecessary redundancies. Excellent. Thank you so much.

[mjrywcw]

This is awesome! I have a bunch of software already for my company and really didn't want to add on another subscription just for scheduling. This is invaluable and will help me a ton in future projects thank you for posting such a great, comprehensive guide on building it!

[hcdebey]

Excellent video. Too many people who post on YT, simply wing-it with pauses, mistakes, and other wastes of the viewer's time. Your technique is flawless.

[clifmassey]

Greatest. Instructional video. Ever.
I had no idea Google Sheets did all of this!!!
My team has so many projects that we can use these charts for. I legitimately cannot thank you enough!!!

[evgeniizorin]

What a well-explained tutorial! I managed to easily create a Gantt chart like the one in the tutorial and now motivation surges from within to learn more functionality of Google Sheets, which I didn't expect to be almost as powerful as Excel.

[chascoleman]

Takes me back. In 1980 we opened a Radio Shack Computer Center and everyone knew nothing about PC's and the company had nobody to train us, so we learned by doing. One young lad, a jerk who didn't like sharing, had found out how to make a simple formula (location = location above + 1) then he selected it and did a smear for where to copy it and hit enter. It was like magic, as the number 1 became a sequence down the page.
"How did you do that?" we all asked, as we knew only how to type numbers in cells and noting about formulas or copying them.
"Figure it out yourselves".
I did and thus a career in computers was born, though I thought the kid who wouldn't share was a jerk. He didn't last long, but I did.
How? By doing what I am going here, like you. Setting myself a task then finding others who know how to do it to learn from them. Humility and curiosity never wear out though my brain is a little slower after 42 years.

[samanthabenson]

This was a lifesaver! So easy to follow and I can't believe I created my own chart. Stellar!

[lydiasfontouri]

You have no idea how helpful all your videos are. They have helped me tremendously at work. Thank you for making this amazing material available for free. I am eternally grateful!!!

[retardbuster]

Explained every feature of Google Sheets. In 11 minutes. Great work!

[techy-ski]

Keyboard Shortcut to group rows is Alt+Shift+--> (not Ctrl+Shift as in the video). This was a life saver by the way!

[raheelzamir]

I was just in seeking of how to draw gantt chart but, you have teach alot in this video, thanks

[abbieninson]

This is the most beautiful thing i've watched in my entire life!