HomeОбразованиеRelated VideosMore From: Subjectmoney

Gantt Chart Excel Tutorial - How to make a Basic Gantt Chart in Microsoft Excel 2013

3746 ratings | 787272 views
http://www.excelfornoobs.com In this Microsoft Excel 2013 tutorial I show you how to make a basic Gantt Chart. This is a basic Gantt Chart that shows the time frame of a project and the time frame of the individual task that are to be performed. This Gantt Chart is basic so it doesn't show the progress of the project. If you would like to see an Excel tutorial on how to create a Gantt Chart that shows the progress of a project you can find it by searching through my videos. https://www.youtube.com/watch?v=-oD50HSBBBI https://www.youtube.com/user/Subjectmoney http://www.roofstampa.com hjttp://roofstampa.com http:/www.subjectmoney.com http://www.excelfornoobs.com
Html code for embedding videos on your blog
Text Comments (307)
Your tutorial is just something amazing, very useful. You're a wonderful teacher indeed. Keep up the good work
audrey santoso (1 month ago)
your video helped me go through some project presentations, thank you so much!!!
Guy Ivie (1 month ago)
Simple but powerful. Thank you!
Thanks a million times, you really helped me. Keep up the good work
Timothy Woods (1 month ago)
Is it possible to add a Critical path from this basic Gantt Chart?
Timothy Woods (1 month ago)
Fantastic, very easy to follow. Super informative and easy for someone who is PC inept like myself!
Dmitry Dudin (1 month ago)
It's better to try Ganttpro, like here https://www.youtube.com/watch?v=hDvRdboEPiY
A Google User (1 month ago)
Thank you sir! I SOO needed this video to help my brother out before his big presentation.
Angel Nicholls (2 months ago)
How can you make the start date of the chart automatically start at the first date entered in the table, without writing the number version of the date in the options section?
Jeremy Talbot (2 months ago)
Thank you! This was the clearest explanation on how to make the chart I have found on youtube.
Josh Perry (2 months ago)
You just saved my life. Thanks!
Vnet Gamers (2 months ago)
great video thank you
keylock000 (3 months ago)
Unlike much information posted online this was the most useful and it is (like MS project management) a complex process for many ways of doing this program. Thanks for your short but effective video.
Ada Osu (3 months ago)
This was very useful. thanks
Maxim Petrov (3 months ago)
Cheers for the Video! Excuse me for butting in, I would love your thoughts. Have you considered - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a good exclusive product for getting 7000 plus project management and business templates without the normal expense. Ive heard some great things about it and my friend Sam  got amazing success with it.
Sanja Sanjic (3 months ago)
Great video content! Sorry for chiming in, I would love your opinion. Have you tried - Weydaniel Organized Dominator (do a search on google)? It is an awesome one off product for getting 7000 plus project management and business templates minus the hard work. Ive heard some awesome things about it and my good mate called Gray after many years got amazing results with it.
Hasan Mahamud (4 months ago)
thanks a lot, you help me too much
Mike zzz (4 months ago)
Thanks a lot!
Nikos Likos (5 months ago)
teseguler
99lomari (5 months ago)
Thank you so much, really wonderful,
AnimeGuy (5 months ago)
tyvm
Zohaib Adil (5 months ago)
Nice work
FALAKNAAZ BORAL (5 months ago)
thx alot
Durgesh Swarnkar (6 months ago)
please provide the link for advance level gantt chart prearation.
Joe Feghaly (6 months ago)
that's great thank you
PvG Media (6 months ago)
Is it possible to: 1) make an hourly Gantt chart (for one day), and 2) have several tasks on one row, sorted by team members?
Dad man (6 months ago)
Excellent Video clip! Excuse me for chiming in, I would love your thoughts. Have you heard the talk about - Weydaniel Organized Dominator (do a search on google)? It is a good one of a kind product for getting 7000 plus project management and business templates minus the normal expense. Ive heard some awesome things about it and my friend Sam at last got excellent results with it.
John Smith (6 months ago)
Excellent Video clip! Apologies for the intrusion, I am interested in your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is an awesome one of a kind guide for getting 7000 plus project management and business templates minus the headache. Ive heard some interesting things about it and my work colleague got excellent results with it.
Mad Life (6 months ago)
OMG.. thank you sooo much..
Abubaker Patel (7 months ago)
it dont even work. waste of time
Haanee Khan (7 months ago)
Thanks!
Daryll Alexander (7 months ago)
Hi can someone please help me, after I changed the design layout like in the video my data table is in reverse order and I am unable to change it. When right-clicking on the table there is no "Axis" option where the reverse option is available. Please help me
Y.E. Ganesh (8 months ago)
I'd like to introduce a far more fine way please look at <https://goo.gl/yiFDBM>. I use a free trial version of Asprova, which is used by 2500 factories TOYOTA, Canon, Honda, YAMAHA, SONY, Haier, Bombardier, Foxconn, Bosch etc.
Amirul Hafiey (8 months ago)
very helpful! thankyousomuch!!!
Benedict Lumabi (8 months ago)
Many thanks man!
Salaheddin Abushhiwa (8 months ago)
You are awesome and save my time. Thank you very much
Salem Alsubiae (8 months ago)
I do thank you but it still at the end when you changed the layout appears that tasks starts from 10 to task i? how to flip it? "At the bottom of the gantt chart it says Task 8 to Task 1. How do i flip it around? Thanks! Great help so far"
Salem Alsubiae (8 months ago)
I do thank you but it still at the end when you changed the layout appears that tasks starts from 10 to task i? how to flip it? "At the bottom of the gantt chart it says Task 8 to Task 1. How do i flip it around? Thanks! Great help so far"
naval malpani (8 months ago)
Thanks!'
Y.E. Ganesh (8 months ago)
I'd like to introduce a far more fine way please look at <https://goo.gl/yiFDBM>. I use a free trial version of Asprova, which is used by 2500 factories TOYOTA, Canon, Honda, YAMAHA, SONY, Haier, Bombardier, Foxconn, Bosch etc.
zoi agathangelidou (9 months ago)
great tutorial! Managed to do each step simultaneously with you! thanks a lot!
Ultha Niraula (9 months ago)
Thankyou so much for the tutorial :)
Majed Mohammed (9 months ago)
Thanks man
Britteny Park (9 months ago)
You have just saved me thank you so much. I would of failed if it wasn’t for this video
Özgür Bircan (9 months ago)
Liked the video! You can also check this one: http://bit.ly/gantt-chart-maker
Immaculee Birere (9 months ago)
very helpful....it has helped me really.
Y.E. Ganesh (8 months ago)
I'd like to introduce a far more fine way please look at <https://goo.gl/yiFDBM>. I use a free trial version of Asprova, which is used by 2500 factories TOYOTA, Canon, Honda, YAMAHA, SONY, Haier, Bombardier, Foxconn, Bosch etc.
Tuğba Yolaçıcı (10 months ago)
thank u so much bro u're amazing u saved my life
StudioBinder (10 months ago)
Great tutorial! We actually created our own Gantt chart template in Sheets which should hopefully make things easier for people ;) https://www.studiobinder.com/blog/free-gantt-chart-excel-template/
Marija Marija (10 months ago)
Thank you very much! You helped me a lot!
Lucas Graboski (10 months ago)
Thank you!
bo sun (10 months ago)
nice!!!!!
Ethel Suarez (11 months ago)
Appreciate Video clip! Excuse me for butting in, I am interested in your initial thoughts. Have you heard about - Weydaniel Organized Dominator (just google it)? It is an awesome one of a kind guide for getting 7000 plus project management and business templates without the hard work. Ive heard some super things about it and my m8 at last got cool success with it.
Huraira Arif (11 months ago)
you saved my ass, its 4am, the morning before my assignment is due 😂
Daniel Valenzuela (11 months ago)
I downloaded a free Agile excel template and man is it being a bitch trying to reformat it to what I need, but this tutorial on how the Gantt chart was created is a HUGE help, thank you!!!!
Emre Yilmaz (Student) (11 months ago)
Well played.
Muzamil Mehmood (1 year ago)
really helping tutorial, Thanks for your efforts :)
Simeon Spiridonov (1 year ago)
In the tutorial works like magic. However, when I try to add the Days to Complete, buuuuum: "The reference is not valid. Reference for titles, values, sizes or data labels must be a single cell, row or column." Been fighting with this error the last 1 hour... barely keeping my eyes open, what's wrong with the stypid program, I just want it to add one more column and it does not want to add it.
Krazy Kite (1 year ago)
How do you present the first day of each month on the horizontal axis?
Y.E. Ganesh (8 months ago)
I'd like to introduce a far more fine way please look at <https://goo.gl/yiFDBM>. I use a free trial version of Asprova, which is used by 2500 factories TOYOTA, Canon, Honda, YAMAHA, SONY, Haier, Bombardier, Foxconn, Bosch etc. It's so excellent production scheduler that is not cheap, but is free up to 250 tasks.
LayeDiaw (1 year ago)
Great tutorial
Anie SantoVillo (1 year ago)
Just completed an assignment on this. The start date info.....excellent.
Salome Mungai (1 year ago)
nice and easy thank you
Rainbow River Videos (1 year ago)
After a few years away from technical work I was rusty on Gant Charts, your tutorial was very easy to follow and worked for me!! You are now in my favorites. (I also like that your tools did not assume I bought some program or ask me to buy something.
Y.E. Ganesh (8 months ago)
I'd like to introduce a far more fine way please look at <https://goo.gl/yiFDBM>. I use a free trial version of Asprova, which is used by 2500 factories TOYOTA, Canon, Honda, YAMAHA, SONY, Haier, Bombardier, Foxconn, Bosch etc. It's so excellent production scheduler that is not cheap, but is free up to 250 tasks.
Syazana Auni (1 year ago)
thank you for helping me so much
Y.E. Ganesh (8 months ago)
I'd like to introduce a far more fine way please look at <https://goo.gl/yiFDBM>. I use a free trial version of Asprova, which is used by 2500 factories TOYOTA, Canon, Honda, YAMAHA, SONY, Haier, Bombardier, Foxconn, Bosch etc. It's so excellent production scheduler that is not cheap, but is free up to 250 tasks.
Interesting Stuff (1 year ago)
hey, this is pretty cool and easy, now that you have shown me. THANKS
Sonia Rodrigues (1 year ago)
Thank you so much for this tutorial. Is there any way I can add dependencies to the tasks?
Sonia Rodrigues (1 year ago)
Thanks Pradeep - Awesome Template!
Pradeep Dsouza (1 year ago)
You will need an excel template. Try Gantt Chart Excel as it supports Tasks & Milestone Dependencies - https://www.ganttexcel.com/gantt-chart-excel/
Thanks a lot..You helped me to do my project
cute yo (1 year ago)
How you set other dates?
Hi Def (1 year ago)
Isn't a Gantt chart like an action plan?
Y.E. Ganesh (8 months ago)
I'd like to introduce a far more fine way please look at <https://goo.gl/yiFDBM>. I use a free trial version of Asprova, which is used by 2500 factories TOYOTA, Canon, Honda, YAMAHA, SONY, Haier, Bombardier, Foxconn, Bosch etc. It's so excellent production scheduler that is not cheap, but is free up to 250 tasks.
Ralph Worix (1 year ago)
Excellent, thank you.
Thomas Volinchak (1 year ago)
Thisis mental masturbation. WHo the hell is going to remember all this for a simple gant chart?
Ishmael Mboma (1 year ago)
thanks
thanks a lot
Hanna Thomas (1 year ago)
This really helped me! I was having a little panic because I couldn't get the chart to do what I wanted it to. Your voice was very calming and I figured it out right away after your video.
Stefan Alexander (1 year ago)
Why couldn't you have the excel document in the description box!
blueplanetable (1 year ago)
Much appreciated... Thank you for your efforts. It really helped...
Randy xorse (1 year ago)
Simple and easy to follow. Thanks.
Elmer Valladares (1 year ago)
This was very helpful in helping me create a project completion timeline which was something crucial that my boss ask me for. Thanks.
Nabin shah (1 year ago)
If you have to prepare chart from 2017 april 1st to 2018 april 1st
Glyn Vosges (1 year ago)
Awesome stuff
Edna Coleman (1 year ago)
Thank you.
Shin de los Reyes (1 year ago)
This is my life saver for my feasibility study! Thank you so much!!
baobao K (1 year ago)
hlepful! thx so much
Fabien Jack (1 year ago)
nice instructional vid
BeautifulAli1991 (1 year ago)
THANK YOU SO MUCH. THIS VIDEO WAS VERY HELP AND EASY TO FOLLOW
Tapiwa Gomwe (1 year ago)
thank you so much,this was really helpful !
Anton Mörike (1 year ago)
Thanks for your video, helped me a lot👍 Keep up
groeiendekaas (1 year ago)
i cant turn the fucking axis upside down :(
Sigurd Meyer-Hess (1 year ago)
Very helpful and excellent explanation.
Umer K (1 year ago)
Just cannot thank you enough for this great tutorial sir. Its very clear, concise and easy to understand. Thank you so very much.
Anal Queen (1 year ago)
Thanks, daddy
Kgomotso Mamunyani (1 year ago)
Very easy to follow explanation. Thank you!
ajam al-ayubi (1 year ago)
Thank you Sir.
Kiran tc (1 year ago)
thank you very much
Thanks..
Y.E. Ganesh (8 months ago)
I'd like to introduce a far more fine way please look at <https://goo.gl/yiFDBM>. I use a free trial version of Asprova, which is used by 2500 factories TOYOTA, Canon, Honda, YAMAHA, SONY, Haier, Bombardier, Foxconn, Bosch etc. It's so excellent production scheduler that is not cheap, but is free up to 250 tasks.
Andy Cordova (1 year ago)
why is my 22-May 42877 instead of 41416 it is messing my whole chart up when I get rid of the line spaces and my dates are a day behind his
Alain Latino (4 months ago)
It may have to do with the year you are using.
jacklyn15 (1 year ago)
You are superb!!!!!!!!!!!!!!!!!!!!!! This is too much. Thank you
so hopeful😥😥 #ganttchartnoobz
alex castro (1 year ago)
man, thnx a lot!! from a Chilean teacher!!
iSVG Gaming (1 year ago)
Wool
Medzter (1 year ago)
thankyou
Medzter (1 year ago)
im maaran btw
R Quig (1 year ago)
This video is fantastic. One of the best excel tutorials I've seen. You made this simple, easy to understand, and you walked through every step not assuming that viewers would automatically know what you were doing.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.