How to Make a Gantt Chart in Excel

Подписаться 87 тыс.

Просмотров 3,6 млн

50% 1

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.

Опубликовано:

1 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 2,3 тыс.

@brunesi 4 года назад

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.

@jgonsuron 4 года назад

Dude, I know! This guy humbled me greatly.

@israrmarwat8294 4 года назад

Exactly same , in my case also. 🤩

@mbtijanii6305 4 года назад

I have the same thing :)

@BalakrishnanNair68 4 года назад

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.

@brunesi 4 года назад

@@BalakrishnanNair68 well put

@otchuckrn3906 4 года назад

Hi there, this is the most phenomenal video on the Internet for making a gantt chart, no bs, straight to the point. Legend.

@abdulrahim3985 4 года назад

True!!!!

@Brandon-mn5wi 4 года назад

Amazing

@nadiapacxi2612 3 года назад

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

@maurobsn1873 3 года назад

totally right!!!! amazing video, straight to the point! great!

@1iquidb1ue 3 года назад

totally agree!!

@MA-xx3pq 3 года назад

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

@Emil-tx1fw 3 года назад

how do you link the date to the project start?

@badkarma6866 Год назад

@@Emil-tx1fw do you find it

@MattDoesGamess 3 года назад

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.

@1991aaqib 4 года назад

Lost confidence on my excel knowledge. Hats off

@weetv69 4 года назад

ahahaha the same dude!

@khotsiidominic2045 Месяц назад

Your comment made my day 🤣

@migelmamyrbayev6861 4 года назад

this is a hell of a skill. just realise that i don't even imagine how powerful excell is

@jamalel-masri5420 3 года назад

I truly admire your work, that's by far one of the most helpful videos on RU-vid, 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.

@SolAceTheArtist 3 года назад

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

@aninavanniekerk2212 4 года назад

I considered myself an above-average Excel user, but boy, was I humbled. Thank you so much for sharing this! Excellent!

@MridulMaskara 4 года назад

I liked how you showed each step in details, even the keyboard shortcuts. Learnt a lot of new things from this.

@maxg4958 3 года назад

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.

@olubunmio3386 2 года назад

This video is an absolute gem! The instructions are concise and easy to follow. Thank you so much.

@chrislaurent4311 4 года назад

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!

@1aZoOs 4 года назад

Words cannot describe how happy I'm feeling after finding your video. You Sir take a bow.

@vertex42 4 года назад

Thank you!!

@kenhamroaladdin9212 3 месяца назад

Thank you, really fantastic. And you shared it, very generous of you.

@jimblankenship9564 3 месяца назад

Wow, thank you presenting in the best way i have ever seen. You are awsome.

@narendersinghrana7754 4 года назад

I used to think i am good at excel. Oh boy! This video made me humble. This is gem.

@ibrahimbalo6781 3 года назад

Same here. OMG 😮

@khouseright517 3 года назад

This is the level of an Excel expert I aspire to be

@phatsedge 3 месяца назад

Just made all the Gannt chart templates (2) I am going to need in this life from this one video. Thank you Mr. Wizard

@juancasanova3026 2 года назад

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

@laurenwilliams5059 4 года назад

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!

@TheTrivian 4 года назад

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.

@mooripo 2 года назад

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

@mdzeeshansiddique8185 3 года назад

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.

@DoorHangerH1 4 года назад

I have discovered the true Excel Jedi Master. Thank you!

@iamse7en222 4 месяца назад

Your tutorial about this is timeless! 2024 and still it rocks! thank you so much for sharing your knowledge to us :)

@stevecarter8810 2 года назад

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!

@zen801121 3 года назад

my excel knowledge, from previous 70%, after seeing this vedio become 0.1%

@bliviatei 4 года назад

This tutorial about gantt chart is by far the best that I've watched!!! Keep it up! it's very easy to follow 😉

@sheilakoech7414 4 месяца назад

E X C E L L E N T! I concur with many of the sentiments already shared. I thought I was good at Excel, apparently not. But grateful for the many lessons. I will recreate this, bet it will take me the better part of a morning, step by step. Thank you.

