How To...Create a Basic Gantt Chart in Excel 2010

[Rymdmumin]

Thank you! This was really useful! 

[whiteraven2000]

Thanks, great video :)

[greybeard6005]

useful video - thanks for posting.

[dandriv085]

Great video. Really useful. Thanks for posting.

[simia85]

At least i got to learn something new about Excel :)

[simia85]

Hey thanks for such a quick response. yea i knew MS Project was the program to do it, but i was having issues with getting it from my school. I was trying to find alternative options to get my homework done. But i was just now able to get MS Project. Thanks for the help!!

[simia85]

how do i make a network diagram of the gantt chart?

[eoloughlin]

Hi @simia85 - Excel is not the tool to use for a network diagram. MS Project would probably be better as it will do both Gantt and network diagram for you. You can do network diagrams in PowerPoint - check my channel for a "How To" video on this. E.

[heyyyoyoyo]

Thank you!!!!

[0strichPolicy]

Thanks!

[DishonMichael]

thank's a lot! you saved my life!

[KingSingh456]

@edsherojay23 No, it's not.

[Darkmanskin]

They're always after me lucky charms!

[TheBeliever97]

Do you know where I can find how to make a gantt chart on a mac? (with excel 2010)

[eoloughlin]

@TheBeliever97 Sorry no - I have not used a Mac in over 20 years!

[jojochip1]

Thank you very much!

[TheZakathouse]

Thank you. Very useful.

[ThLuckyOne]

Useful? Dude, this is WONDERFUL! PERFECT way to lay out the semester. Thank YOU for making this available! Love & Respect from USA to our beloved neighbors in Ireland!

[UtdMan4life]

very good

[Robbbin1]

Great video! Thank you so so much!

[jessminaaa]

This has really helped just an issue- the two colours of the bars have not turned up, there is no red just blue :(

[eoloughlin]

@jessminaaa I'm guessing this is happening at about the 2.00 minute mark of the video? When you select the "Duration" does this appear on the chart? It might look like the bars have been extended - if this is the case you should be able to right click on the extended bits and under the "Format" option you should be able to change to another colour. One other possibility - your data range on the horizontal axis might be so long, that small durations may be very difficult to see. Hope this helps.

[jaehattrick1]

Great introductory video.  Exactly what I needed to finish my report. Thank you!

[nevesyx]

thank goddddddddddddddd u save my life!!!!!

[csykes23]

FUCKING ACCENTS!!!

[lachie19940]

Thanks alot this help me to pass my assessment Task :D

[ikanmajimenagakusei]

thanks ^_^ this really helped me alot

[VesperSomerset]

This is extremely useful. I was able to throw together something on short notice which filled my needs and looked professional, thanks to your clear, instructive style. You have an excellent approach for showing step by step how to achieve the end product. Your red disk around your cursor was also hugely useful!

[nfsmwnfsc]

Very Helpful, thanks a lot.

[S0NiCCCCC]

fantastic explanation...brief and comprehensive...you really helped add something great to my research~

[serboiti11]

this was very helpful. I had to create one of these for a first year engineering project but we were never taught what it even is. This video allowed me to do it in about 15 minutes and it is nice to know that a real professor deems it to be acceptable :) thanks!

[bossplw]

Very Helpful, Thank You.

[MrPeacelover423]

Thanks a ton...Subbed to you..

[RubyRastaful]

Great video - so helpful. Is there any way to easily change the horizontal axis to months?

[eoloughlin]

@RubyRastaful First - thanks for watching my video and for your kind comment. You can change the format of your dates in the spreadsheet (select all dates-right click-Format Cells-choose type) by showing month only. This shows up as J for January, F for February, and so on. Your Gantt chart will automatically update to just show a letter for each date. Hope this helps. E.

[RubyRastaful]

@eoloughlin Thanks for your response. The dates I am using are specific days (i.e. 6/06/2011), however I would like the horizontal axis to be divided up according to month. When I try to format the date cells as you suggested there is no option to show month only. I also can't use the Major Unit in the axis options as months have diff days. I'm not sure I'm explaining this very well sorry. My chart will work regardless, but we group our data according to month so it would be easier to use.

[JohnRookWatters]

Thanks, you saved me countless hours of pouring over instructions to accomplish this!

[lgwhitefly]

Thank you!

[TubaCoventree]

Thank you for your precious time. it really helped me alot. Thank you very much.

[xmitch92x]

Thank you for this, saved me for this assignment!

[kat78681]

This is great. A very useful 6 minutes! Thanks for taking the time to create and post it.

[vassan08]

hi i found this very useful but i am having the same problem as @cuthberts11 regarding the dates. mine are also appearing on top of each other even though i have followed the steps minimum and major unit. please help

[eoloughlin]

@vassan08 The simplest way to resolve this is to make the chart wider. Click on the edge of the chart and drag it to the right or left until the days no longer overlap. Hope this works. E.

[LeroyJenkins4444]

