Make This Awesome Gantt Chart in Excel (for Project Management)
HTML-код
- Опубликовано: 22 май 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)
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.
This tutorial taught me a lot. Absolute legend!
Thanks Kenji, Awesome detailed vedio and you do it simply as normal.
The most intelligible Gantt Chart tutorial I´ve seen by far, thanks a lot Kenji, great job!
This video deserves more likes and more views, awesome content
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.
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 😇💚
GREAT HELP, THANK YOU
Thank you so much really fun learning this. In the formula =EN(H$7>=$C10;H$7
same here :) thanks man!
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 :)
THE BEST SO FAR
Thank you, Kenji, I wish I had found your channel sooner.
A great explanation! Good work and thank you for sharing.
Thank you for clearly tutorial. I love it.
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 :)
I love this thank you so much!!
Really helpful, thanks!!
Awesome! Thanks from Bangladesh.
Thank you for this awesome tutorial, I know have a beautiful Gnatt chart thanks to your guidance 😁😁
Hi the progress bar and timeline doesnt coordinates when you use network days, can you please tell how to fix it?
Very Good video. Really good. Congratulations
Thank you so much for that insightful easy to follow tutorial.
Thank you for watching :)
Very simple. Good stuff
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
I appreciate you for this.
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
great video, thank you. i also had some issues using network days. is there a solution? can you create predecessors or dependants?
WOW this is great!
Thanks alot Sir
again, I find my interest to learn excel, after listening you. thank you
that's awesome to hear thank you!
Much helpful, thanks
Glad it was helpful!
Thanks for your helping me increase my excel skills
that makes me happy to hear thank you!
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..
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?
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?
very useful video
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 ?
I love this
thanks for watching :)
My best wishes for continued success.. Is it possible to pass on the news as I am just beginning?
amazing
New fans🇸🇴
Thank you for the great explanation; If the number of days is
Looks good. Suggestion to include business working day Mon to Friday and exclude holidays
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
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.
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 :)
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?
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.
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 ,
please make a video , for example, task3 start date after task2 completed.
Is there anyway to add the task name to the gannt bars?
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
plz also provide with the data sheet so we can practice
If I selected start date I'm getting + symbol along this wat can I do for this
Hi sir, Just want to know what if the task time is less then a week like 1 or 2 days?
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.
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
How can i make the progress bar for each day
Awesome and easy to grasp tutorial.
Thanks
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?
I followed this but only the first two rows are working for the second rule for the darker colour.
how about if i use the networkday the chart wont close when 100%
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
you are ❤
thank you!
How can we download the file pls??
The problem with this chart is that if the project start date is a Tuesday, then each following week starts on a Tuesday
how to make horizontal chart, not stairs like?
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
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
Aowsom 🎉
How do u delete the true and false? need help
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.
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.