Gantt Chart Excel Demo

[@Skyrad01]

Quite possibly the most useful video I've seen on You Tube ever.

[@flashtheoriginal]

Once again, an understated masterclass which draws the observer in. You sir, are a standard setter. Respect

[@theChrisCroft]

thanks Flash - yes there's ore work and knowledge in this the meets the eye - it's taken me years to work out the best way to make Gantt charts, keeping it simple etc. Plus it's necessary to REALLY understand project management, as well as a bit of Excel. Glad you liked it. Spread the word! regards CC

[@stephenlee4959]

Not a excel tech oriented. Best gantt chart I've ever seen in here. Really appreciate!

[@theChrisCroft]

Stephen Lee thanks Stephen!

[@theChrisCroft]

if anyone has got 1,200 friends, please do forward this on - I really want to get to 200,000 views!

[@theChrisCroft]

yay - made it!!

[@77pointfive]

Wow! Just wow. So easily done and explained!! Immediately subscribed. Thank you !

[@theChrisCroft]

Hey everybody, if you want to see the bigger picture of project management, and how Gantt charts fit into that, then have a look at my video called 'Project Management in under 8 minutes' - tells you everything you need to know.

[@janishaswin]

just watched, was very useful Chris, thanks!

[@lucylu3111]

OMG. I am in love with this process. Thank you So very much for the clear tutorial. I am throwing away MS Project!

[@theChrisCroft]

thanks Lucy Lu - glad to hear it!!

[@SamiUddinConnected]

Chris you are not human, you are an Angel. I love you...do you know how easy you made a complex concept for a dumb and duffer person like me. its really useful stuff that you are throwing away for free, I want to call you to say thanks.

[@theChrisCroft]

Sami Uddin - thanks Sami! It's okay, you don't need to call me, but it is really great to hear from people who I have helped. I know I'm giving it away for free but firstly it doesn't cost me anything to give it away, secondly I benefit hugely from hearing from people like you, and thirdly I hope that in this world you do receive what you deserve in the end, you reap what you sow, so I'm sure I will be rewarded in some way, although the satisfaction alone is pretty good! So thank you for taking the time to leave me a nice comment

[@RAQdrian]

Helped, that you have! And I think that you helped ways more that just a few people, but the realization of projects, maybe even of dreams ! Thank you!

[@haghighat1]

This is the best of its kind. thank you so very much! please keep posting of your wonderful experiences.

[@spaced1969]

Hello Chris, I’m a brand new manager and am struggling to get my team to plan their work. ‘Not my Job to plan, I just want to deliver’ is what I am faced with. Without a project manager in the department all the planning seems to be falling to the manager (me), across around 20 projects it’s unmanageable. Any advice on getting my team on board with the importance of planning?

[@theChrisCroft]

you need a project management course for you and your team (and maybe your boss too!) - either in person, via Zoom, or from udemy.com. More info at www.chriscroft.com

[@sokiscuteidea8013]

I would suggest it for anyone who work in project

[@businessasusual3850]

You're the greatest, Chris! Thank you for this.

[@dittilio]

You're hilarious. Thanks for these videos.

[@krimpse]

i had to watch this video in college and found it very boring the video is way too long

[@theChrisCroft]