How do you label the dates if your gantt chart runs for over one year?

[eoloughlin]

@LeroyJenkins4444 Each date, no matter what the year, still has a unique number. In my video all the dates are from 2009. The Chart should be able to handle dates running for over a year.

However, if you have a lot of dates your chart will get very cluttered as Excel tries to display date labels for 52 weeks. You may need to display months rather than weeks - in this case change the "Major Unit" from 7 days to 28 days.

Hope this works. E.

[trademark713]

Extremely helpful!...thank you so much!...

[sketchdisout]

Thanks was really stuck on how to create

[kraskata2012]

useful idea, but why didnt you just select the data first and then select the type of chart instead of vice versa. This could have saved you 3 minutes !

[eoloughlin]

@kraskata2012 Thanks for watching my video and for the feedback. I generally try to show things step-by-step so that it is easy for everybody to understand.

[kraskata2012]

@eoloughlin Ok, i get it :)

[samyboy551]

@eoloughlin it is inded makes is pretty easy and straight forward. using your tutorial I managed to create a gant chart for my Course work . God bless and Thank you.

[EstebanClarlosSwarez]

Your voice is sexy can I have your number?

[eoloughlin]

@EstebanClarlosSwarez Thank you for watching my videos and listening to my "sexy" voice. Good luck with your fashion show! (and no - you can't have my number).

[EstebanClarlosSwarez]

and BTW Brazil LOVE the Irish baby ;)

[EstebanClarlosSwarez]

Thanks for this... this has cery help me make a table of time for my fashion show :D

[Mofo1885]

Thanks very much. Very helpful..

[ShangoRaiden]

Thank you so much! This was so helpful, thank you!

[lisalonge]

Thank you very much. This helped tremendously.

[graha32]

Thanks!!



[soundtest123]

Thanks!!! =D



[SailorSam13]

This presentation was awesome. Thank you!

[Mysteria129]

Thanks!

[JT09AFC]

Thank you!!

[Hanshen2008]

Thank you very much, it help me alot in my assignment. Thank for your work.

[jef2907]

Thank you Mister, now I can finish my whole Project Management Assignment. Btw I am studying in University of College Dublin, but not in the Ireland.

[drofrey]

Thanks alot. i found it extremely useful

[Cuthberts11]

Thanks for the video. Very helpful. I just need help with one thing please..when you formatted the dates (4:44 minutes into video) using format cells mine come up under 'general' as sample number 40752 as my earliest date was 28-Jul so when i formatted the dates on chart and typed in 40752 as minimum and 7 as major unit and pressed close,.my dates all ended up on top of one another. I tried using the number you said in movie but that didnt work either? Help please

[viewtifulmoejoe]

Great help. Simple and straight to the point, the way we aussies like it. No boring B.S. Thank you

[Geremyfield]

Big help. Thanks from Oz

[TheTechop]

thanks helps when you want to share the sheet on google docs..

[Stopbeingfaggots]

Thank you good sir. A very informative and easy to follow video :)

[nestingdollgirl]

Thanks very much, this was very helpful. I do have a question, if you don't mind: Why didn't you just highlight all the data and then click Insert-->Bar chart-->Stacked Bar? It automatically creates the chart for you with all of the information input into the x and y axis. It seems like it would have cut out a lot of the initial steps you demonstrate.

[eoloughlin]

@nestingdollgirl Thanks for the tip. There are many ways to draw a Gantt Chart - mine is just one. When Microsoft bring out the next version of Office I'll be sure to try your idea. E.

[natibha]

thank you very much!! this video helped me a lot

[ausiedoc]

Thank you,

This is an excellent video. Well explained, comprehensive, informative and very useful. Saved me a lot of work.

[xgusROX]

Thank you, Sir.

[ddut887]

Excellent video. Excellent.

[mcoopergard]

You are wonderful. Thank you for doing this.

[dannyczd]

Thank you so much~~~

What a life saver~~~

[CandiceMcF]

Thank you so much! So appreciated!

[rvijh13]

Thank You...Your a life saver!



[aninoutski]

Thank You :)

[grecojones]

Excellent!

[yaShh13]

Thanks, this really helped! Life saver :)

[ChrisGeorgeWatson]

Thanks, very clear and easy to follow

[allangray2]

Thanks for the help!



[Azzhang412]

Thank you so much!

[DonNoypi]

Thanks so much. I know how to make one in excel 2003 but i had no idea how to do one for 2010. Very detailed and useful.

[aabelbey]

Thank you so much for your very informative and well done video! I had to create a Gantt chart for a research proposal, and I had no idea where to start until I stumbled upon your video! Thanks again! :)

[burningaquablue]

pretty helpful, thanks :)

[priyankshah605]

Very useful.. Thank you very much..

[betiferguson]

Incredibly useful! Thanks for making & posting the video

[donelettingyoudown]

Thank you for posting this! It was a big help on my homework :)

[rjdaredevil]

thanks a lot.