How to Make a Gantt Chart in Excel
HTML-код
- Опубликовано: 15 июл 2024
- Learn how to Make a Gantt Chart in Excel, including features like a scrolling timeline and the ability to show the progress of each task. Watch as I create the Simple Gantt Chart template from scratch, or download the template: www.vertex42.com/ExcelTemplat...
👍 Remember to Subscribe and Turn on Notifications (click on the bell)
THIS VIDEO:
0:20 Step 1 - Start with a List of Tasks and Dates
0:44 Step 2 - Set up the Timeline Labels
2:20 Step 3 - Add Initial Formatting to Style the Gantt Chart
4:05 Step 4 - Add the Bars of the Gantt Chart via Conditional Formatting
5:10 Step 5 - Make the Timeline more Dynamic
6:28 Step 6 - Add a Scroll Bar Form Control
7:20 Step 7 - Highlight Today's Date using Conditional Formatting
7:51 Step 8 - Add Columns for 'Assigned To' and Progress (% Complete)
9:07 Step 9 - Show Progress in the Gantt Chart by Shading a Portion of the Bars
11:31 Step 10 - Define Print Settings
OTHER VIDEOS IN THIS SERIES:
Check out the next videos to see how to work with workdays and weekends, how to change the display to weekly or monthly, and how to add dynamic color-coding:
www.vertex42.com/ExcelTips/ho...
GANTT CHART TEMPLATE PRO:
A Gantt Chart is an extremely useful tool for project management. You can create a very simple project plan like the one in this tutorial, but if you are a project manager and want more features such as changing the view between daily/weekly/monthly, entering the duration of a task in work days, or color-coding the bars of the chart, download Gantt Chart Template Pro:
www.vertex42.com/ExcelTemplat...
GANTT CHART TEMPLATE
My original free Gantt chart template for Excel (and Google Sheets) can be found here:
www.vertex42.com/ExcelTemplat...
ANOTHER GREAT TUTORIAL
Check out the following channel for another detailed tutorial showing how to add advanced features to a Gantt Chart in Excel:
• How to create Ultimate...
FOLLOW VERTEX42 HERE:
Instagram: / vertex42
Facebook: / vertex42
Pinterest: / vertex42
Twitter: / vertex42
MUSIC: A Good Mood, by Young Rich Pixies, licensed via ArtList
NOTE: This video is for educational use and for use in making a Gantt chart for your own projects. Reproducing or copying this video in part or in whole for commercial gain (including advertising or making products for sale) is not permitted.
![NoCap - Yacht Party [Official Music Video]](http://i.ytimg.com/vi/rm_lvDln8kE/mqdefault.jpg)
I've considered myself above average at Excel for some time. after watching this 1st video of the series, I put myself a lot floors down. What a great class. Thanks.
Dude, I know! This guy humbled me greatly.
Exactly same , in my case also. 🤩
I have the same thing :)
I too had the same feeling. This is why they say, be humble because everything you think that you understood is just a misunderstanding. There is a long way to go.
This video is mesmerizing. Hats off and great to know the possibilities of Excel, as common people like me are just scratching the surface since quite sometime.
@@BalakrishnanNair68 well put
Hi there, this is the most phenomenal video on the Internet for making a gantt chart, no bs, straight to the point. Legend.
True!!!!
Amazing
@Ot Chuckm This was great, thanks, I have been researching "how do you write current status of a project?" for a while now, and I think this has helped. Ever heard of - Peyictorier Imaginative Preeminence - (Have a quick look on google cant remember the place now ) ? It is an awesome one of a kind product for getting useful project management and business templates minus the headache. Ive heard some unbelievable things about it and my partner got cool results with it.
totally right!!!! amazing video, straight to the point! great!
totally agree!!
My eyes have never seen such a profound execution of elegance and swagger...... and yes I know I'm talking about an Excel tutorial...and yes I am closing my laptop for the night to reevaluate my existence
how do you link the date to the project start?
@@LimeTJL do you find it
I doubt you will see this, but I'm leading a very large project and I will using this and I just have to say. Thank you so much. I wish you all the success. Great narration, great to the point, not in your face. Please never change.
this is a hell of a skill. just realise that i don't even imagine how powerful excell is
Hands down one of the best excel training videos I have seen! Clear, concise, articulate, practical with some great features! Well done! Thank you! An absolute pleasure to watch!
I truly admire your work, that's by far one of the most helpful videos on RUclips, I enjoyed each and every second of this redo, you've added a lot to my knowledge, people like you worth appreciation and I give it all to you man.
This is truly one of THE most amazing and informative tutorial videos I have ever seen in my entire life!! You have saved me so much time and energy and allowed me to accomplish things that would have taken years of trial and error. Thank you!!
Lost confidence on my excel knowledge. Hats off
ahahaha the same dude!
Your comment made my day 🤣
I considered myself an above-average Excel user, but boy, was I humbled.
Thank you so much for sharing this!
Excellent!
I can only repeat was others have said: this is the most straight to the point, no BS tutorial I have ever seen on YT. Thank you! Great work.
This video is an absolute gem! The instructions are concise and easy to follow. Thank you so much.
I liked how you showed each step in details, even the keyboard shortcuts. Learnt a lot of new things from this.
Great explanation and to the point! I love when people just tell you exactly how to do something and if I am unclear on a step i can always just look up that step myself or refer to another video. Not bogged down by explaining every little detail in a 2 hour video. Thank you, great job!
EXCELLENT! I am a below average Excel user and was blown away with this example of Gantt chart creation. A bit fast for me, but the cc and additional pop up controls helped. Would absolutely recommend
Videos like this, though few, are what make my youtube addiction worthwhile. Super clear presentation, perfect pace, great basic practices (e.g. using names) and a polished result. Thanks!
This is exactly what I've been looking for :D Thank you so much
Very well explained :) cleared so many doubts and got to learn a new thought process. Small things but makes your presentation look perfect. Never even thought about the date shift logic, have been changing this manually all the time. Great tutorial!
I use spreadsheets daily at work, but I still managed to learn quite a lot in this 12 min video. Truly masterclass - thank you!
This was so well done. I haven’t had a chance to explore naming or scroll bars yet so i learned a lot. Thanks.
This class has been an absolute game-changer! So many lessons packed with eye-opening insights. Huge thanks to the instructor for sharing such valuable knowledge! Can't wait to apply these lessons in real life.
I'm far from an Excel expert. This was outstanding content. Simple. Straight-forward. Less than an hour to create. A HUGE time saver for my business. Many thanks!
One of the most concise and clear Excel vids I've watched; I have been looking for a way to incorporate progress within the Gantt chart in Excel; lost a tad on the formula, but got it to work! Cheers to you!
I just learned a ton, a metric ton. Your 12 min video has at least an hour of lessons in it for the average Excel user, and probably a week for a complete beginner. Thank you for putting this together and helping all of us "professionals " out. I will definitely be saving this as a template for future projects.
Thank you!
Wow! I could understand each step, as it was clear what you were doing, but I would never have thought to put these elements together in the professional and amazing way that you did. Awesome job, and just a superb video. I can't wait to see the next one.
Your explanation calls for respect, very precise and to the point. Was very useful. For sure will be subscribing for more models like this. Thanks mate.
I love the ebb and flow of the video. It is not drawn out. I've learned a lot in a short time. I love the way you explain why you are using a particular function and that you incorporate short cuts. I didn't feel you were talking above my head. A lot of your tips are useful for my other projects. Just a great video! Thank you.
Thanks for the feedback.
THANK YOU! Everyone said it... One of the direct-to-the-point tutorials I have ever watched! Please continue to make more videos like this with topic: Macros, Visual Basics and Dash boardings. Looking forward to them already. God bless you!
This is the level of an Excel expert I aspire to be
This is absolutely the definitive tutorial to learn to do a chart-diagramm! Best way to endure the quarantene. All the best from Italy!
This tutorial about gantt chart is by far the best that I've watched!!! Keep it up! it's very easy to follow 😉
This was one of many attempts for me to follow along to a video and produce the same exact product. This is also the only time is has actually worked out for me, 100%, on the first try. Hats off to you for being an excellent instructor. Thank you!
Wow, I’m a PMP and I have to say this is world class skills on display for all to benefit from. Thank you!
This is the level of brevity which is needed in every tutorial. It should be a benchmark for making "How to" videos. Verry educative video.
This is a wonderful tutorial. Thank you so much for saving my day!!!
Wow! Honestly enjoyed every minute of this video and learned so much! Thank you for being so straight to the point and amazing - truly the BEST tutorial video I've seen!!
most simple and most effective video, not only about gantt charts as we use Primavera or Ms Project normally in projects but it was amazing for the conditional formatting perspective.
From the start to the end, I learned a lot functionality. Thanks 🙏.
Words cannot describe how happy I'm feeling after finding your video. You Sir take a bow.
Thank you!!
Just made all the Gannt chart templates (2) I am going to need in this life from this one video. Thank you Mr. Wizard
Best tutorial I have seen. Incredible how much content you just squeezed into such a small timeframe. Charts this complex using come with a 2hr video 🤝
Thank you so much, this has really helped me.
I have discovered the true Excel Jedi Master. Thank you!
As everyone else has said, not only is the explanation fantastic but the template is brilliant. So smart and easy to use. Many thanks for this! Definitely going to pass on the word to my seniors to consider the pro version of the template :)
I've watched many videos about different things but this has got to be the easiest and clear-cut process to follow. Even someone who barely has 0 knowledge in excel can follow this
This helped me tremendously. Can't thank you enough!
6
Best one I’ve seen in Excel. Plus I’ve seen how to use conditional formatting much more effectively. I’ll have to watch slowly and follow along in my own sheet. Thanks!!!
Thanks! For more ideas on how to use conditional formatting, you can take a look at this article: www.vertex42.com/blog/excel-tips/how-to-use-conditional-formatting-in-excel.html
Fantastic video. Really.
This could take several hours to explain to beginners what to do, step by step, and explaining why. But this is perfect for those who only need to get it done and knows the basics.
Even as an advanced user, I learned new things like "relative cell names", clever solution, and easy to replicate.
Thank you so much for the template! I had no idea how to do this. I'm an EE major and I needed one for senior design class. You saved me a lot of precious time & headaches!
So many little things in this video that improve appearance, make it user friendlier or just save time in engineering the chart.
Thank you very much :)
Watched it step by step, absolutely genius. Worked like a charm for my assignment. Putting his name as a stakeholder in my report, he deserves a mention for delivering such high-quality work :D
hahaha true
This was such a clear an concise explanation and a far better result than I had hoped for. Thank you.
The fact that you even divided into section make it even more clearer to learn...OMGGG Thank you so much it helps me a lot
The best demonstration I've seen, thank you.
Fantastic! Impressed with "just to the point" content and focus on aesthetics
I can't thank you enough for this video. Extremely helpful and comprehensive.
Really amazingly explained lesson. These are the channels that every body should take advantage of! Thank you so much teacher.
The most productive and concise RUclips I've ever watched. I followed the project through from beginning to end and produced the Gantt chart that I needed in my current work. It took me two hours of carefully following every step, but the results speak for themselves.
My exact sentiments. This was very helpful and I have a beautiful chart now.
Excellent Video clip! Apologies for the intrusion, I am interested in your opinion. Have you ever tried - Teannah Psychic Sucker (search on google)? It is a good exclusive guide for finding the best project management and business templates minus the normal expense. Ive heard some interesting things about it and my cousin after many years got great success with it.
can u please share with me on mail id (ganjoo.vipin@gmai.com)
Well this knocked me down a peg or twelve, and somehow that's a compliment. Excellent video.
This is an exceptional tutorial. It took me one hour and thirty minutes to create the spreadsheet. Hats off to you!
Your tutorials are very informative and instructions are very clear and easy to follow through. Greatly appreciated.
I used to think i am good at excel. Oh boy! This video made me humble. This is gem.
Same here. OMG 😮
WOW! That was amazing. Thank you. I clearly need to up my game in Excel.
My dude. Thanks ever so much! You just saved my an unnecessary software subscription. Thank you!!!
Same as the commentator Bruno, I also considered myself above average at Excel for quite some time, now you've given me a new bone to chew on :D Thank you very much sir
That really is an amazing tutorial. I’ll be putting it together tomorrow for a project I’m working on
I'm currently managing a substantial project and was looking for a simple and effective GANTT template, your guide just gave everything I needed! I simply must convey my heartfelt appreciation. Thank you tremendously! May abundant success come your way.
You are an artist.
High quality content in a precise video without wasting a second. Full of details from start to end. Classy and excellent work. Thank you for sharing and enhancing our knowledge. Kudos and keep it up!
Learnt a "few new things"? More like I learnt a lot, as if I have never used Excel. Thank you for this video. Instructions are clear and easy to follow :)
I Thought I knew a thing or two about excel but watching this video is like to be sitting at a Formula 1 race watching the cars at 200 mph!! Great information! Keep up this wondeful work!!
Each second,a new concept is brought,now understood the scope and power of excel,Wow man one hell of a video
Excellent tutorial. I'm so pleased I managed to follow this all the way with only a few hiccups due to being unable to see some of the syntax clearly on my screen.
I had never built anything from the ground floor and this made the whole process easy step by step even with modifications I needed. I am truly appreciative of the help this was!
I learned SO much in this 12+ minute video! It was packed full of awesomeness. So informative and easy to follow. We bought your Pro Gantt Chart and it has been really beneficial to our business. Thanks!!
Wow; blown away. Starting using your template and wanted to understand how you built it. This takes Excel to another level!
Finally found a channel that teaches and not sells you a "membership", thank you!
Semper Fi
I can't thank you enough. You are a life saver!
Hi there, I was too amazed by how straight to the point this video was, I am inspired.
This was incredible. Thank you very much. I did my first Gantt graphic with your help!
honestly, forget being the best video on gantt charts
*this is best video on excel, ever*
Thank you! :-)
I have a certificate of specialization in Microsoft Office and I feel like I should rip it up now. Great video!
This video is perfect in terms of pace and explaining minute details in a most befitting manners. I have learnt through very quickly and substantially.
Thanks M/s Vertex 42 for disseminating knowledge efficiently.
I've seen a few of these, as I'm trying to learn how to do this. Yours just explains it in the best, simplest way (for me). It's a grateful "like" from me.
Not gonna lie I can’t keep up with this but i am absolutely amazed
same here...hit pause every 10 sec at my end :)
Any one else with goosebumps -- Skill of the guy and Power of the Excel
how do you link the date to the project start?
I've been using Excel since 1995, but this class is great! Thank you!
You're a lifesaver! Now im stuck to insert delays work on this magic sheets. Oh my oh myy. You're genius!
Phew, 6 hours later and I am an expert at Excel. Thank you
Thank you for teaching me skills WHILE I learned how to do this.
It's like watching Bob Ross paint. Great techniques explained well. The pause button will be needed as I study this closely. TY for sharing.
I've always thought that im pretty good in excel. financial modeling, crystal ball, simulation. never thought I would feel like a beginner ! good job
Great instruction!! Very clear and straight to the point!
Two quick questions,
1. How do you add the Week # above the dates?
2. How do you add columns (for additional weeks)?
Beauty. Didn’t know excel can be used this way too.
Loved the flow process from the tutor
best Gantt chart ever! Top-notch tutorial too! I am just a little bit lost in the last part before the print setup. Still, the best!
Had someone else make the gantt chart for a group project last year, I did NOT realise how difficult this could be. I've just spent 2 hours creating a rudimentary one thanks to you and I really appreciate what your doing here.
Wow I'm amazed that this content is even free. This is the best tutorial on Gantt chart ever. Thank you so much!
I cannot thank you enough for creating such an amazing and insightful video! Clean, concise and so easy to follow. Thank you so much!
my excel knowledge, from previous 70%, after seeing this vedio become 0.1%
I was thinking that I have been being an experienced excel guy until I watch this great video! Cheers from Thailand