Hi Ewan - thank you for that feedback. For someone with a shorter attention span (and who doesn't want to see my nose) I would recommend this: kzbin.info/www/bejne/iH7MmneYlKididU You can see it all in two minutes, ideal for a Millennial!

[@krimpse]

cheers XD that was joke my mates told me to say that but good video just didnt like the length

[@oluwaseyiolusanya9216]

I came here from DePaul Leadership Course - The Hay Project

[@theChrisCroft]

are they recommending me??

[@smk20136]

Chris, an excellent Gantt video, the best so far...very magnanimous and caring to have given this idea. I wanted a simple yet comprehensive way to manage my upcoming assignment for managing a fun-city project.

[@BoxerDogs]

Great video. This was very helpful. Thank you for posting this.

[@theChrisCroft]

haha thanks Peter! I am indeed The Gantt Guy!

[@Degerlunden.]

Use conditional formatting "Greater than -1" instead of 0 and you will still have the formatting and be able to enter the digit 0 and not the letter O. You will have to create another rule for the same cell for "Cell contain blank - No format" and then check the box "Stop if true". Make sure that the other rule is above the rule "cell value > -1".

[@theChrisCroft]

+Markus Degerlund - wow that's really clever! Though i think most people, including me, won't be able to remember it next time they create a chart, whereas my idea of putting in an O is nice and simple.... but agreed, it's a bit of a bodge!

[@michaelbeckett7616]

Cheers Chris excellent video, very helpful! I made mine in parallel just pausing and rewinding once in a while.

[@Serj772]

shoot me...i am the 9,666th viewer...

[@lougarcia7265]

I tried to give this video a double thumbs up but it wouldn’t let me. Great video particularly for someone such as myself that is looking to reclassify career to project management.

[@theChrisCroft]

Double thumbs up! I'm really flattered, thanks Lou

[@RxpidF1]

This was really useful and i enjoyed making this gantt chart.

[@louislui2872]

Many many thanks Chris. You gave me a very good, excellent, superb lesson to me.

[@theChrisCroft]

thanks for the kind words Louis!

[@theChrisCroft]

thanks Louis, glad you liked it! CC

[@brookeatkins1044]

Hi Chris, I am extremely appreciative! Thank you so much for taking the time to teach others how to make a Gantt Chart using Excel. I followed your video step-by-step and within an hour I had a complete Gantt Chart to share with my project team. So incredibly useful, thank you for simplifying the process to make a Gantt Chart and making it easy to learn.

[@ciderpress6656]

I am very grateful to you, Chris, for producing such a clear and articulate explanation of how to draft Gantt charts. I learned more from this video than I thought possible and it is going to save me a lot of time with planning projects. Gifting this to everyone, as you have done, shows that you are a kind and thoughtful soul!

[@theChrisCroft]

My pleasure, thanks Cider Press!

[@DamianMark888]

Chris, THANK YOU!!! Much appreciated my friend 😁👍 Take Care 👍

[@hyacinthdibley2420]

Whoa!!!!! HE IS AMAZING!!!!!

[@theChrisCroft]

haha thanks very much!

[@user-gp5ot2xb7t]

Very good video!

[@mzamroni]

transposing the chart, i.e. make the vertical axis as time axis, can make the chart more compact and readable

[@rajwaik]

Hi Chris, thank you very much for explaining the difficult Gantt Chart in simple way. It is not that easy to explain the complex/difficult thing in simpler way so thank you again for informative yet lighter session. Your teaching style is really great.

[@theChrisCroft]

You're very welcome!

[@Yosalsafiesta]

Chris, Thank you very much! I was lost developing and managing my company until I saw this video. Keep on with the good work. Best Regards from Colombia!

[@Wtgoesaroundcomesaround]

i am in truly love with u ..! u have explained it with so much of ease !!! thank you ..!! it was awesomeeee

[@theChrisCroft]

thanks for that comment! Makes it all worthwhile....

[@HelenahSwedberg]

I'm getting a masters in strategic communication and will be taking a project management class this summer. Watched your Lynda.com course on Project Management Simplified and thought it was just fantastic! And now I'm making my way through your KZbin Channel. So much good stuff!! This demo video was so great. I feel like I can totally go make my own GANTT chart now. I don't know how I've survived previous projects without it. Thank you for producing such great work!

[@theChrisCroft]

Thanks for those nice comments! Please pass the message on to others ...! More courses going onto Lynda soon

[@manpreetbishnoisigar7583]

gan chart

[@jackbean5174]

Chris, thank you for creating this vid..

[@notesguru99]

Great demo, much easier than battling with MS Project, especially like the idea to sum all of your project time.... By the way, what software did you use to create your video please?

[@MrBrift]

+Stuart Seed - glad you like it Stuart! Not sure how it was done, a friend made it. I used to use Screenr but that has become a pain recently.

[@danielaquinonez8098]

This is great!. I also saw your lynda course. Thank you!

[@karentravers658]

Thanks Chris did your course last Friday in Poole and you made it look so easy (which it is really). Thought I would build a Gantt chart why it is still fresh in my mind. Aghhh couldn't remember, this video brough it all flooding back. Now I have my Gantt chart and your video saved in favourites. ThanksKaren

[@theChrisCroft]

+Karen Travers Brilliant to hear that you're already putting it into action

[@Indysay]

Hi Chris, I've been in the Project vs. Excel debate for a time and in the end have come back to excel with teams I've worked on as its ubiquitous and easy to use. Until watching your video I was unaware you could create such wonderful Gantt charts using Excel. Have enjoyed this video and look forward to using this with my team! And yes... I laughed, and gasped. ;)

