Make This Awesome Gantt Chart in Excel (for Project Management)

Поділитися
Вставка
  • Опубліковано 30 жов 2024

КОМЕНТАРІ • 243

  • @adelinogoncalves9963
    @adelinogoncalves9963 8 місяців тому +17

    The most intelligible Gantt Chart tutorial I´ve seen by far, thanks a lot Kenji, great job!

  • @me2507b4u
    @me2507b4u 6 місяців тому +7

    Thank you, Kenji! This video was a life saver. Really well explained. I was able to create a project plan so easily. Much gratitude to u!

  • @deansdrone
    @deansdrone 7 місяців тому +26

    Thank you so much really fun learning this. In the formula =EN(H$7>=$C10;H$7

    • @ondrop
      @ondrop 6 місяців тому +2

      same here :) thanks man!

    • @annablarin6092
      @annablarin6092 Місяць тому +2

      In the above formula I'm not being able to clear the "$" symbol

    • @furkanyildirim3644
      @furkanyildirim3644 Місяць тому +1

      We considered 1 week as 5 days. Therefore, we need to multiply cell E10 by 1.4 and write it into the formula. As a result, the final form of the formula will be as follows:
      =AND(H$7>=$C10;H$7

  • @HotButteredCorn
    @HotButteredCorn 3 місяці тому +15

    Kenji: Outstanding! Very helpful. Thank you. However, for those of us who actually practice project management, there are a few items missing in many Excel Gantts. Tasks often need to include one of the following:
    Finish-to-Start (FS): Task A must be complete before Task B begins.
    Finish-to-Finish (FF): Task A must be complete before Task B can be complete.
    Start-to-Start (SS): Task A must have started before Task B can start.
    Start-to-Finish (SF): Task A must have started before Task B can finish
    Any ideas about how to include this? 🙄😀

    • @probodhnayak3167
      @probodhnayak3167 2 місяці тому

      I too have a problem with designing this in the excel Gantts Chart

  • @Consultelainewilliams
    @Consultelainewilliams 5 місяців тому +5

    This is the most straightforward Gantt chart I’ve come across. I completed it and felt very accomplished. Thank you.

  • @pushparajput5209
    @pushparajput5209 8 місяців тому +4

    again, I find my interest to learn excel, after listening you. thank you

    • @KenjiExplains
      @KenjiExplains  8 місяців тому +1

      that's awesome to hear thank you!

  • @thanh-tunglai8778
    @thanh-tunglai8778 7 місяців тому +3

    Thank you, Kenji, I wish I had found your channel sooner.

  • @mr.alsifat1504
    @mr.alsifat1504 8 місяців тому +4

    It was a breakthrough for me,
    So easy way to understand and creating a gantt chart. Thank you.

    • @KenjiExplains
      @KenjiExplains  8 місяців тому

      That's awesome to hear thank you for your comment :)

  • @danguardo9501
    @danguardo9501 7 місяців тому +2

    great video, thank you. i also had some issues using network days. is there a solution? can you create predecessors or dependants?

  • @cigartrend
    @cigartrend 3 дні тому

    hope it works tried many online templates finally can make my own

  • @MitchellArgall
    @MitchellArgall 5 місяців тому +1

    I did not have the "freeze pane" in my Gantt chart. Makes it much more appealing now. This was an awesome video and your speaking tone was spot on and easy to follow along.

  • @ijeunachukwu8925
    @ijeunachukwu8925 6 місяців тому +1

    THE BEST SO FAR

  • @kabeerjijel4688
    @kabeerjijel4688 5 місяців тому +3

    Thanks.Great job. I completed the Gantt chart and am very excited to implement it. You are excellent, sir

  • @kinesiology-moves9598
    @kinesiology-moves9598 6 місяців тому

    Thank you Kenji. Great tutorial. I am a complete Xcel Beginner, so I don't know where these formulas all come from. How can I learn more about that?

  • @njabuloitsibeleng
    @njabuloitsibeleng 13 днів тому +1

    Can you explain how to calculate the progress figures; it looked like you just entered random numbers. Thank you!

  • @VishnuVardhan-sj6nd
    @VishnuVardhan-sj6nd 7 місяців тому +5

    Hey Kenji! Great Lesson as always :) I noticed that when I apply 'Networkdays()' in the 'Days' cell, the final 'dark green fill' doesn't get tabulated properly. I switched to simple subtraction of 'end date' - 'start date' and the fill works perfectly.

    • @KenjiExplains
      @KenjiExplains  7 місяців тому +1

      Thank you! Awesome that you figured that out 👍

    • @sudhakarnote
      @sudhakarnote 7 місяців тому

      Excel file link ..pls share

    • @pinko-u6y
      @pinko-u6y 2 місяці тому +3

      the final "dark green fill" didn't work for me either but your comment inspired me to figure out what the issue was. So apperently the rule we created for the dark green fill didn't take weekends in account. So we need to modify the formula =AND(H$10>=$C12, H$10

    • @JBIFSGuides
      @JBIFSGuides 2 дні тому

      @@sudhakarnote make it yourself friend.

  • @daisysarming3546
    @daisysarming3546 7 місяців тому +1

    Thank you so much for that insightful easy to follow tutorial.

  • @BKZ897
    @BKZ897 14 днів тому

    awesome video .... most useful video I have ever seen for project management 🙏🙏🙏

  • @arpanatikekar8699
    @arpanatikekar8699 13 днів тому

    Thank you for such a brilliant and detailed explaination!

  • @araze3195
    @araze3195 7 місяців тому +10

    Hi the progress bar and timeline doesnt coordinates when you use network days, can you please tell how to fix it?

    • @furkanyildirim3644
      @furkanyildirim3644 Місяць тому

      We considered 1 week as 5 days. Therefore, we need to multiply cell E10 by 1.4 and write it into the formula. As a result, the final form of the formula will be as follows:
      =AND(H$7>=$C10;H$7

  • @JBIFSGuides
    @JBIFSGuides 2 дні тому

    Great video!!!

  • @kutub52
    @kutub52 5 місяців тому +4

    This video deserves more likes and more views, awesome content

  • @PeterSimons-d5h
    @PeterSimons-d5h 2 місяці тому

    Just used Kenji's explanation to make my first construction timeline. Easy to understand and translate to my own works
    Thanks!!!!!!!

  • @themosdiary
    @themosdiary 5 місяців тому +1

    Thank you so very much for the insightful video, this was truly simple and easy to follow. I have just made my first gantt chart with no cheat and I feel proud.

  • @kamaldhamija3288
    @kamaldhamija3288 5 місяців тому +2

    Thanks Kenji, it was total fun to learn this from your video, keep progressing and if possible can we show the delayed task in this gantt chart

  • @suhass7164
    @suhass7164 Місяць тому

    Thanks Much for explaining with lot of patience and highlighting about formulas in detail

  • @KevinOKeefe-qw8cl
    @KevinOKeefe-qw8cl 4 місяці тому +1

    Thanks. Very helpful for making a quick gantt chart for simply tracking projects without having to use MS Project.

  • @pete7019
    @pete7019 5 місяців тому

    This is really great! Got mine set up! I did notice though that the -1 fix doesn't work for all of the bars. I changed my progress % to all 100 and there was one bar that wasn't showing full. When changed to all 0%, two bars showed a start. Rest of it work great!

    • @pete7019
      @pete7019 5 місяців тому

      Actually, removing the -1 is what causes the two green bars but the rest show no progress

  • @sapaktam2550
    @sapaktam2550 2 місяці тому +3

    this is very good. i have been doing this manually. draw and update the bar chart manually. i got 2 problems with this template:
    No. 1: when my starting date for an activity is in the middle of the of the week. the schedule marking in green show the following week.
    No. 2. if my starting date and finished date fall in the middle of the week, the green schedule does not appear at all.

    • @anouko.9001
      @anouko.9001 2 місяці тому

      I have the same problem(s) and I haven't figured out how to fix it. I concluded that: if start of the week is 29-07-24 but the start of task is 1-08-24 it is somehow not considered greater than or equal to 29-07-24... :(

  • @okasanjaya6587
    @okasanjaya6587 5 місяців тому +3

    Thank you for the amazing content, very helpful in making the Gantt Chart easier with the simple explanation in this video, god bless you Kenji 😇💚

  • @RCSMgmt
    @RCSMgmt 4 місяці тому +1

    This is brilliantly executed; informative, concise, yet thorough-not to mention polished. Thanks very much taking the time, it's been extremely helpful.

  • @tahirif1138
    @tahirif1138 6 місяців тому +2

    This the 1/3 excel gantt chart video I seen and tested that actually works. Great work keep it up.

  • @PavankumarHarapanhalli
    @PavankumarHarapanhalli 5 місяців тому +4

    Thank you for the great explanation; If the number of days is

    • @V21IC
      @V21IC 3 місяці тому +1

      The percentage status is per week or part of a week.
      It's either 100% or 0% of a week.
      There's another technique that requires a lot of formulas and some coding.

  • @TurtleMingea
    @TurtleMingea 5 місяців тому +6

    For MAC users, you need to select new rule --> classic --> use a formula... (for the conditional formatting part with the dynamic slides) and use ; rather than ,

  • @raja.mubbasshir9072
    @raja.mubbasshir9072 5 місяців тому +5

    Thank you so much, just a questions, the %completion not working fine with small duration tasks, like say the task is 7 days or so with weekly scale

  • @wendeesexton3607
    @wendeesexton3607 Місяць тому +2

    Do you have example for gannt per hour over multiple days

  • @rexencatz9075
    @rexencatz9075 7 місяців тому +1

    Hello Kenji thank you very much. How about if you want to revise the end date while still reflecting the original end date? Example you want to extend the end date by 2 more weeks. Thank you for noticing..

  • @AmaraGreyRC
    @AmaraGreyRC 3 місяці тому +1

    Very very helpful Kenji!!!!

  • @jeremymcdonald6928
    @jeremymcdonald6928 3 місяці тому +1

    This is a really great chart. I really appreciate the time you took to make this video. It is super helpful. One bit of advice, slow down when you are talking. You are moving way too fast in speech and in video. This is a VERY GOOD tutorial, but you move WAY too fast to follow - and I am experienced in excel.

  • @RoxanneWilliamson-ez8zb
    @RoxanneWilliamson-ez8zb 3 місяці тому +1

    Thank you so much ! I do a lot of data analysis and tracking so this is very helpful 👏🏾

  • @chukwudichukwuma3309
    @chukwudichukwuma3309 17 днів тому

    Please, which formula did you use for the progress, that converted it to percentage or did you manually type the figures?

  • @asselzhakenova9843
    @asselzhakenova9843 Місяць тому

    thanks so much, I have used it today. very handy.

  • @stellastelione8988
    @stellastelione8988 2 місяці тому

    Thank you very much for thid dynamic tool! It is very helpful in case other PM tools are not available.

  • @V21IC
    @V21IC 3 місяці тому

    Wow! Thank you!
    I've seen anything looking easier!
    I'll have to test it though.

  • @mohamedghadi988
    @mohamedghadi988 Місяць тому

    Thank you for this interesting Gant Chart

  • @thefuturepacesetters
    @thefuturepacesetters 3 місяці тому

    Great work done. It was fantastic one. However, when I got to the percentage side, I was getting True throughout. What could be the problem?

  • @jayscore7182
    @jayscore7182 4 місяці тому +1

    Thank you helps a lot! What can I add to my function so weekends don't become highlighted on gantt by the dates for start and end?

  • @jk30109
    @jk30109 Місяць тому

    Thank you sir, it is very helpful.😇

  • @M1800dk
    @M1800dk 4 місяці тому

    Hi again, and sorry, but I found out :-) In Denmark we have to ude ; instead of , so now it works fine, so tanks for a super tutorial 👍

  • @durga8285
    @durga8285 3 місяці тому

    you were amazing! And helped save the day for me! Clear, right pace and very articulate!
    Thank you!

  • @jesseegitaine4219
    @jesseegitaine4219 3 місяці тому +1

    You are GREAT! Thank you!

  • @trudyjose9978
    @trudyjose9978 2 місяці тому

    Simply the best🙌🏾

  • @md.anwarulkabir3020
    @md.anwarulkabir3020 24 дні тому

    Hi Kenji. Thanks for this, really awesome!!! Just one point if the end date exactly matches with the date of the calendar then the last cell doesn't take the green color due to this minus 1 in the formula. Could you please check and suggest how can I clear it? Appreciate!

  • @KevinDeAnda-vw7ww
    @KevinDeAnda-vw7ww 5 місяців тому +1

    Great video, Awesome job!

  • @KunalJhavar
    @KunalJhavar 6 місяців тому

    Hello,
    It is very nice and informative video. However, i am facing issues in month timeline as it was not showing proper % marking on the chart.

  • @r1cer825
    @r1cer825 4 місяці тому

    This is one of the best, or the best tutorial I have ever seen for that kind of stuff... great job. You're really informing and smooth.... great job.... thx for that. was looking for such a video for a long time...

  • @tuncaykamas5275
    @tuncaykamas5275 Місяць тому

    Voow many thanks, you are awesome man

  • @alizameeruddinkhan3916
    @alizameeruddinkhan3916 4 місяці тому +4

    can you provide a downloadable link for this Gantt chart ?

  • @khwaab4284
    @khwaab4284 4 місяці тому +1

    Brilliant. Loved it

  • @Laura-lq9ox
    @Laura-lq9ox 20 днів тому

    Is it possible to use a gantt chart over a 5 year projection with the project scenarios, each with various activities? Everything I see is shorter term and wondering if it's Gantt charts have certain timeline limitations. thank you -- Laura

  • @hasanmohammadtareq89
    @hasanmohammadtareq89 8 місяців тому +1

    Awesome! Thanks from Bangladesh.

  • @ajanstudio343
    @ajanstudio343 2 місяці тому

    Superb! The best! Thank you very much!

  • @udaysinhbhosale788
    @udaysinhbhosale788 7 місяців тому +4

    Thanks for this video, seems there is issue in formula. week numbers are derived by adding +7 for each week, however for progress you have considered only workweek (5 days i.e =AND(H$7>=$C10;H$7

    • @zinzinrhea
      @zinzinrhea 7 місяців тому

      =AND(H$7 >= $C10, H$7

    • @furkanyildirim3644
      @furkanyildirim3644 Місяць тому

      We considered 1 week as 5 days. Therefore, we need to multiply cell E10 by 1.4 and write it into the formula. As a result, the final form of the formula will be as follows:
      =AND(H$7>=$C10;H$7

  • @lpaone01
    @lpaone01 4 місяці тому +1

    Thank you, Kenji. That was priceless.

  • @ahmedsani6591
    @ahmedsani6591 4 місяці тому +1

    Awesome! Thank you.

  • @nubhizeibaddy8587
    @nubhizeibaddy8587 Місяць тому

    Thank you

  • @heshamhaboob3285
    @heshamhaboob3285 Місяць тому

    Thank you very much, sir, but I have a question. If I have an activity for a period of time and there are two days off during that period, what is the equation that I can enter so that the period of implementation of this activity is extended for two additional days?

  • @Masishamo
    @Masishamo 23 дні тому

    really great dear

  • @raviv5109
    @raviv5109 3 місяці тому

    Thank you so much for sharing!

  • @DhuhaAlshdid
    @DhuhaAlshdid 5 місяців тому +1

    GREAT HELP, THANK YOU

  • @gauravjain1653
    @gauravjain1653 4 місяці тому +1

    Nicely Explained....

  • @peezy739
    @peezy739 Місяць тому

    WOW very helpful

  • @dblo01
    @dblo01 4 місяці тому +2

    I love how the "Most replayed" slider bar looks like a mountain range with the amount of people going back to see how you did stuff.

  • @smckenzie1234
    @smckenzie1234 2 місяці тому

    Thanks!

  • @akingstruth
    @akingstruth 6 місяців тому +2

    I appreciate you for this.

  • @o1techacademy
    @o1techacademy 4 місяці тому

    Now I know what Gantt chart 📉 🎉 Awesome

  • @lovelyespinosa1760
    @lovelyespinosa1760 21 день тому

    Hi! I have a question. What if you have broken start date and end date, meaning you have 2 sets of dates in a single row. Can you make the progressive filled chart that will adapt to the 2 sets of date?

  • @mingsirakowit3316
    @mingsirakowit3316 Місяць тому

    Thank you so much

  • @kaanmai
    @kaanmai 2 місяці тому

    Kenji, How do you add start and end dates to the chart bars? for each project timeline.

  • @Sonicexeclub
    @Sonicexeclub 7 місяців тому +1

    Thank you for this awesome tutorial, I know have a beautiful Gnatt chart thanks to your guidance 😁😁

  • @camlex6310
    @camlex6310 7 місяців тому +1

    Really helpful, thanks!!

  • @Kevin_lhq
    @Kevin_lhq 9 днів тому

    thanks u brother

  • @JoshuaTurnbull-r5s
    @JoshuaTurnbull-r5s 3 місяці тому +1

    Great Video - I am having trouble with one part though. I have 25 weeks in the project, however when my progress is at 100%, it only fills up 18 weeks (and not the full 25). It also allows my progress bar to reach 160%, and only then will all 25 weeks be green. I have set the Progress bar min/max between 0 and 1. What am I missing? How can I extend the green bar to all 25 weeks to signify 100% complete?

    • @JoshuaTurnbull-r5s
      @JoshuaTurnbull-r5s 3 місяці тому

      This might be wrong, but I managed to achieve the result by multiplying my business day column by 10/7 within the conditional formatting formula, to account for the weekends being added

  • @KalAlam-fk8tx
    @KalAlam-fk8tx 5 місяців тому

    Thanks Kenji, Awesome detailed vedio and you do it simply as normal.

  • @TheArcadeGirl
    @TheArcadeGirl 5 місяців тому

    This tutorial taught me a lot. Absolute legend!

  • @alexmaniyacherryjoseph5689
    @alexmaniyacherryjoseph5689 4 місяці тому

    Thanks for the video. How can I remove Saturday and Sunday if I do it on days?

  • @ElectronicBarta
    @ElectronicBarta 2 місяці тому

    very usefull video. thanks for sharing

  • @naylin6451
    @naylin6451 5 місяців тому

    Thanks so much, bro. I moved along with your video and learned new tactics.

  • @vtanz
    @vtanz 6 місяців тому

    Looks good. Suggestion to include business working day Mon to Friday and exclude holidays

  • @TheSmartShoppersGuide
    @TheSmartShoppersGuide 8 місяців тому

    Thanks for your helping me increase my excel skills

    • @KenjiExplains
      @KenjiExplains  8 місяців тому

      that makes me happy to hear thank you!

  • @nochacharles3673
    @nochacharles3673 4 місяці тому +1

    Love it, Thx!

  • @hellojinnyjinny
    @hellojinnyjinny 6 місяців тому +1

    WOW this is great!

  • @sirwilliams2813
    @sirwilliams2813 2 місяці тому

    Very helpful...thanks

  • @jayv6960
    @jayv6960 3 місяці тому

    The video was beneficial and very well put together. However, there is one issue that I found. The colored progress bar doesn't correctly reflect the start and end date. Example: Row 11 start date is 19-Jan-2024, and the color bar is showing it starting from Wk 3 instead of Wk 2. Ideas on how to resolve that would be greatly appreciated.

  • @yoddhasingh31
    @yoddhasingh31 5 місяців тому

    Thanks Kenji , you're a lifesaver

  • @madhulucky225
    @madhulucky225 6 місяців тому +1

    Very simple. Good stuff

  • @longsm28
    @longsm28 3 місяці тому

    Thanks so much for sharing.

  • @Nabd-16
    @Nabd-16 7 місяців тому

    My best wishes for continued success.. Is it possible to pass on the news as I am just beginning?

  • @1986DLee
    @1986DLee 7 місяців тому +1

    I love this thank you so much!!

  • @psharyph
    @psharyph 2 місяці тому

    Thank you🙏