How to Create a Gantt Chart in Google Sheets

Подписаться 88 тыс.

Просмотров 897 тыс.

50% 1

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:
www.vertex42.com/ExcelTemplat...
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:
www.vertex42.com/ExcelTemplat...
MAKE A GANTT CHART IN EXCEL
Watch our popular video series on how to make a gantt chart in Microsoft Excel:
www.vertex42.com/ExcelTips/ho...
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:
www.vertex42.com/ExcelTemplat...
MUSIC CREDITS: Pixelate, by Zac Nelson, licensed via ArtList

Опубликовано:

11 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 747

@mohammadhasani5499 3 года назад

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

@drp2792 3 года назад

This is really great! Well presented, excellent info. I've been using spreadsheets for decades but learned a lot from this video!

@samanthabenson6951 2 года назад

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

@patriciasames5000 3 года назад

Awesome training tutorial!! I was able to create my tracker in no time, this was super easy to follow, nicely explained and great visuals to see what's going on. Thank you so much for putting this together!!

@w.v.1833 3 года назад

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.

@catrionarasdale 3 года назад

Wow, this is the tutorial that I've been searching weeks for. Incredible guide

@adamedison6831 3 года назад

The visuals on this are incredible. Excellent timing as well.

@Bob-jn8jt 3 года назад

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.

@bradydegrasse 10 месяцев назад

Hi Bob, How did you add your multiple projects? Example, let's say you had a dozen. Did you put them all into sheet one, or use one new sheet per project? I would love to know how to make multiple overlapping projects (you know, every manager's situation!) be visually represented as such--All happening at once! Thanks in advance! Brady

@aaron7c 2 года назад

I’ve been using google sheets for a while and I still learned an insane amount. Awesome tutorial!

@marcusnikander4535 3 года назад

This is one of the best tutorial I have seen! Good job. Thank you.

@kelrickds3084 3 года назад

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!

@vertex42 3 года назад

Thank you!

@kelrickds3084 3 года назад

@@vertex42 Do you have a video teaching how to make a linked subtask within the chart? The way I see it is the phase/task but I'm not sure how to make it make sence to create a phase/task/subtask.I know I'm going to add a column where I can assign subtasks to resources, if I can figure out how to set up the subtasks w/in this chat. I appreciate what youve' created!

@retardbuster1498 3 года назад

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

@kleinermary 3 года назад

This is amazing! Thank you so much for a great and super clear video! It is very well explained. I feel so proud of myself for getting my Gantt Chart together!

@mubafaw 2 года назад

Life saver! This is as straight to the point as it gets! Saved me £££ and the hassle of having to install software. Top lad! Cheers...

@bohannakin1 2 года назад

Thank you so much! I'm into the third week of my new job and needed better project management for the team and myself. I really appreciate the clear and concise lesson.

@DriniNosi 3 года назад

Such a super tutorial. Thanks a lot! So hard to find a good and free Gant chart, and you make it easy to understand how to set it up.

@ruby2bubbles 3 года назад

This is amazing for scheduling group projects and what needs to be done! :)

@hikmatlawal3110 3 года назад

first time an educational youtube tutorial has been actually helpful from beginning to end. Thank you so much!

@livingroomc 2 года назад

Thank you so much! I learned so much. Very helpful. I like how you built up a base chart and then added functionality. Also, you're showing all of the various functions was super helpful - especially how you would take a base function and then modify it - this made it helpful for me to not get overwhelmed as I learned.

@andreafernandez6464 3 года назад

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.

@evgeniizorin5716 11 месяцев назад

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.

@angelinasepulveda2160 3 года назад

I'm in literal excitement over the "group" element. Thank you so much for teaching us this step by step, as always, well done! I've been intimidated by Gantt charts and you explained everything so well. Excited to get started using this.

@lydiasfontouri3466 Год назад

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!!!

@kdnguyen99 3 года назад

Wow! Simply one of the best and simple tutorials I immediately want to try out. I was actually looking for a simple gsheet task tracker that fits my particular needs but I learned some very helpful features here that I can apply to my task tracker instead of trying to customize a template I previously found. If there is a good gsheet tutorial that can track tasks and do multiple levels of filtering for data like in Excel, I'm all ears!

@angelamouraocorcino5638 2 года назад

Wow! That's the best training tutorial ever. I learned more in 10 minutes than never before. Thank you so much.

@janettekim7638 3 года назад

Literally the most helpful Gantt chart video online!!! Tysm

@frauleinenriquez4915 3 года назад

this is so easy to follow! well explained, concise, and effective! thank you!

@rayc4050 2 года назад

Well structured and concise. Brilliant work!

@ryanmatthews6790 3 года назад

Wow thank you! You went above and beyond just showing us how to make a Gannt Chart

@acageybeard6478 3 года назад

Thanks so much for this tutorial. I Not only learned to make the exact gantt chart I needed. I also learned some new sheet tricks too!

@MaralSabbagh 2 года назад

Perfect tutorial, clear and not too long. Perfect ! Thanks a lot !

@clifmassey1300 2 года назад

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!!!

@ellinooridashwood Год назад

I went into this video hoping I could make a Gantt chart on my own, and you made that possible. Thank you for giving me more confidence with Google Sheets!

@robinmcgrother 3 года назад

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

@j9nathanaguilar244 3 года назад

Nerd

@iwantlee9510 3 года назад

yeah

@GrayOwl. 3 года назад

Microsoft Projects disliked. We can't have free things.