[@theChrisCroft]

thanks Lyndsay!

[@oleksandrmaystrenko4189]

Thank you, Chris. I love your tutorials.

[@cracker121267]

Hi Chris, I have not long moved into IT Management from a different industry, and your demo is a real eye opener, I will be using it from now on, I have subscribed to you, thank you so much, a breath of fresh air!, I have just started the Prince2 course online through my company, so this will also help there, thanks again Chris, very much appreciated.

[@theChrisCroft]

thanks Mark, glad to have helped! Good luck with Prince; I think you'll find it's not the answer.....!

[@jeanetelourdesvicunavillav8046]

Thank you !! It was very interesting ....

[@marshwetland3808]

Another brilliant piece of instruction. I taught adults for 8 years, myself, and it's great to see something so easy to follow with plenty of powerful details included.

[@theChrisCroft]

thanks MW - it's great to be appreciated like that!

[@deborahhill]

That was really helpful thank you. I have just used it to create a Gantt Chart for my project. :-)

[@theChrisCroft]

Great to hear that it helped! Now you can never go back...!

[@theChrisCroft]

thanks BM! check out my project management rap as well - that might be more to your liking! (or maybe not....)

[@RashedHiyasat]

this is amazing, you made it look so easy! and yes i gasped :) i will definitely be checking the rest of the courses , thank you.

[@theChrisCroft]

Rashed Hiyasat - haha thanks!!

[@bashar12bashar]

much thank you Chris. this was a great preparation for a course of project management that I am going to take after two days. Thank you again.

[@theChrisCroft]

check out my video "PM in under 8 minutes" - should help with the course

[@nicodasm]

Excellent. Detailed and dynamic. Thank you Chris

[@theChrisCroft]

thanks Nico!

[@awakenwithalexp]

Very nice. I am enjoying your content. However, can you explain or say more about the critical path in the network diagram? What makes it critical? You said it's the longest of path but there's an off shoot in that critical path that makes it longer that is not being highlighted (I.e, find local suppliers of furniture and purchase furniture)

[@theChrisCroft]

Hi Alex - you're right, the critical path is the longest (slowest) path. The branch involving the furniture is only 2+2 while modifying the buildings is 8, so the critical path goes through the buildings. More information here kzbin.info/www/bejne/nKOVXquCidWYfq8

[@19Goose72]

Great ! thanks Chris (and for the "floaters" lol) .

[@theChrisCroft]

yes, even in Project Management we can find the occasional laugh. I do wonder how many people have spotted those...

[@joshgoldman3384]

Hi Chris, your gantt chart is very useful but i have an assignment that is asking for the cash flow required. Is there anything major i have to do besides making a column for the cash flow. or does it add up like the project? Cheers

[@theChrisCroft]

Hi Josh I think I would add a couple of ideas - one is that there is a time lag, so you might incur costs but not have to pay them straight away - one of the differences between cash flow and profit. The other one is that you can look at income as well as costs - when you finish tasks in the project you might get paid stage payments by customers, or start to get income - these can also be added into the cash flow (also with time lags maybe, since you invoice them but there is a delay before you get paid). But all this flows from the Gantt chart, which is the starting point for seeing what happens when. I hope that helps!

[@soniarodrigues1781]

Thanks Chris for this tutorial. Is there any way I can add dependencies to the tasks?

[@theChrisCroft]

Good question - not that I know of. but if you start with a post it note diagram - which is a great way to do it - then all you need is what I have shown - the critical path first, and then the dependencies are shown as the vertical lines ion the Gantt chart. So then you don't need to have any other dependencies.

[@PeterClapperton]

All hail the Gant Guru!

[@theChrisCroft]

yes, there has been a sudden surge recently - no idea why!

[@nadinerichings4259]

Thanks Chris: Very useful, well-explained, practical, functional. I really liked the first step - Post-it Note Plan.