@omotayobamidele2733 9 месяцев назад

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.

@abdulrashid2023 3 года назад

Any one else with goosebumps -- Skill of the guy and Power of the Excel

@Emil-tx1fw 3 года назад

how do you link the date to the project start?

@KevalChhedaFilms 4 года назад

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!

@olipop84 9 месяцев назад

Wow, I’m a PMP and I have to say this is world class skills on display for all to benefit from. Thank you!

@amandasegura2483 Год назад

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

@suhadip 2 года назад

My dude. Thanks ever so much! You just saved my an unnecessary software subscription. Thank you!!!

@dosenwibu 3 года назад

I just want to appreciate this video, you are like Dumbledore but for Ms.Excel. Thanks again for sharing this with public!

@hamothemagnif8529 2 года назад

This was so well done. I haven’t had a chance to explore naming or scroll bars yet so i learned a lot. Thanks.

@jamiebrinegar 3 года назад

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!

@franzbiberkopf9179 4 года назад

This is absolutely the definitive tutorial to learn to do a chart-diagramm! Best way to endure the quarantene. All the best from Italy!

@maryrubin5493 Год назад

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!

@nastaciamorgan7085 3 года назад

Phew, 6 hours later and I am an expert at Excel. Thank you

@jonothen2212 3 года назад

Not gonna lie I can’t keep up with this but i am absolutely amazed

@mariadevlin7885 3 года назад

same here...hit pause every 10 sec at my end :)

@cynthiapadget5770 3 года назад

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.

@kayeturnbull8241 Год назад

Thank you for this informative tutorial. two thumbs up

@meto4837 2 года назад

honestly, forget being the best video on gantt charts *this is best video on excel, ever*

@vertex42 2 года назад

Thank you! :-)

@EdMathews4 3 года назад

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!

@tawan8705 2 года назад

It was very helpful and I sent it to my friends, they like it very much.

@crapyou03 2 года назад

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

@drakeip5618 3 года назад

I use spreadsheets daily at work, but I still managed to learn quite a lot in this 12 min video. Truly masterclass - thank you!

@michellerandall-english1573 4 года назад

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.

@vertex42 4 года назад

Thanks for the feedback.

@ajumalshamsudeen4937 2 года назад

Each second,a new concept is brought,now understood the scope and power of excel,Wow man one hell of a video

@agungsukariman Год назад

Thanks Vertex42! Love you 3000

@vertex42 Год назад

Hah! Endgame. :-)

@natashasamuel9346 3 года назад

Very Good demonstration of the GANTT Charts. Keep up the good work.

@equesfuscus 4 года назад

The most productive and concise RU-vid 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.

@tobeyjasper 3 года назад

My exact sentiments. This was very helpful and I have a beautiful chart now.

@carmenrincones7318 3 года назад

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.

@ALONEBBC 3 года назад

can u please share with me on mail id (ganjoo.vipin@gmai.com)

@sazzarello 3 года назад

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.

@06goatm6 3 года назад

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.

@vertex42 3 года назад

Thank you!

@paceyvu 4 года назад

This is a wonderful tutorial. Thank you so much for saving my day!!!

@vijaykembhavi3788 3 года назад

Fantastic! Impressed with "just to the point" content and focus on aesthetics

@olenaoleary7218 Год назад

Thank you!!!! So much info in one go. My head might explode )))

@turisabela 2 года назад

I really wanna thank you for this video! It's Oct 2021 and I 'm really glad for this amazing video! Thank you very much!!!

@adrianb.6880 2 года назад

Vertex42 please let us know when you get into Quantum physics. I will be the first one to learn it from you :) Great job!

@atiqurrahman8730 4 года назад

From the start to the end, I learned a lot functionality. Thanks 🙏.

@Archana2Kashyap 3 года назад

Hi There, Thanks for such a wonderful video clearly taking us step by step on creating beautiful Gantt Chart. My manager liked it. Thanks🙏🏼 Archana

