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

[@adelinogoncalves9963]

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

[@RubyOliverm5l]

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

[@NicholasJames3l]

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

[@JulianBenjamin3d]

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

[@SofiaJames9H]

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

[@JulianBenjamin3d]

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

[@SofiaJames9H]

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

[@Consultelainewilliams]

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

[@birlamour]

Thanks!

[@thanh-tunglai8778]

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

[@tahirif1138]

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

[@pushparajput5209]

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

[@KenjiExplains]

that's awesome to hear thank you!

[@deansdrone]

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

[@ondrop]

same here :) thanks man!

[@annablarin6092]

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

[@Marlon-yx1gg]

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

[@kutub52]

This video deserves more likes and more views, awesome content

[@araze3195]

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

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

[@mr.alsifat1504]

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

[@KenjiExplains]

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

[@MitchellArgall]

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.

[@HotButteredCorn]

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]

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

[@davidcollins6976]

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

[@JewelKenyah-Damptey]

Your presentation is on a next level. Thank you.

[@kayumanis1313]

Thanks

[@jnerikaat]

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

[@kabeerjijel4688]

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

[@me2507b4u]

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!

[@danguardo9501]

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

[@RCSMgmt]

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

[@wellsinsurance]

Incredible! THANK YOU! Clear - to the point, practical and it works!

[@najimfahym2935]

Канал вдохновляет на новые достижения, спасибо!

[@chrisbillingtonhughes78]

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

[@lapen67]

This was an amazingly helpful video. Thank you so much!

[@AAA-kc7he]

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

[@PeterSimons-d5h]

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

[@Calebisaturtle]

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

[@toomatawita765]

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

[@raja.mubbasshir9072]

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]

or small sub task just for 1 day

[@Edgardo-c2g]

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

[@okasanjaya6587]

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]

Thanks Kenji!! This was really educational for me.

[@packard37]

WOW. solved so many doubts in such a short video

[@r1cer825]

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

[@rexencatz9075]

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

[@ijeunachukwu8925]

THE BEST SO FAR

[@dblo01]

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.

[@KevinOKeefe-qw8cl]

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

[@VishnuVardhan-sj6nd]

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]

Thank you! Awesome that you figured that out 👍

[@coachsudhakar]

Excel file link ..pls share

[@pinko-u6y]

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]

@@coachsudhakar make it yourself friend.

[@SandeepSingh-o6t1m]

One of the best described video! Thanks.

[@daisysarming3546]

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

[@KenjiExplains]

Thank you for watching :)

[@durga8285]

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

[@BrendaDolloff]

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

[@amirafatin3879]

yea i wanted to know too

[@themosdiary]

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.

[@BKZ897]

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

[@timbo4519]

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

[@sapaktam2550]

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]

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]

does anyone know the solution?

[@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]

Same problem and dont know how to resolve this?

[@aditighosh4926]

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

[@suhass7164]

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

[@MSshorts..-iq7os]

Love you sir Your are best teacher in the world❤

[@CreekMythology]

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?

[@lpaone01]

Thank you, Kenji. That was priceless.

[@mohamedamro]

Awesome and easy to grasp tutorial. Thanks

[@RoxanneWilliamson-ez8zb]

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

[@elbansidmhamed1493]

YOU ARE GREAAT !!!! TAHNK YOU...very simple and verry informative

[@md.anwarulkabir3020]

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]

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.

[@kamaldhamija3288]

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

[@traceymorris1871]

thank you for this, most informative

[@udaysinhbhosale788]

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]

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

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

[@MurtazaMahmud]

Thanks for this simple explanation. @12:41 I am not getting the same results when applying the formula. Any idea?

[@arpanatikekar8699]

Thank you for such a brilliant and detailed explaination!

[@wendeesexton3607]

Do you have example for gannt per hour over multiple days

[@KellyHanke]

Thank you! excellent and easy to follow!

[@kinesiology-moves9598]

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?

[@AmaraGreyRC]

Very very helpful Kenji!!!!

[@alenatereshchenko679]

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

[@bogadjatikusumah1161]

good gantt chart Kenji... 👏👏👏

[@soalafredericks1570]

THANK YOU FOR THIS, IT WAS VERY HELPFUL

[@bamnisah]

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

[@PavankumarHarapanhalli]

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

[@V21IC]

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.

[@agnecedergren8982]

what about linked tasks. eg before you can paint the floor, it has to been laid and the concrete needs to be dried. how do you get this feature?

[@ayushikar25]

Thank you! This video was very helpful and informative

[@hasanmohammadtareq89]

Awesome! Thanks from Bangladesh.

[@kaanmai]

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

[@Angelo_2424]

Hey Kenji - can you please create a weekend wise start and end employee count ?

[@TheArcadeGirl]

This tutorial taught me a lot. Absolute legend!

[@connectingmodi1328]

@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

[@KunalJhavar]

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.

[@billpet4602]

Excellent tutorial!!

[@KalAlam-fk8tx]

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

[@chukwudichukwuma3309]

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

[@DesarrollosyContenidos]

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

A great explanation! Good work and thank you for sharing.

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

[@Laura-lq9ox]

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

[@IleneKlement]

For the % completed dark green bar, I can't get it to show correctly since I used the the formula for days as =networkdays(C10,D10). I used your formula of =AND(H$7>=$C10,H$7

[@rClyzCTcWz]

same issue

[@KevinDeAnda-vw7ww]

Great video, Awesome job!

[@hdezian]

i'm wondering if there is a way to automate shifting the dates? for example lets say the project start date is in january, and we have all the dates mapped out to january, but the project gets delayed. now it starts in march, but the timeline ive already created with the data is set to march. instead of updating all the dates 1 by 1, is there a way to automate this? currently when i update the start date, it just moves all the tasks which were slated in march to be first, but doesnt account for the projects that were in jan-march because the dates are in the past.. does that make sense? thanks, from a total excel non user! i have something functional here! just wondering what the possibilities are!

[@stellastelione8988]

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

[@Cuzco08]

I cant copy and paste the formula to the conditional formatting without ruining the formula. How are you able to copy the formula and drag it across the other cells while keeping the formula intact? @13:59 mark

[@jayv6960]

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.

[@ennurbardakc6966]

does anyone know ?

[@aditighosh4926]

Agree

[@amjad4126]

Great video! Thanks!

[@RahilShaikh-c5k]

hello, can we make this in google sheet also ??

[@M1800dk]

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 👍

[@kimennis5754]

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?

[@alexmaniyacherryjoseph5689]

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

[@khwaab4284]

Brilliant. Loved it

[@yoddhasingh31]

Thanks Kenji , you're a lifesaver

[@jesseegitaine4219]

You are GREAT! Thank you!

[@awesomethings3489]

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

[@ennurbardakc6966]

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

[@lovelyespinosa1760]

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?