[@fazerville]

This is wonderful stuff Chris. I have used MS Project for plant maintenance projects and find the software a little unwieldy. There is too much going on in MS Project and can become a full time job just to run it instead of getting on with the project itself.Do many PMs use this approach with Excel ?

[@lukelucy1980]

Thank You for sending this link. The sound is excellent and very clear. You do an awesome job in putting the information together for a clear concise lesson. Your a born teacher. Thank You from all of us that have limited access to information outside of college or corporate training. You have a friend in ST John USVI

[@adilshah57]

Way to go Chris. What a nice and effective way to learn the Gantt chart. Of all the videos I have seen, this one is the far most best demonstration of building a Gantt chart. I am also impressed by your videos on Lynda.com for project management simplified as well as Gantt charts. Your way of teaching and demonstration is exceptional. You have made my day!! Adil

[@RushViperHD]

sick video man good work :) xx

[@theChrisCroft]

thanks Jack - my distant relative!

[@felipedesouza9255]

Thank you! Very clear and helped me a lot!

[@theChrisCroft]

my pleasure Felipe!

[@clairepeters3253]

really helpful video - much simpler than the other interactive Gantt chart examples I've come across - will be implementing this immediately!

[@ericren5390]

Hi Chris, thank you very much for making this so clear for me so that I have much more confidence while applying for my next job related to project management in the following days. I am refreshed by they way you are showing us and no hesitate to follow your channel and thank you again for your great demo.

[@akunnaafolabi3885]

Hello Chris, I have not only learnt how to draw a Gantt chart, this video helped me with my coursework. You really are a great teacher. Thank You.

[@VG_Njoy]

Nice, simple and informative video!! Thanks Chris.

[@theChrisCroft]

'Miles moment' at 17.20....

[@Xhar.]

Legend! thanks mate

[@gingercrystal]

Love the SPM Chris you are great, make everything about project management easy to understand. Thank you.

[@dannygray1154]

I agree that most people have Excel so this is really useful in recording information.

[@busyshah]

Brilliant! This is all the project management I need to run my own start up for now.

[@ridafajriani4419]

why in my laptop it doesnt work? theres pop up that said the series is too long

[@theChrisCroft]

unlikely to be the length of the video! But - can you watch other long videos on KZbin? Sounds to me like it might be time for a new laptop (any excuse!)

[@fredmagallon1728]

excellent!!! Thanks for posting.

[@Jandjango]

Great video's, thank you very much!

[@garyms05]

You good sir, are brilliant. Many thanks!

[@jlativo1]

Thanks Folks, It really help me a lot for the company.

[@mr.alentar]

so perfect Christ !!! it so simple and sweet

[@theChrisCroft]

Thanks so much!

[@brucelee6946]

Thank you. it's was really helpful

[@harveydavidredondomendez9881]

no entendi nada

[@egonmuller1947]

This is really excellent ! thank you so much :-)

[@nathansimmons5733]

Professional, good explanation, really helped for my dissertation proposal!

[@EricTyce]

Chris could you do more Excel and Access videos please.. you are very good

[@theChrisCroft]

thanks Skyrad01!

[@charlesschreiner8556]

Excellent video very helpful in putting together a Gantt chart for my class. Thanks!

[@theChrisCroft]

wow, great to hear that it was passed on to a whole class. Thanks Charles!

[@tomikopark6347]

Chris, your video was so informative! I have been so lost on how to use the CPM. I still have one problem. When I enter my first two dates, instead of the rest of the cells following the week timeframe, it automatically adjust to give a daily time frame. Meaning that instead of it following June 11th, June 18th, etc. it adjust to say June 11th, June 12th, June 13th How do I fix this?

[@theChrisCroft]

Hi Tomiko - I think the answer is that you have to put in the first TWO dates, with the second one being a week later than the first. Then select both of them and then drag the little dot in the bottom right corner. then Excel knows you want them to have gaps of a week.

[@2gther4ever]

You saved me. My MBA has a section on Project Management and until now I never knew how to prepare a Gantt Chart for a project. Easy and simple to follow. Thanks again.

[@theChrisCroft]

delighted to hear that Julius! Check out Project Management in under 8 minutes as well, will give you a great overview of thew whole of PM

