How to create a GANTT Chart in Google Sheets

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

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

50% 1

🌟🌟NEW FREE ENGLISH QUIZZES🌟🌟
whizbusters.teachable.com/p/e...
💰2000 questions
💰Basic, Intermediate, Advanced Level
💰Word Quizzes + Sentence Quizzes
💰Video Solutions for each answer
💰No login required
💰Enhanced your English vocabulary anywhere and anytime
***************************************************************************************************** Please comment below on:
What additional topics/questions you'd like to see videos about?
I take your feedback seriously and work to create education content that will be useful for you!
Master the #GANTT Chart in just 3 quick and easy steps for your #PROJECT with #GOOGLESHEETS
Time Stamps
00:00:00 Objective
00:00:13 What is a GANTT Chart
00:00:32 Example
00:00:50 Insert Stacked Bar Chart
00:01:45 Change horizontal axis date format and starting date
00:03:13 Format Chart
INDEX function: • EXTRACT values and arr...
MATCH function: • MATCH Function explain...
VLOOKUP function: • Master VLOOKUP explain...
FUNCTIONS: • Playlist
PROBLEMS: • Playlist
ORGANIZE DATE: • Playlist
IFERROR Function Support Docs: support.google.com/docs/answe...
VLOOKUP Function Support Docs: support.google.com/docs/answe...
INDEX Function Support Docs: support.google.com/docs/answe...
Let’s connect on social:
Instagram: /
LinkedIn: / whizbusters
Twitter: / whizbusters
Facebook: / whizbusters
www.whizbusters.com
#GoogleSheets #MsExcel #englishlanguage #worddefinition #learnenglish #englishvocabulary #pronunciationguide #languagelearning

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

5 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@WHIZBUSTERS 2 месяца назад

🌟FREE ENGLISH VOCAB QUIZZES🌟 whizbusters.teachable.com/p/english-quizzes

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

Simple and to the point. Very helpful, thank you. I wish I'd found this video before watching all the other far too complicated ones.

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

Thank you very much Col! I'm very happy to hear that. What other Google Sheets/MS Excel questions would be helpful to you as video tutorials?

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

Thank you so much for this! You made it so easy and simple. I watched your video after feeling so frustrated trying (and failing) to follow two other online tutorials. You make this so simple and easy.

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

You're most welcome Achini! I'm absolutely happy it has helped! :)

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

SUBSCRIBE to my channel for more informative content as I publish content DAILY. COMMENT below what topic/s you would like to see more videos on and I'll publish content on your topic. LIKE this video if you found it helpful. SHARE with your teammates and friends to spread the knowledge and make your team efficient and knowledgeable. THANK YOU for watching this video.

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

Incredibly helpful! Thank you so so much!

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

You're most welcome!

@scramjet4610 Год назад

Excellent. Right to the point. No wasted time.

@WHIZBUSTERS Год назад

Thanks! Super glad it was helpful 🙌

@sarahsummers626 8 месяцев назад

only video that has actually been helpful. thank you so much!!

@WHIZBUSTERS 8 месяцев назад

Thank you @sarahsummers626 ! So glad that it is helpful 😊

@georginasantos8079 2 месяца назад

Thank you so much!, exactly what I was looking for! :)

@WHIZBUSTERS 2 месяца назад

You're most welcome 😊 Very glad it helped.

@lesliemiller8340 Год назад

Very helpful. Thank you so much for sharing. I love it and will be putting these tips to good use. I so appreciate this.

@WHIZBUSTERS Год назад

Thank you for your comment. Very happy to hear it was helpful 😊🙏🏻

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

This was extreemly helpful. Thank you!!

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

You're most welcome Natasha! Glad to hear that. What other Google Sheets/MS Excel questions would be helpful to you as video tutorials?

@sehaba9531 Год назад

Thank you so much for this amazing video, you just saved my life. Very easy to follow and simple steps

@WHIZBUSTERS Год назад

I'm incredibly happy to hear it was helpful. You're most welcome 😊

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

Informative and very helpful. Thank you for this video

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

Thank you Francis and you're most welcome. :)

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

This video was very helpful and well articulated. Thank You

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

Thank you very much. I'm glad this was helpful.

@waihlyanhein1046 6 месяцев назад

Thank you , ❤ finally,I can submit project because of you

@WHIZBUSTERS 6 месяцев назад

You're most welcome 😊 I'm so glad to hear it helped and you were able to submit your project 👏😊

@saragadamsuresh 4 месяца назад

You made my day ! thank you, got work done !

@WHIZBUSTERS 4 месяца назад

Glad I could help!

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

thanks a lot ,really helpful

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

Glad you found it helpful.

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

This was life Saving!!! and so easy to follow ..hat to like and comment

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

