How to create a GANTT Chart in Google Sheets

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024

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

  • @WHIZBUSTERS
    @WHIZBUSTERS  3 месяца назад

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

  • @colmaggs4902
    @colmaggs4902 2 года назад +9

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

  • @WHIZBUSTERS
    @WHIZBUSTERS  3 года назад +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.

  • @achinisamaranayake1622
    @achinisamaranayake1622 2 года назад +4

    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
      @WHIZBUSTERS  2 года назад

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

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

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

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

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

  • @scramjet4610
    @scramjet4610 Год назад

    Excellent. Right to the point. No wasted time.

    • @WHIZBUSTERS
      @WHIZBUSTERS  Год назад

      Thanks! Super glad it was helpful 🙌

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

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

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

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

  • @Ednahh
    @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
      @WHIZBUSTERS  Год назад +1

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

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

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

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

      You're most welcome 😊 Very glad it helped.

  • @sehaba9531
    @sehaba9531 2 года назад +1

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

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

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

  • @saragadamsuresh
    @saragadamsuresh 5 месяцев назад

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

  • @francisdayrellcamba4172
    @francisdayrellcamba4172 2 года назад +1

    Informative and very helpful. Thank you for this video

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

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

  • @lesliemiller8340
    @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
      @WHIZBUSTERS  Год назад

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

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

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

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

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

  • @siarheisemashka1735
    @siarheisemashka1735 2 года назад +1

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

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

  • @kevindurham8980
    @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
      @WHIZBUSTERS  Год назад

      Thanks! Really glad to hear 😊

  • @sarkerda041
    @sarkerda041 3 года назад +2

    thanks a lot ,really helpful

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

    Incredibly helpful! Thank you so so much!

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

    This was extreemly helpful. Thank you!!

    • @WHIZBUSTERS
      @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?

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

    This video was very helpful and well articulated. Thank You

    • @WHIZBUSTERS
      @WHIZBUSTERS  2 года назад +1

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

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

    best explanation ever
    thank you

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

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

  • @doudar41
    @doudar41 Год назад

    Thank you

  • @wendelbonfim1583
    @wendelbonfim1583 Год назад

    thank you

  • @nikhilrane2879
    @nikhilrane2879 Год назад

    Thanks a lot, ma'am.

  • @ronaldoinchrist2274
    @ronaldoinchrist2274 Год назад

    Thank you very much

    • @WHIZBUSTERS
      @WHIZBUSTERS  Год назад

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

  • @shanewelagedara872
    @shanewelagedara872 Год назад

    Thank you so much ❤

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

    This video helped me a lot !!! THANKS

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

      You're most welcome! Very happy it helped.

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

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

  • @Benjiman6th
    @Benjiman6th Год назад

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

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

    Thank you so much

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

    Super helpful!

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

      Thanks so much! Glad it was helpful.

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

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

  • @neil9325
    @neil9325 Год назад

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

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

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

    • @WHIZBUSTERS
      @WHIZBUSTERS  2 года назад +1

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

    • @mostafavafaei6175
      @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
      @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
      @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
      @WHIZBUSTERS  2 года назад +1

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

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

    🤩🙏

  • @orlandoramirez2957
    @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
      @carlythorne7141 Год назад

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

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

    ty

  • @louielleangelobaltazar6867
    @louielleangelobaltazar6867 2 года назад +1

    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
      @WHIZBUSTERS  2 года назад +1

      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
      @louielleangelobaltazar6867 2 года назад +1

      @@WHIZBUSTERS Thank you! Appreciate you mate!

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

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

    • @WHIZBUSTERS
      @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
      ruclips.net/video/tofhm0BV-Dw/видео.html

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

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

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

      Thank you wonjoe82 for your question. I recorded this video for you ruclips.net/video/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 :)

  • @sansrititiwari5331
    @sansrititiwari5331 4 месяца назад

    Why can't I write March 20 to x axis end date or start date of all should be in x axis why bar

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

      When I used the same technique at 2:45 in the video, for Mar 20 2024 I got the value of 45371.

  • @sansrititiwari5331
    @sansrititiwari5331 4 месяца назад

    Why can't I write Jan 20 to x axis

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

      Hi @sansrititiwari5331. When I used the same technique at 2:45 in the video, for Jan 20 2024 I got the value of 45311. Kindly try that number.

  • @brexport2229
    @brexport2229 2 года назад

    Thank you

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

      You're most welcome. Glad it helped.