Creating a Gantt Chart in Google Sheets
HTML-код
- Опубликовано: 30 июл 2024
- This video shows how to create a Gantt Chart in Google Sheets, and how to customize it.
Gantt Chart Template: goo.gl/yoaAMW
Trevor Fox's Blog: goo.gl/OxJDGc
Table of contents below:
00:00 - Introduction
00:40 - Labeling
02:57 - Dropdown for status
04:00 - Creating the bar chart
09:16 - Changing colors of tasks
13:39 - Burndown bar
14:54 - Overall project timeline
19:26 - Adding and deleting tasks
20:55 - Conclusion
Dear Ilya, What a great explanation of such a complex chart creation. It is surely very helpful. Thank you for sharing it.
Thank you for your kinds words!
Nice video content! Apologies for butting in, I would love your thoughts. Have you heard about - Weydaniel Organized Dominator (google it)? It is an awesome exclusive guide for getting 7000 plus project management and business templates without the normal expense. Ive heard some great things about it and my m8 after many years got excellent success with it.
It's the best gantt chart tutorial I've ever seen! I looked it up a few years ago, and didn't find any solution this clean. Very amazing!
Thank you for your kind words! I'm very glad it was helpful!
Very generous of you to share both the template and the instructions on how you created the formulas so we understand how it works. I used your template, shared with a client and received positive responses from them. Big Thanks!!
I'm so happy to hear I could help!
You are absolutely awesome. The end result is very elegant and simple. I actually typed the formulas myself instead of using the template, so that I could understand everything you did, and it's amazing.
I'm very glad I could help!
This was wonderful. it's exactly what I needed and your video was very helpful to watch to explain how each thing worked. Sometimes templates are confusing because you have to decipher what it does, if you need to tweak it, but the video removes that problem. Thanks!
This is a very well thought out tutorial and excellent final Gantt Chart in Google Sheets. Thank you for making this available Ilya!
I have never seen anyone demonstrate a black belt in spreadsheets before. I am in awe of your skills.
Thanks!
I am so grateful for your sharing. I am planning a project to refurb my apartment and this tool is just what I needed to look like a careful and responsible Self Build project manager when I come to present the project to a Lender. Many blessings to you.
I think this is the best Gant chart tutorial in RUclips. Congratulations!
This is a very high-quality video; thank you so much. Both the content and the pacing are excellent.
Wow wow wow, the most amazing Spreadsheet tutorial I’ve found so far. Excellent step by step hands on illustration both visually and logically. You’re among the best talents I’ve met. Thanks so much.
Thank you for your kind words!
This is a great template. Really appreciate you putting this together, sharing it and explaining how it works. Cheers!
Great demonstration with a great level of detail in a short period of time. Of course, you putting the template in the notes makes it incredibly useful. Thanks.
I'm very happy I could help!
This is the best free, easily shareable Gantt template available on the internet, thanks so much for making the tutorial and providing the template!
Thank you for your kind words! And I'm very glad I was able to help!
TNice tutorials is one of the best tutorials of ANYTNice tutorialNG that I've ever watched in my life! Thank you so much!
Very nice work! You really explained the process well and paced the example for better understanding. Well done.
One of the best explanations I’ve seen about anything, and I don’t make those comments like them. Thank you for your work and I will go to download the template if it’s still available.
Brilliantly done
Thank you! I hope your project turned out well!
Absolutely gorgeous, thank you so much Ilya! You template works like a dream so far :-)
Wow, great job. this is incredibly helpful not just the chart template but your concise, digestible walk through as well.
Thank you for the kind words!
You are just awesome!! I have been waiting for this for years. So many apps are making money by holding this functionality as carrot. You are doing a big favour to hundreds!
Thank you for your kind words! Indeed, I too was surprised by how difficult it was to find a free, collaborative tool for this.
Incredible job my dude! Made my Design Project go much more smoothly! You are a real one
Really thankful for your generosity to share such a useful method and template for creating Gantt Chart with Google Sheets
After a long search and lot many videos for gantt chart, my search is over and finally i found something very related to my project. Thanks for sharing it
It's my pleasure! I'm very glad I could be of help!
@@IlyaMikhelson I had one query, can we have a highlighter line to show the Today line. I know we can see with the burndown but it would be more visual if we can have a highlighter.
TNice tutorials is by far, the best tutorial I have found so far. I feel like I’ll be spending a lot of ti on your channel! Thanks man! Keep up the good
Very clear presentation! Thank you so much for going step by step and for the completed template! I look forward to viewing more of your informational presentations!
Thank you for your kind words!
Really cool of you to take the time to share this. Thank you.
So much value in one video. Thank you for making and sharing this!
I really appreciate the time and knowledge you provided. Helped me overcome a frustration for me!
I'm very glad I could help!
I am now using this file! Wow! This is exactly what I've been searching for! You are a genius! I immediately subscribed! Thank you so much! You are so brilliant!
Thank you for your kind words! I'm very glad I could be of help!
You have explained this really well. Thanks for taking the time to do this!
It's my pleasure to help!
Great video and very well explained. When you said this is where it will get ugly and complicated, I took that as this is now the best bit.
This is the most helpful tutorial I have seen for a Gantt chart. Thank you so much.
Thank you for your kind words! I'm happy I could help!
Thanks so much! This was a HUGE help for me to build construction schedules. Saved me hours, cheers!
Really glad to help!
This kind of videos are very helpful to students. Please keep doing this kind of work. Thank you!
Great production quality, besides the amazing final product, good job and thank you for the input
Sparkline can be a long and convoluted formula so it did need a good explanation... and you explained it fantastically ... .thanks!
Excellent. Thanks for explaining so clearly. One of the best tutorials :)
Quite possibly the most helpful youtube video ever created. Thank you Ilya!
Thank you for your kind words! You are most welcome!
Man these are very nice advanced googlesheet tips.
Thank you very much! Nice job!
Thanks IIya for the awesome knowledge shared.Saved my time in creating gantt for my existing clients.
I'm very glad I could help!
perfect, highly efficient.
his students in northwestern are lucky
Very clear explained, thank you Ilya for the great tutorial
Fantastic! Thank you very much. This was very helpful and I learned a lot through being able to make a copy of my own chart for implementation and study.
Thanks for your generous contribution to our projects! I've downloaded your template and adapted to have the two versions by deleteing the rows. Best wishes to you. :)
I hope your projects are going well!
I would like to get the template but I cannot locate it.
I want to say THANK YOU so much for this!!! This is really amazing and I recently used it to created a project tracking sheet which worked out great.
I'm so glad to hear I was able to help you!
Garrett Evans Wow thank you Garrett, you've made my day!
Thank you! Exactly what I was looking for. Very well explained.
Thanks a TON for this video and the Gantt Chart template! I needed to create a Gantt chart for a college project and this made it very easy in Google Sheets!
I'm very glad I was able to help out!
awesome video - great detail and user friendly with your commentary and support docs - thank you!
Very glad to help!
Ilya,
There is a great added value to your work.
I used your various formulas into my spreadsheet and it works just fine.
I'm glad you were able to generalize this work and modify it for your purposes!
Lovely sir. Each and every step makes loads of sense while monitoring the project. Just trying to add the budget part of it which I think i can handle. Thank you
I'm very glad I could help!
The Best Explanation !!! I referred to many videos , but out of all tNice tutorials was the best I could find among all .... Also got to know many tNice tutorialngs
Bless you for doing this. It's very generous of you. Many, many thanks.
But their dates are not real.
The same is not true with real dates!
Amazing. And inspiring. Love watching how you created. Learning a lot.
Thank you for your kind words!
Ilya - Fantastic video. I'm just migrating from Excel to Google Sheets, and this is really good.
The collaborative aspect of Google Sheets is great, and I find that most functionality of Excel is there. Hope the transition goes smoothly for you!
I can't believe literally no one is talking about how satisfying Nice tutorials voice softs.
Thanks man really helpful, really great voice & explain so gentle, easy to understand, absolutely useful for newbies like me
Thank you for your kind words! I'm very glad I was able to help!
Thank you for making this,
Ilya!
Incredibly helpful. Thank you for your instruction and the template!
My pleasure! I'm glad I could be of help!
Many thanks for Sharing Ilya! Really very useful! and very clean and clear Explanations! Great!
My pleasure!
Thank you so much. This is an excellent tutorial and helped me immensely.
I'm really glad to help!
Thank you for creating this video - it is really helpful and clear.
It's my pleasure! I'm glad I could be of help!
This is beautiful, thanks for sharing your knowledge and the template.
I'm very glad you found it useful!
Nicely done...a very useful spreadsheet/gant chart and an excellent tutorial.
Thank you so much!
Great explanation. Thank you for this educational video.
Excellent video! Thanks a lot for explaining what happens "under the hood". I can now make the modifications I need in order to make it work for my team.
I'm very glad to hear that!
I was about to start one on my own, thanks for sharing!
This was truly amazing! Great job!
But their dates are not real.
The same is not true with real dates!
Thank you for the great explanation and for providing the template! Much appreciated!
It's my pleasure!
Thank you very much for sharing this template. Will be using it for a non-profit related project and you would be a part of the impact created. :-)
I am honored by your statement! I hope your project goes well!
Thank you. Really helpful. Great explanation
Brilliantly simple - GREAT job. thx
I'm very glad I could be of help!
This was a very helpful video, thank you!
That's way beyond my expectations !!! learning unexpected skills thanks to you ! :-)
It's my pleasure!
Awesome tutorial and template. Thanks so much!
This video was very helpfull. your explanation helpped me take it even further. Keep up the good work.
I'm very glad to hear that!
I never comment, but this video is excellent! Also nice piece of coding. Thank you!! This is exactly what I need.
Thank you for your kind words! I'm glad I could be of help!
Thankyou very much! This is very helpful and your template saved me a lot of time!
I'm happy to be able to help!
Thanks bud! great video and instructions.
Excellent guide. thanks. Just one tip: if you want to prevent the dates from auto-incrementing when you drag the corner of the cell and then having to manually clean up the dates, just hold down CTRL while dragging and all the dates in the following cells will be the same as the initial cell's date.
Glad to help! And thanks for the tip!
Thank you, very helpful instructions!
Thank you!! This works really well for project
This was awesome...now I need to try it for my project. Thanks!
You're very welcome!
Thank you very much! I thought that I knew something about Google Sheets and could even do some things. But after your amazing video I understood that I'm haven't even used yet this tool =)
I was definitely surprised at the amount of work that had to be done to create something as conceptually simple as a Gantt chart. But I was happy at the amount I learned about Google Sheets in the process. And I'm glad I could share it with everyone :)
Thank you very much! You saved me a good night of sleep!
Glad to help!
Very well explained, well done!
Good job! Thank you! Simple with the download example. I added this to my favorites.
Thank you for watching!
it helps me a lot. very detailly explained. just perpect!!!!!
I'm very glad I could help!
Wow, helped a lot. Thanks for sharing!
Excellent! thanks for sharing , ITS VERY HELPFUL!!!!
Awesome Explanation. Thx!
thank you so much for the explanation!
VERY HELPFUL! Thanks man!
What an outstanding video. Thanks a lot!
Thank you! This was super helpful!!
Great stuff Ilya, thanks!
Really helpfull tutorials. Helped a lot
The video is great, but I wouldn't be able to do this myself. I used your template, did some tweaking, and now we're using it on a project! Thanks man!
I'm very glad I could help!
Hi Ilya - Thanks so much for this - a great help.
My pleasure!