@MohamedTraore1 3 года назад

They are confused, they were trying to download the video. Awesome tutorial!!!

@scubadubba123 2 года назад

There's always negative Nelly's out there.

@RWatsonChung 3 года назад

This is truly one of the best follow along tutorial i ever used. I got mine magically done within the duration of your video. kudos man! like and sub !

@nancypuckett3848 Год назад

Thank you for actually providing a guide to create a dynamic Gantt chart within google sheets. I can't wait to begin using this for my upcoming projects!

@learningstuff5679 2 года назад

Thank you so much! Outstanding tutorial. Clear, concise, and to the point! Subscribed.

@alirioperalta7855 3 года назад

Infinitas gracias por el tiempo empleado en hacer este video. Increíble!

@jinyunghong 3 года назад

This is really amazing and helpful. Thank you!

@tomerhelzer Год назад

Thanks for creating this spreadsheet! It would've taken me hours setting it up on my own, so much appreciated!

@NanielAbanto Год назад

This is so fantastic! I only have a little knowledge in using google sheets but with your work this helps me a lot. Thank you so much and I hope you continue in giving tutorials to those like us.

@srose00333 9 месяцев назад

My first ever gantt chart and was able to follow through smoothly! Thank you so much!!!!

@dlachine101 3 года назад

Brilliant - the best tutorial to google sheets by far. Well done

@GOhimself 3 года назад

This is one of the best tutorial videos I've ever seen

@kolawoleladejobi6155 3 года назад

Thank you for the very detailed walkthrough, I have learnt a lot in this video

@zainzeta 3 года назад

Thx, This video cover what I need for my project management. This's very helpful, easy to follow. :))))

@tihouweepu 2 года назад

Probably one of the best and most helpful things I've watched on RU-vid. Thank you

@chascoleman6689 Год назад

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.

@KhoaNguyen-mg3qp 10 месяцев назад

This is the best tutorial I've seen in a very long time. It's concise, interesting, and easy to follow. Great job!

@pranjalsingh9154 3 года назад

What a great service you're doing with this videos. It's very helpful!

@jeangreen432 3 года назад

Fantastic Channel for Excel charts, thank you so much!!

@Chhabra_Shivani 2 года назад

This is exactly what I was looking for. Thank you so much for creating this video. Super helpful!

@karankathuria6054 3 года назад

One of the best tutorial seen so far.

@gocurt 3 года назад

Amazing tutorial, everything what I need in one place, thank you very much..

@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.

@karyeeliew8750 Год назад

So inspiring and it really helps me a lot in term of project planning!

@cheryllawrence6888 11 месяцев назад

This was so invaluable! Thank you for putting this together.

@FernandoFischer6048 Год назад

I am amazed how someone can explain so much in just 10 minutes!

@danielleetzehou9900 3 года назад

This Tutorial is just so useful and awesome ! NO regrets !

@natasjadorothy5425 2 года назад

From the bottom of my heart, thank you for an amazing tutorial! I really enjoyed this project .

@gracyluvsyou Год назад

Very informative and detailed. Thank you very much for the entire series. I could prepare my Gantt chart and present it well further. You have very good presentation and teaching skills. It was very easy to follow. Thank you once again.

@johnjairobernalgarcia3123 4 года назад

Man!!!! thank you very much! my boss will love this!

@CritAcademy 11 месяцев назад

Thanks so much for this tutorial. Was spot on, concise, and engaging. Thank you again.

@calico27 3 года назад

Thank you!! this is awesome, clear and sooo full of extremely valuable information!

@jimdowers138 3 года назад

Super helpful and really well done! Great job!

@sylivingumisiriza7781 10 месяцев назад

Thank you so much Vertex42. I just made my Gantt chart using your explanations and guidance. Very grateful.🙏🙏🙏🙏🙏

@newnumbdeep 3 года назад

This is sooo amazing! Super helpful! Thank you!

@graemewhite4975 4 года назад

Great tutorial, thank you so much.

@user-ge5ht2vg8k 7 месяцев назад

Absolutely one of the BEST tutorials I have seen. Thank you, I learned a TON

@sabinaabdullaeva3338 3 года назад

Fantastic video Vertex42! Was very helpful, thanks a lot!

@pedrolapenta37 2 года назад

awesome! although the only formula I didn't know is sparkline, it was great to see how much you can create on so few formulas. sometimes I struggle to create things in a simpler way and I think this video is a great example on how to do it.

@queenkai9522 Год назад

TY! So well put together and easy to follow!

@abbieninson Год назад

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

@mcv.4339 3 года назад

Love this! Thanks for this tutorial!

@sunnysideup2881 3 года назад

thank you for this. I have no idea how to create gantt chart and been struggling for couple of hours. BIG THANKS man!

@KairiJoesalu Год назад

Thank you so much for this step-by-step tutorial! I am very grateful and can now work on with planning various ongoing and upcoming projects!

@user-gj2xj1mc9w 3 года назад

This is insanely good!! Thank you!

@SV90527 3 года назад

Amazing!! I was struggling to do this in Excel.

@Archzed 10 месяцев назад

I like that you added styling between explanation parts so that we concentrate, rest, then concentrate again

@michaelanciro4761 Год назад

This is my current format for my gantt chart.. Awesome Tutorial. Very informative and very easy to follow.

@celestechan88 3 года назад

Thank you so much! This was really helpful.

@JustinFranzUy 16 дней назад

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.