Make This Awesome Gantt Chart in Excel (for Project Management)
Вставка
- Опубліковано 31 тра 2024
- Make Gantt Chart in Excel for Project Management.
🚀 Take our Excel course here: www.careerprinciples.com/cour...
In this video we'll create this awesome Gantt Chart in Excel in 4 simple steps. It's fully dynamic, so you can change the project start date and the whole chart timeline changes, you can track the progress of your tasks on a percentage basis, and even add new activities as you see fit.
As we start from scratch, first we'll add all the values and format the chart. Second, we'll create a dynamic date timeline in weeks. Third, we'll create conditional formatting formulas to make the Gantt Chart dynamic. Finally, we'll freeze panes and add more conditional formatting to track the current week.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:30 - 1. Chart Formatting
4:17 - 2. Dynamic Date Values
7:27 - 3. Dynamic Fill Values
15:18 - 4. Final Edits (view & date tracker)
Thanks.Great job. I completed the Gantt chart and am very excited to implement it. You are excellent, sir
The most intelligible Gantt Chart tutorial I´ve seen by far, thanks a lot Kenji, great job!
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!
This the 1/3 excel gantt chart video I seen and tested that actually works. Great work keep it up.
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.
Always thankful for your videos.
Great guide and great styling suggestions! This made tackling a new project super easy and relieved a lot of stress! Thank you very much :)
Thank you so much really fun learning this. In the formula =EN(H$7>=$C10;H$7
same here :) thanks man!
Thank you, Kenji, I wish I had found your channel sooner.
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.
It was a breakthrough for me,
So easy way to understand and creating a gantt chart. Thank you.
That's awesome to hear thank you for your comment :)
THE BEST SO FAR
Thanks Kenji , you're a lifesaver
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 😇💚
This tutorial taught me a lot. Absolute legend!
Thank you for clearly tutorial. I love it.
Thank you for this awesome tutorial, I know have a beautiful Gnatt chart thanks to your guidance 😁😁
great video, thank you. i also had some issues using network days. is there a solution? can you create predecessors or dependants?
@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
Awesome! Thanks from Bangladesh.
A great explanation! Good work and thank you for sharing.
I love this thank you so much!!
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..
Thanks so much, bro. I moved along with your video and learned new tactics.
Hi the progress bar and timeline doesnt coordinates when you use network days, can you please tell how to fix it?
This video deserves more likes and more views, awesome content
Really helpful, thanks!!
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
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?
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
Thanks Kenji, Awesome detailed vedio and you do it simply as normal.
Great video, Awesome job!
again, I find my interest to learn excel, after listening you. thank you
that's awesome to hear thank you!
Thanks for your helping me increase my excel skills
that makes me happy to hear thank you!
Thank you so much for that insightful easy to follow tutorial.
Thank you for watching :)
Thank you for the great explanation; If the number of days is
Very simple. Good stuff
I appreciate you for this.
Very nice and neat. For it to be even better, add values and summary for each task so we can se the curve for manpower over time. Can you do that ?
Thanks alot Sir
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
GREAT HELP, THANK YOU
Looks good. Suggestion to include business working day Mon to Friday and exclude holidays
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 :)
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.
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!
Actually, removing the -1 is what causes the two green bars but the rest show no progress
My best wishes for continued success.. Is it possible to pass on the news as I am just beginning?
Much helpful, thanks
Glad it was helpful!
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?
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.
Thank you! Awesome that you figured that out 👍
Excel file link ..pls share
WOW this is great!
For the formula of percentage, why cant be like yours if %progress was 100%. i was tried same formula as yours. Thanks
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 ,
The fill didn't work for me. I'm not sure what I missed. I've tried multiple times. Can anyone offer any suggestions on what I could be missing? Thank you.
Hi Kenji. I did try out your step. I'm having problem with the step for dynamic fill value for actual progress. May I know how i can contact you get some support?
Very Good video. Really good. Congratulations
very useful video
please make a video , for example, task3 start date after task2 completed.
Hi sir, Just want to know what if the task time is less then a week like 1 or 2 days?
amazing
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
=AND(H$7 >= $C10, H$7
If I selected start date I'm getting + symbol along this wat can I do for this
I love this
thanks for watching :)
New fans🇸🇴
Is there anyway to add the task name to the gannt bars?
Dear i likes your teaching methods. Yours polites limping is very helpful to understand. ❤ can you work with biostatistics data analysis? please make some videos for biostatistics data thanks alot from Pakistan
thank you Sir for asking him this. I appreciate you appreciate him Sir. Respect from India
plz also provide with the data sheet so we can practice
how about if i use the networkday the chart wont close when 100%
I followed this but only the first two rows are working for the second rule for the darker colour.
How can i make the progress bar for each day
I can't see why but the darker colour on each task doesn't work for every task. It shows the progress for the first two. I can't figure out what went wrong. Otherwise it's the best video I have found. I missed something along the way though.
Can you also do best power point tips for work / consulting?
I'll keep it noted thanks for the suggestion!
hello, can you share the template?
how to make horizontal chart, not stairs like?
great one Kenji. Can you upload the sample file for me to play with it?
Hey I made the video so you can learn to make it yourself!
@@KenjiExplains you taught the man how to fish, but he still wants you to hand him the fish lol
cost breakdown for agriculture farming
How can we download the file pls??
This does not take care of task dependency. Anyway, it is a good teaching video to solve simple checklist scheduling, use MS Project and other third party cloud tool is a better fit
How do u delete the true and false? need help
The problem with this chart is that if the project start date is a Tuesday, then each following week starts on a Tuesday
you are ❤
thank you!
is there a default gantt chart in excel?
It's not by default but you can use conditional formatting like this video or a staceked bar chart and customize it
How to auto fill persentage?
Ive learnt so much from Kenji, he's transformed my excel skills....but this one didn't work for me. Very frustrating.
👏👏
Aowsom 🎉
it wont let me continue, tets a problem with this formula,
yup, there really is a problem with this and I have identified it. The formula is ...(drum rolls) ... MISSING
1st
lets go!
your voice is too weak.
Awesome and easy to grasp tutorial.
Thanks