@dominiquempundu621 Год назад

I Don't Know by what Miracle, I ended up getting Vertex web and I have been enjoying it so much. God bless your effort and all your time spent on these amazing works.

@daviduyaban 3 года назад

Look I'm gonna be honest.... I was in a hurry to get a file like this done, I thought I could pull it out fast, but then I realized it'd take some time to do my own. I just went to the Excel templates options and downloaded the nicest template that was available... then I realized it was from Vertex42 !!! Amazing!! same one as in the video hahhaa thanks your help!!

@arturovillalpando8182 4 года назад

The best demonstration I've seen, thank you.

@pedromartinez1165 3 года назад

Finally found a channel that teaches and not sells you a "membership", thank you! Semper Fi

@user-fv7qh4zl6v 4 месяца назад

Loved the flow process from the tutor

@stephcwe 2 года назад

I've never been so satisfied with using Excel until I watched your video, thank you so much 😩

@Sllee93 4 года назад

This helped me tremendously. Can't thank you enough!

@HappyNewYear2024. 2 года назад

@karlmac1 4 года назад

Thank you so much, this has really helped me.

@Revan176 2 года назад

astonishing what one could get out of just excel!

@christianjudesalcedo1531 4 месяца назад

I'm grateful to had found this video. I did learn to use bar chart to have a nice print for my gantt charts.

@iamsolia 7 месяцев назад

This video has been super cool to follow along! I haven't finished yet, but I'm working through each step and I got stuck at 2:05 where he's linking the project start date to the start of the chart. *For any Mac users like me:* You want to first click the cell with "1", then clear the cell and put an equal sign. THEN do FN + F4. If you just tap F4 it will keep taking you back to the launch pad. Hope that helps

@jerryjohns7358 4 года назад

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

@vertex42 4 года назад

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

@utpalninjajedi 2 года назад

This might be one of the best tutorials on youtube

@nursadiqah2166 3 года назад

THIS VIDEO IS SOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO SATISFYING TO WATCH

@sachinhada 4 года назад

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!

@nabeelahmad195 2 года назад

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

@aliahyar3174 Год назад

hahaha true

@KaderLana 2 года назад

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

@LeoRcCars Год назад

that is just God level in Excel!!!

@sudeep9554 2 года назад

This is one of the best excel tutorials I've ever come across...kudos to you, man. you deserve more views

@Xyles7 4 года назад

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 :)

@KingdomCtzen Год назад

For an investment of less than 13 min, I have a pretty awesome Gantt chart! Looking forward to other vids

@aycar306 2 года назад

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

@AljimmyAM 4 года назад

you taught us more than a few good things. thank you so much!

@pnowy1146 Год назад

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.

@dmd2803 2 года назад

this video is amazing, but one of the things that make it better is the music!! Can't remember howmany times I have fallen asleep during excel and coding videos on youtube !

@vadimzelencov9654 Год назад

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.

@annhatch2974 3 года назад

WOW! That was amazing. Thank you. I clearly need to up my game in Excel.

@storemywhether9605 2 года назад

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!

@excelwithhajar 3 месяца назад

Thank you for this detailed explanation it was really informative

@user-hl1ut5yc9k 5 месяцев назад

This is the best tutorial for Gantt Chart in Excel. Thanks a lot for sharing the knowledge. 👍

@willothewisp12 3 года назад

I am humbled. I thought I was pretty skilled with Excel. How wrong I was. This is a Masterclass.

@AbdullahBinSaeed 3 года назад

I was thinking the same while watching this video, this is ART.

@evieholmgren4141 3 года назад

Well this knocked me down a peg or twelve, and somehow that's a compliment. Excellent video.

@raulvasquez3368 2 года назад

Oh my god. This chart shown is level 100. Mind blown.

@Skumitomum 2 года назад

Certainly not a video for anyone but an Excel Expert!

@BhattVihang 3 года назад

Beauty. Didn’t know excel can be used this way too.

@alm9707 2 года назад

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)?