Thanks so much Shnika@ Really glad to hear this was helpful!

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

best explanation ever thank you

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

Thanks so much

@kevindurham8980 Год назад

Great step-by-step tutorial. I actually use a ready to use gantt chart Google Sheets template I downloaded from someka but this is also not bad. Thank you for the video:)

@WHIZBUSTERS Год назад

Thanks! Really glad to hear 😊

@shanewelagedara872 Год назад

Thank you so much ❤

@WHIZBUSTERS Год назад

You're most welcome 👍

@Ednahh Год назад

I had a hard time trying to find a way to change the numbers to dates, and you just helped Me a lot. Thank you so much💕💕💕💕 I wish I could review more than this bcz you just saved Me big time🤗🤗🤗🤗. May GOD bless you!!

@WHIZBUSTERS Год назад

I'm very happy to hear this helped you a lot! Thanks for letting me know. Super glad it helped.

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

Thank you so much

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

You're most welcome Liliana

@ronaldoinchrist2274 Год назад

Thank you very much

@WHIZBUSTERS Год назад

You're most welcome! Very happy it helped. 👍

@doudar41 Год назад

Thank you

@WHIZBUSTERS Год назад

You're welcome. Glad it helped.

@nikhilrane2879 Год назад

Thanks a lot, ma'am.

@WHIZBUSTERS Год назад

You're welcome Nikhil.

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

This video helped me a lot !!! THANKS

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

You're most welcome! Very happy it helped.

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

Thanks Cristhian. Glad to hear that. What other video topics would be helpful to you? I would work towards creating it.

@lauravitelli Месяц назад

is there a way to set dependencies between tasks and then show them in the chart, please?

@neil9325 Год назад

I cannot find the min or max boxes under the horizontal axis edit window. How do I activate those?

@wendelbonfim1583 Год назад

thank you

@WHIZBUSTERS Год назад

You're welcome

@Benjiman6th Год назад

Can you update this? The newer version doesn't have the scale factor

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

Super helpful!

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

Thanks so much! Glad it was helpful.

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

Thanks monzrocks. Glad to hear that. What other video topics would be helpful to you? I would work towards creating it.

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

🤩🙏

@adityakumar-md9lv 2 года назад

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

You're welcome Aditya.

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

Hard to restrain from hitting the "like" more than once) Thank you!

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

Thank you so much for your kind comment. I'm super glad you found it helpful. If there are any other problems or questions you may have please let me know and I'll do a video walkthrough for you to answer your question.

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

Hey. That's a great video. thanks a lot

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

Thanks Mostafa. Glad to hear that. What other video topics would be helpful to you? I would work towards creating it.

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

@@WHIZBUSTERS Thank you for your question. I've checked you videos and I saw that your cover different areas. In my side, I think some videos that cover Google apps will be very useful.

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

@@mostafavafaei6175 You're most welcome. Yes I have a variety of topics for different learners. Thank you for your suggestion. I would love to do a series on Google apps. What are some questions you'd be interested in getting answered?

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

@@WHIZBUSTERS Thank you for your answer. I have a main big question. I want to automatically check my google drive and sort the documents based on my own files, and the other shared files with me. I should write an script in google script. But, can't solve it yet.

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

@@mostafavafaei6175 Hi Mostafa, that's a great question and I think I can better guide you to Ben Collins for App scripts specialisation :)

@orlandoramirez2957 Год назад

So I am not getting the option to number format, for my horizontal access. It only shows up to 'Slant labels', is there something I can do to edit this?

@carlythorne7141 Год назад

I am having this issue as well, did you end up resolving it?

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

may i know will it possible to add in dateline in month at the end bar?

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

Thank you wonjoe82 for your question. I recorded this video for you ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Bx9UORyBTZk.html Currently Google Sheets does not allow the Combo Chart option to add a dateline to a stacked bar chart so I added marker bars for the current date in the video for you. Hope this helps :)

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

Yow, how'd you turn the date into a serial number. In my google sheet, I'm not really sure why, but the conversion into serial number of the date wasn't responding well. Can I ask for an advice?

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

Hi Louielle, thanks for your comment. Yes, if the instructions from 2:47 onwards isn't responding well for you, you can try the formula = DATEVALUE(date_string) formula. You can reference a cell with your date as the parameter.

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

@@WHIZBUSTERS Thank you! Appreciate you mate!

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

@@louielleangelobaltazar6867 You're most welcome. Glad I was able to help :)

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

@@louielleangelobaltazar6867 Check out my latest fun video: Different from analytics - but a funny sing-along (Animojis) - 12 DAYS OF CHRISTMAS SING ALONG with ANIMOJIS ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tofhm0BV-Dw.html