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

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

КОМЕНТАРІ • 299

  • @adelinogoncalves9963
    @adelinogoncalves9963 9 місяців тому +29

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

  • @RubyOliverm5l
    @RubyOliverm5l 20 днів тому +172

    Investments are the roots of financial security; the deeper they grow, the stronger your future will be."

    • @NicholasJames3l
      @NicholasJames3l 20 днів тому

      The deeper your investment roots, the stronger your financial security will be in the future.

    • @JulianBenjamin3d
      @JulianBenjamin3d 20 днів тому

      Exactly! With my adviser, I’ve cultivated deep investment roots, strengthening my financial security for the future.

    • @SofiaJames9H
      @SofiaJames9H 20 днів тому

      I would love an introduction to an adviser who can help me strengthen my financial roots.

    • @JulianBenjamin3d
      @JulianBenjamin3d 20 днів тому

      My CFA NICOLE ANASTASIA PLUMLEE a renowned figure in her line of work. I recommend researching her credentials further.

    • @SofiaJames9H
      @SofiaJames9H 20 днів тому

      Thank you for this amazing tip. I just looked the name up and wrote her.

  • @deansdrone
    @deansdrone 8 місяців тому +28

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

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

      same here :) thanks man!

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

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

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

      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

    • @Marlon-yx1gg
      @Marlon-yx1gg Місяць тому +1

      @@furkanyildirim3644 Thank you, I was pulling my hair out trying to figure out why it wouldn't work for values above 50%.

  • @BrendaDolloff
    @BrendaDolloff 2 місяці тому +8

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

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

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

  • @VishnuVardhan-sj6nd
    @VishnuVardhan-sj6nd 9 місяців тому +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  9 місяців тому +1

      Thank you! Awesome that you figured that out 👍

    • @coachsudhakar
      @coachsudhakar 9 місяців тому

      Excel file link ..pls share

    • @pinko-u6y
      @pinko-u6y 3 місяці тому +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 Місяць тому

      @@coachsudhakar make it yourself friend.

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

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

    • @furkanyildirim3644
      @furkanyildirim3644 3 місяці тому +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 5 місяців тому +20

    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 3 місяці тому

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

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

      In lieu of any better solution (and I'm sure there is one), I just manually decide on start and end dates for those relative tasks

  • @me2507b4u
    @me2507b4u 8 місяців тому +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!

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

    Thanks!

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

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

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

      that's awesome to hear thank you!

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

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

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

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

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

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

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

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

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

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

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

    Thanks

  • @raja.mubbasshir9072
    @raja.mubbasshir9072 6 місяців тому +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

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

      or small sub task just for 1 day

  • @MitchellArgall
    @MitchellArgall 7 місяців тому +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.

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

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

    • @V21IC
      @V21IC 5 місяців тому +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.

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

    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 4 місяці тому

      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... :(

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

      does anyone know the solution?

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

      Check your Conditional Formatting formula as well as the area it Applies to. Mine changed itself and I had to correct it before it worked.

    • @aditighosh4926
      @aditighosh4926 18 днів тому

      Same problem and dont know how to resolve this?

    • @aditighosh4926
      @aditighosh4926 18 днів тому

      Hi I could resolve this using this formula. =AND(I$6>=$D8-(WEEKDAY($D8,2)+1),I$6

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

    This video deserves more likes and more views, awesome content

  • @md.anwarulkabir3020
    @md.anwarulkabir3020 2 місяці тому +1

    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!

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

      I had the same problem, but seemed to have solved it by adding +1 to the day counting formula. So the number of days are correct. Otherwise it seems to now count first or last day. 1 day activities show 0 days etc. So in column for Days I write: =IF(C11="";"";D11-C11+1) So adding the +1 before last ) compared to video.

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

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

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

    can you provide a downloadable link for this Gantt chart ?

  • @rexencatz9075
    @rexencatz9075 9 місяців тому +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..

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

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

  • @jayscore7182
    @jayscore7182 6 місяців тому +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?

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

    Omg, how did you become such a genius at such a young age. Awesome! Thanks!

  • @AAA-kc7he
    @AAA-kc7he 12 днів тому

    A great lesson! Thank you Kenji for the perfect instruction.

  • @toomatawita765
    @toomatawita765 26 днів тому

    Thanks Kenji, I got one now which is very important to track all project activities... Many thanks

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

    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?

  • @udaysinhbhosale788
    @udaysinhbhosale788 9 місяців тому +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 8 місяців тому

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

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

      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

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

    THE BEST SO FAR

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

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

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

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

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

    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 7 місяців тому

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

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

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

  • @dblo01
    @dblo01 6 місяців тому +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.

  • @okasanjaya6587
    @okasanjaya6587 7 місяців тому +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 😇💚

  • @wilfredjones5849
    @wilfredjones5849 6 днів тому

    Thanks Kenji!! This was really educational for me.

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

    Excellent tutorial! The one thing I noticed is that the conditional formatting formula for progress (dark green) doesn't account for the Networkdays formula in the days column. For example, on a 4 week task, when you use networkdays the formula adds 20 days to the start date to measure completion. 20 days is less than 4 weeks so it returns a false value in the last week.

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

    Hi! thank you for this tutorial!!! I have a small question - I would like to use Months instead of Weeks in my planning, but I cant find it. For weeks you need to format Wk #. I tried for months Mo # and Mm #, but it gives me an error. Do you know how can I do it? Thank you in advance

  • @kamaldhamija3288
    @kamaldhamija3288 7 місяців тому +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

  • @themosdiary
    @themosdiary 7 місяців тому +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.

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

    Do you have example for gannt per hour over multiple days

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

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

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

    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.

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

    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?

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

    WOW. solved so many doubts in such a short video

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

    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?

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

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

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

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

  • @Laura-lq9ox
    @Laura-lq9ox 2 місяці тому

    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

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

    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?

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

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

  • @Edgardo-c2g
    @Edgardo-c2g Місяць тому

    Very nice and easy to understand tutorial ever..more power to you Kenji.

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

    Thank you! excellent and easy to follow!

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

    This was so useful Kenji, thank you. I have subscribed.

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

    gonna take me some time to wrap my head around this but I like this approach

  • @MSshorts..-iq7os
    @MSshorts..-iq7os Місяць тому

    Love you sir Your are best teacher in the world❤

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

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

  • @SS-bn8lp
    @SS-bn8lp 7 місяців тому

    I'm having trouble with the If Formula in the Days column. Can you show how to add the IF condition if you're using Networkdays?

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

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

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

    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.

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

    Thank you, Kenji. That was priceless.

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

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

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

    @kenji, Thank you for the wonderful video. I have a question wherein my start date and end date does not have either monday or friday assuming my project starts on monday then the gantt chart does not show bars shown in the right mapped to the week in green color. Please assist. Thank you

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

    THANK YOU FOR THIS, IT WAS VERY HELPFUL

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

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

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

    why does mine not fully coloring in even when it's 100%? ex. end date is June 14, and the light green bar is under Jun 14, only the previous bar is colored in in dark green.

  • @TurtleMingea
    @TurtleMingea 7 місяців тому +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 ,

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

    I am having trouble getting the conditional formatting of the green bar to work when the start and end date is the same day since a task is completed in one day? Any thoughts?

  • @billpet4602
    @billpet4602 18 днів тому

    Excellent tutorial!!

  • @BetaniaMengistie
    @BetaniaMengistie 9 місяців тому +1

    I'm trying to do the same as you but number months! instead of weeks. what do i put in the format cells - custom ???I tried mm instead of wk # but that just gives the month not the number of months???? HELLPPPPPPPPPPPPPPPPP. Thanks for this tutorial super helpful for a task i got at work related to PM :)

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

      Set the interval to +30 instead of +7.
      And change WK# to Mnth #

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

    Great guide and great styling suggestions! This made tackling a new project super easy and relieved a lot of stress! Thank you very much :)

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

    Hi
    Trying out your vids for the first time. Getting stuck with date calculations etc. The word value keeps coming up after formula. Can you help?

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

      Anyone with an answer, my date calculations keeps coming up as VALUE!

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

    Thank you! This video was very helpful and informative

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

    Hi thanks for the video, works well overall.
    Still have some problem the %completion is not working fine with small tasks( day task) hoe can I fix that

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

    Simply the best🙌🏾

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

    Hi, can someone please explain to me how we got the percentage column to oscillate based on the percentage? In the video it's cut and i didn't get that. 🙏

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

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

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

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

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

    Thank you for such a brilliant and detailed explaination!

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

    hi Kenji, Don't you sell this spreadsheet? I would love to learn how to do it but unfortunately I don't have time.

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

    8:32 the equation AND is not working for me, did exact same formula,=AND(G$2>=$C5,G$2

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

    Very very helpful Kenji!!!!

  • @amjad4126
    @amjad4126 10 днів тому

    Great video! Thanks!

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

    sir, how progress of 50% etc was filled?? how to calculate progress at 2:57 ??

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

    How do you add the IF formula to the NETWORK formula together?

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

    Hi sir, Just want to know what if the task time is less then a week like 1 or 2 days?

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

      I FOUND THE SOLUTION!!!! YOU SHOULD USE THIS FORMULA --> =AND(H$7>=$C10-(WEEKDAY($C10;2)+1);H$7=$C10;H$7

  • @MdAsif-km9sx
    @MdAsif-km9sx 3 місяці тому +2

    Is there a downloadable link ??

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

    Awesome! Thanks from Bangladesh.

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

    how do i autofill the wk with the numbers, i do not have a pound sign on my PC, I'M NOT getting that part

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

    Hi Kenji, This is great, but it was working well only for a short time after few days when multiple people edited the sheet the progress 100% does not fill all green but only the no. of working days, for example if the progress is 100% for 5 days of work it is filling only 3 days with green as there are only 3 working days, how to fix that?

    • @Angie-rc9zp
      @Angie-rc9zp 3 місяці тому

      I’m having the same issue 😢

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

    Great video!!!

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

    I think you would another columns Proposed Start date/End Date and Actual Start date/End and then do these formulas and conditional formatting again. I am really not sure what would that be I think something along the line wherein it doesn't change colors if Both dates are same but show different color if it is different

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

    This tutorial taught me a lot. Absolute legend!

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

    You are GREAT! Thank you!

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

    I run into an issue where i want to use the netwokdays() function tin order to not count the weekends but the right side schedule does (project start date +7, +7, +7, etc). So eventually depending on yhe number of weeks the task is i will begin to lose the conditional formatted cells representing my percentage complete

  • @erkatw
    @erkatw 20 днів тому

    I have followed your video to do the grantt chat for the progress bar to indicate diff colour for the completion. However, if I use networkdays ( my formula is : =AND(I$7>=$D9,I$7