[@theancientvoice9272]

Great, low cost, efficient, fully customisable... I guess we can do the same using OpenOffice Calc (No license fees)

[@theChrisCroft]

Probably yes - even cheaper!

[@bourky42]

Thanks Chris. Quite simply the best Excel tutorial I have seen on KZbin. Gantt charts just happened to be the topic. Cheers!

[@theChrisCroft]

thanks Mr B!

[@evigneault]

Hi Chris, that was a witty and very enjoyable presentation, many thanks. Quite useful indeed those Gantt charts made simple the way you do it. Erik

[@theChrisCroft]

thanks Erik! Glad you liked my sense of humour!

[@CreekCat1]

Fantastic! This was much help and you explain and show things in an easy, pragmatic way. I just made to cover the remaining work on my wetlands project. This method is going to be put to use from now on with my projects and work. Thanks!

[@theChrisCroft]

Thanks Yvette! Great to hear that I'm indirectly helping with the wetlands! I do find it amazing how everyone makes it so complicated, when it really doesn't need to be. Glad to have helped.

[@paulfallon45]

Hi ChrisGreat video just a pity you can't over lap the tasks, like start one task halfway through the week and finish halfway through the following week and so on ,have you got any suggestions for this without bulking the charts up by fragmenting it in to days instead of weeks ? thanks Paul

[@theChrisCroft]

There's two things there - overlapping tasks - which is easy, and going down into half a week which is more difficult. My suggestion is that longer Projects should never have tasks taking less than a week because in reality everything ends up taking a week. Round them up and you get a bit of safety margin. If you've got a short project, say it's only taking three weeks, then I would use days across the top of my chart rather than weeks. And then again you can't have something taking less than a day. Keep it simple and it will work just fine.

[@Yosalsafiesta]

Chris! thanks for all the good advice! I am using this tool to develop my startup. Let me know if you ever come to Colombia!

[@theChrisCroft]

thanks RVG! It would be great to meet you one day, over in Colombia! Meanwhile it's great to know that it helped. Check out my "PM in under 8 minutes" video as well - lots of useful stuff there too

[@techmaster3674]

Dear Mr. Chris, what you have share is more then amazing, i am in a process to start a new venture and was completely bogged down by so many different tasks that i have to get done, but after watching your video i am so relieved. I am planning to use post-it notes with my team and i can feel that it would be fun for everyone in the team. Thank you so very much for explaining such a difficult concepts in such easy way. You are great :)

[@theChrisCroft]

it is my pleasure! thank you so much for your kind message, it makes all the difference to know that people out there are viewing my stuff and finding it helpful!

[@theChrisCroft]

thanks LJ!

[@nfsking2000]

Thanks. This was really helpful!

[@manishagrawal417]

Hi Chris. Very nice video to make a gantt chart in a simple way. Thank you. Also, I have a question, As you introduced the bar chart for the weeks or hours, Can we prepare the gant chart itself using excel charts to make it dynamic in nature too, so that when we change the data points like hours etc the gantt chart also updates. in that way we can also add completion timelines as well.

[@theChrisCroft]

Yes that would certainly work. Although I think it's best to keep it simple even if that makes it a bit slower

[@eeerrrwwwuuu]

Change condition for empty cell instead of > 0 , You will avoid "O"

[@theChrisCroft]

thank you, strangely-named-person. Someone else suggested this but ti's quite difficult to get to to work. Something to do with integer values...? Anyway, I think the O is the simplest way to do it - keep it simple for people who don't know much about excel....?

[@domenicodascoli6970]

Mr. Croft Thanks you for posting this, its very important for my work Have you wrote a book?

[@theChrisCroft]

yes indeed, you can get it on Kindle here www.amazon.co.uk/Project-Management-deliver-successful-projects-ebook/dp/B005MOLEVI/ref=sr_1_1?s=digital-text&ie=UTF8&qid=1396815670&sr=1-1&keywords=chris+croft+project and a paperback from lulu here - www.lulu.com/shop/chris-croft/project-management-instant-guide/paperback/product-21554008.html

[@theChrisCroft]

13.30-13.40!

[@EricTyce]

fantastic video ... exactly what i was looking for

[@parthasarathy9547]

Chris, Very useful. Thanks.