Came here after attending a required online project management LinkedIn workshop mandated by my organisation (also conducted by Mr Chris Croft). This video on Gantt Chart is very useful and applicable. Definitely complemented my learnings. Thank you! 😄👍
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
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.
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!
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.
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.
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.
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.
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!
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 TH-cam 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!
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
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 :)
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!
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.
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.
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
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.
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
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!
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
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!
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.
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. ;)
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.
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
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".
+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!
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.
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.
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?
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
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?
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 ?
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)
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 th-cam.com/video/fr2-xLTpeHM/w-d-xo.html
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
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!
Thanks for this excellent tutorial, it is as simple as that. But... is there a way, in the "hours" sheet to differentiate between type of employees in order to see in the chart below what type of employees you are needing at what time and how many?
Good question Dorina, and it's a tricky one! The core problem is that we have a cube of projects, resources/people, and time, and on a spreadsheet you can only view two out of the three. A database could do all three but gets too complicated to use for what-ifs etc. I think the answer is to choose your key resource, whatever is your bottleneck, and put that on the resource gantt, and plan around that. If you can manage the required resource for your bottleneck then you're OK
The other useful technique is to copy the Gantt onto a different sheet for each resource, and just put in their hours - so many tasks might be zeros if this resources isn't involved with them. Then you can see the resource profile for each person or team and check that they are OK with the project. It is then the responsibility of each person or group to shout if all of the projects add up to too much for them. They would probably manage this by putting the workload into their diary.
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
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
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.
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.
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?
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.
unlikely to be the length of the video! But - can you watch other long videos on TH-cam? Sounds to me like it might be time for a new laptop (any excuse!)
Not a excel tech oriented. Best gantt chart I've ever seen in here. Really appreciate!
Stephen Lee thanks Stephen!
Came here after attending a required online project management LinkedIn workshop mandated by my organisation (also conducted by Mr Chris Croft). This video on Gantt Chart is very useful and applicable. Definitely complemented my learnings. Thank you! 😄👍
Quite possibly the most useful video I've seen on You Tube ever.
OMG. I am in love with this process. Thank you So very much for the clear tutorial. I am throwing away MS Project!
thanks Lucy Lu - glad to hear it!!
Once again, an understated masterclass which draws the observer in. You sir, are a standard setter. Respect
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
You're the greatest, Chris! Thank you for this.
Wow! Just wow. So easily done and explained!! Immediately subscribed. Thank you !
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.
You're very welcome!
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!
My pleasure, thanks Cider Press!
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.
thanks MW - it's great to be appreciated like that!
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.
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.
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
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.
Many many thanks Chris. You gave me a very good, excellent, superb lesson to me.
thanks for the kind words Louis!
thanks Louis, glad you liked it! CC
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.
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!
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 TH-cam 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!
Thanks for those nice comments! Please pass the message on to others ...! More courses going onto Lynda soon
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.
check out my video "PM in under 8 minutes" - should help with the course
Thanks Chris. Quite simply the best Excel tutorial I have seen on TH-cam. Gantt charts just happened to be the topic. Cheers!
thanks Mr B!
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
transposing the chart, i.e. make the vertical axis as time axis, can make the chart more compact and readable
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 :)
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!
Thanks for taking the time Chris. Nice and simple!
glad you liked it! - thanks for letting me know
Excellent. Detailed and dynamic. Thank you Chris
thanks Nico!
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.
Double thumbs up! I'm really flattered, thanks Lou
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.
thanks Mark, glad to have helped! Good luck with Prince; I think you'll find it's not the answer.....!
really helpful video - much simpler than the other interactive Gantt chart examples I've come across - will be implementing this immediately!
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
thanks Erik! Glad you liked my sense of humour!
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
+Karen Travers Brilliant to hear that you're already putting it into action
Excellent video very helpful in putting together a Gantt chart for my class. Thanks!
wow, great to hear that it was passed on to a whole class. Thanks Charles!
This is the best of its kind. thank you so very much! please keep posting of your wonderful experiences.
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.
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
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!
Thanks Chris: Very useful, well-explained, practical, functional. I really liked the first step - Post-it Note Plan.
Brilliant! This is all the project management I need to run my own start up for now.
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
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!
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.
Cheers Chris excellent video, very helpful! I made mine in parallel just pausing and rewinding once in a while.
i am in truly love with u ..! u have explained it with so much of ease !!! thank you ..!! it was awesomeeee
thanks for that comment! Makes it all worthwhile....
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. ;)
thanks Lyndsay!
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.
Thank you, Chris. I love your tutorials.
Chris, THANK YOU!!! Much appreciated my friend 😁👍
Take Care 👍
I would suggest it for anyone who work in project
This was really useful and i enjoyed making this gantt chart.
Nice, simple and informative video!! Thanks Chris.
Love the SPM Chris you are great, make everything about project management easy to understand. Thank you.
Great video. This was very helpful. Thank you for posting this.
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.
Rashed Hiyasat - haha thanks!!
I agree that most people have Excel so this is really useful in recording information.
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!
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
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".
+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!
if anyone has got 1,200 friends, please do forward this on - I really want to get to 200,000 views!
yay - made it!!
Chris could you do more Excel and Access videos please.. you are very good
Thank you! Very clear and helped me a lot!
my pleasure Felipe!
This is great!. I also saw your lynda course. Thank you!
Chris, thank you for creating this vid..
Excellent tutorial and very sound advice!!
Professional, good explanation, really helped for my dissertation proposal!
Thanks Chris for this tutorial. Is there any way I can add dependencies to the tasks?
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.
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.
just watched, was very useful Chris, thanks!
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?
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
That was really helpful thank you. I have just used it to create a Gantt Chart for my project. :-)
Great to hear that it helped! Now you can never go back...!
Thank you very much sir for this useful session on Gantt
+Vikram Muralidaran - my pleasure
Thankyou this really helped me heaps ,in my assessment .. easy to understand now.
great, I'm glad to hear that it helped Mari! You'll probably also like my "PM in under 8 minutes" video as well - shows the bigger picture
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?
+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.
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 ?
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)
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 th-cam.com/video/fr2-xLTpeHM/w-d-xo.html
Nice explanation Chris..Thanks!
fantastic video ... exactly what i was looking for
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
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!
Great reminder Chris thanks.
Thanks for this excellent tutorial, it is as simple as that. But... is there a way, in the "hours" sheet to differentiate between type of employees in order to see in the chart below what type of employees you are needing at what time and how many?
Good question Dorina, and it's a tricky one! The core problem is that we have a cube of projects, resources/people, and time, and on a spreadsheet you can only view two out of the three. A database could do all three but gets too complicated to use for what-ifs etc. I think the answer is to choose your key resource, whatever is your bottleneck, and put that on the resource gantt, and plan around that. If you can manage the required resource for your bottleneck then you're OK
The other useful technique is to copy the Gantt onto a different sheet for each resource, and just put in their hours - so many tasks might be zeros if this resources isn't involved with them. Then you can see the resource profile for each person or team and check that they are OK with the project. It is then the responsibility of each person or group to shout if all of the projects add up to too much for them. They would probably manage this by putting the workload into their diary.
Thank you Chris, about time they invent a 3D excel sheet ;-)
Chris,
Very useful. Thanks.
Mr. Croft Thanks you for posting this, its very important for my work
Have you wrote a book?
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
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
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.
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.
Yes that would certainly work. Although I think it's best to keep it simple even if that makes it a bit slower
Very good video!
you make seem easy thank you
You're hilarious. Thanks for these videos.
Whoa!!!!! HE IS AMAZING!!!!!
haha thanks very much!
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?
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.
Thank you !! It was very interesting ....
Great video's, thank you very much!
Thank you. it's was really helpful
You good sir, are brilliant. Many thanks!
Thanks Folks, It really help me a lot for the company.
Thanks. This was really helpful!
why in my laptop it doesnt work? theres pop up that said the series is too long
unlikely to be the length of the video! But - can you watch other long videos on TH-cam? Sounds to me like it might be time for a new laptop (any excuse!)
excellent!!! Thanks for posting.
Great ! thanks Chris (and for the "floaters" lol) .
yes, even in Project Management we can find the occasional laugh. I do wonder how many people have spotted those...
so perfect Christ !!! it so simple and sweet
Thanks so much!
yes, there has been a sudden surge recently - no idea why!
Legend! thanks mate
All hail the Gant Guru!
Great, low cost, efficient, fully customisable... I guess we can do the same using OpenOffice Calc (No license fees)
Probably yes - even cheaper!
haha thanks Peter! I am indeed The Gantt Guy!
I came here from DePaul Leadership Course - The Hay Project
are they recommending me??
Thanks! Very Useful video :)
Excellent, thanks!
EXCELENTE VIDEO