Making a Gantt Chart with Excel

[WhyteMageeq]

U are amazing. Just helped me finish my assignment. Thank u sir

[cpmsucks]

Thank you. You saved me a lot of time and did a great job with this video.

[JazzyCurtains]

Thank you very much. People like you make youtube a great learning tool.

[dakhac]

very useful! Thanks a lot!

[jadu1107]

thanx ,you got me 10 marks for my report

[soniastar23]

Thank you sooooooo much for putting this on you tube,ur a *star* Easy step by step guide, some differences on layout on my version of excel; but managed to figure it out. Well done!!

[swonderfulsue]

THANK YOU! I have a really hard time with this stuff and your video is SO helpful.

[julielamb2010]

No chart wizard in Excel 2010. :( boo.

[bilalminhas2]

@julielamb2010 im having the same problem right about now :( microsoft sucks!

[liljeetay]

thanks! very helpful!

[pglaudeky]

Excellent video. Clear and comprehensive. I was able to follow the instructions and create a Gantt chart in spite of using a newer version of Exel. Thank you very much.

[thesupernp]

Useful stuff! Cheers for sharing!

[kineticfestac]

ur a great guy!! thanks



[insumnia09]

How do you do that date sum thing? Teach me how to make one. =)

[Matziish]

Well done dudexx

[XDAdzXD]

How would i put two bars on one line, for example starting task 1, but going back to it on a later date, would mean two bars are present on one line. How would i be able to do that?

[NeilbeforeZod78]

excellent

[bhavtoshsharma]

good for basic users

[cone4944]

Thank you. I learned new tricks.

[3dwalkthroughstudio1]

Yantram a Architectural Rendering Studio - Architectural 3d Visualization Company offering services like 3d Rendering, render companies, 3D Renderings, Photorealistic design, Interior 3D Rendering, Conceptual 3D Rendering, 3d Renders, 3drandring design firms.

[dramseyno]

well done, thank you for posting.

[rjann168]

Thanks a lot! This is a great tutorial to save a lot of money in purchasing Gant plot software by using the existing EXCEL software.

[AOGUNS11]

Thank you SOoooooooooooooooooooo Much

[dimvoly]

What a great tutorial!

[khouchin10]

Thank you so much!!! I was required to make one of these for a class and had no idea what I was doing. You instruction completely helped even though I have a newer version of Excel. THANKS AGAIN!

[arnoldtan118]

You sire, deserve a nobel prize for saving computers from being smashed around the world.

[ameaninglessgesture]

Thank you so much for posting this video. It was very helpful and you explain very well.

[nikpel]

Wow. Can excel do this ? Very nice video.

[phihodge2020]

Very good tutorial, cheers. However i found that the method of working out the end date, meant that you were discounting the start date. The 1st plus 5 gave the 6th, when it should be the 5th. To counter act this just add another column after the duration called 'Durartion -1' and use a simple sum to minus 1 from the duration, continue as shown but use Duration-1 to calculate end dates. In order to maitain the look of the spreadsheet, right click on the column and click on hide.

hopethishelps

[dizzyink85]

Thankyou! That tutorial was so easy to follow! You are a life saver!

[Ganaijiulai]

You are my hero! This is exactly what I was searching for. And you also solved my "translating dates into numbers" problem. Thanks a million! :)

[amytexas85]

I use EasyProjectPlan

EasyProjectPlan. com

EasyProjectPlan is an Excel Gantt Chart that syncs with Outlook and Microsoft Project

[mpbrooks]

Thanks so much, so easy to follow and do!

[tommyd1258]

great help, many thanks

[MrFreeMinecraft]

when i saw this vid, there was an ad on the right for gant chart website called smartsheet.... trying it now it seems really good so far!

[amytexas85]

I use EasyProjectPlan

EasyProjectPlan is an Excel Gantt Chart that syncs with Outlook and Microsoft Project

[akuokay]

how to skip the weekends date/days on gantt chart?

[FictionFox]

Great tutorial! 

[Oliverdixon111]

Why in some parts of America do they put the date's the wrong way round?

It's Day/Month/Year (time correspond's)

Why??? Month/Day/Year??

So confusing.

[ssjpui]

@Oliverdixon111 Other countries use Month/Day/Year as well, nothing big.

[lloydbanksfan123]

thanks for this its really well explained, much better than the other videos on youtube

[SpoonPersonUstream]

LIFESAVER!!!!!

[Juniorthegr8]

Great video. Simplified and easy to follow. Couple of modifications needed for my version of Excel but I was still able to get the job done. 

[abubaby20]

Excellent, thank you sir.

[Igottafeelin7]

Can't Thank u enough!! i needed this and i've tried other ways but to no avail lol

[yaznb1]

Thanks Heaps, this really helped... Great instructional video, easy to understand & follow.

[mapo12]

Thank You!

[katsavakis]

thank you!! it helped me so much!! :)

[crazychoclateboy]

thanks it helped me a lot

[paul3292]

Good, concise demo of how to create a simple GANTT chart with Excel. If you don't own Project, this will work just fine.

[1Blackknight]

Thanks Buddy

[jaminacup]

thanks man ! i was just trying to learn about what the heck is a gantt chart ! :)

[TrickyBass]

Thanks, it helped me a lot to prepare my uni assignment.

[mu86neer]

THANK YOU

[BCMIke22]

Thanks for the help, I appreciate it!

[BCMIke22]

Thanks, I appreciate the help.

[philsays]

brilliant for students who dont want to purchase MS proj. cheers

[Some1HCH]

Tnx....!!!!!

it helped me big time...!!

[kattsie]

thank you so much this is great!

[Jrallen2030]

You are a savior! This stuff is easy to do if you know how to do it... I was stubbornly trying to figure this out for 30 mins before I looked for help and your vid explained it superbly in seconds. Thanks a ton!

[GreenZone03]

Super!

Load of thanks...

Like #690 ;)

[elnutjob]

You sir are the man!

[dominicmoss]

WHY??? Have you not heard of Microsoft Project - what takes you 6 minutes in your video could be achieved in less than 30 seconds in Microsoft Project.

[rrphillips]

@dominicmoss

Project is a great program, but a lot of students and businesses don't have this as it is is not a staple with MS Office. Project requires an extra purchase and then extra training. Many businesses will already have Excel and use it regularly. So, if someone can use what they've got without having to buy/learn something extra, I'm all for it.

[trossachs2003]

@rrphillips

Quite! That was an unhelpful comment. Most people have Excel. MS Project is quite expensive. A big cost if you only use it occasionally. I found this a nifty little trick.and will use it. ps there is something called OpenProject which is just like MS Project but it's free.

[abubaby20]

@rrphillips Excellent, thank you sir.

[jomogomo]

@dominicmoss

I sugest you visit Open Workbench site: as efficient as MS project, for free!

[xincgaro]

Excellent , Appreciated :)

[santonegra]

Utterly excellent vid

[Annergize]

How do you do it for weeks

[mxjtube]

Wow! Greate view!

[TheBbabes]

Thankyou so much this has helped me alot this was a huge part of my grade! :)

[BananaYanana]

thanks for the tutorial, really helpful! 

[ngkim22]

Wonderful!!!!!!!!!!

[Spirits1234]

Wow! Awesome! Thank you so much for sharing. Sexy voice btw!

[Radazy]

Really usefull Thanks you very much!!!!!

[vnakrani]

thank you so much...u really helped me in my assignments....

[LanceStriker]

Thank you very much for the helpful tips. This made my life so much easier!

[callanCarr6]

I had to watch this in lesson, useful

[baciandrio]

Thanks so much! I normally use Microsoft Project but I can definitely use this to create basic 'strawman' durations for bids.

[Glenhu123]

thanks alot of really appreaciate your video

[drlecter79]

I used this with OpenOfficeCalc 3.2.1, and it worked like a charm! Thanks a bunch!

[cooltinksin]

Thanks very much for your video on how to create a gantt chart. Is there a way to include a dynamic vertical "Today" line through this chart to reflect where we stand today in respect to the tasks. i saw your video using the rectangle which does something similar but I need a simple line through the chart. any help/feedback is appreciated. Thanks much in advance.

[atz93]

Thanks so much ! Just finished my last minute homework quicker than I expected !

[irmalusianatantri]

Thanks a lot ... like SUPER a lot... becoz of this i can made it in 1 hour .. spent no money to buy software or whatever book needed.. :D Thanks again..

[Alibubble]

Thanks heaps for this video, helped me tremendously!!! Great job!

[rentalcarexcess]

If you are looking for a simple to use, completed gantt chart template for excel 2007 and 2010. Take a look at chartgantt. ChartGantt has developed a solution using conditional formatting that enables instant change of view (day, week, month) and schedules all 4 dependency types.

[mruddhav]

Good job...keep it up...I don't understand why do we have 42 morons who disliked this??

[hwlim5441]

@mruddhav

Definitely agree with you~

[galaxy5saskue]

@mruddhav

they were probably forced to watch this in highschool engineering class like I was...

[jechtism]

@mruddhav simply because they dont have a clue what theyre watching..bunch of idiots. lol

[swapnil1991available]

@mruddhav  morons has grown to 45 ;P

[mruddhav]

@swapnil1991available lol...You see the number o morons never goes down and hence the world never gets better..:)

[sharelaugh]

@mruddhav maybe it was uploader's competitor to vote didlike

[crispen1151]

Awesome video!

[TheTitchbitch]

Very Good instructions - I even followed this using Excel 2007 version. Part of my assignment finished !

[JJtoob]

I know this chart is for projects where a task has one start time or date, and one end time or date. But I'm just curious, and please bear with me, I know it won't make sense, but just think outside the box for a minute: What if I wanted, let's say, task 1 to start and end, then at a later date, start and end again? Basically it would have a gap in the middle. The reason I ask is because I want to apply this method to a schedule with people's availability, so there are gaps for days off.

[fretboy67]

Awesome job! You have saved my assignment!

[mikem75]

Great job!

[ostmackan2]

nicely done

[tilirandle]

Excellent video!!! 5 stars!

[volound]

spelling fail.

[pmSoftwareBlog]

No software does better Gantt Chart than P2ware Planner Suite! Visit p2ware com to see more

[DeathKnightKiller]

@pmSoftwareBlog FU

[mudzan]

just briliant

[sunilrv16]

ghsghajh jbsjs

[patel5557600]

cheers really helped in my ict cousework

[garrysmoddudey]

im gonna create a bar chart lol

[999manxman]

very well explained 0 good tips >) thanks!

[tomatofuddy]

Thank you Philips, this made making a quick Gantt chart very easy.

[stremxala]

Nice work , very helpfull !! what can i do if my tasks are not continuous ??? what if my tasks are repeated every weekend?

[Deltatrek1]

Well Mr. Phillips.. What do I owe ya? THANKS!!!!

[randomgurn]

@Casanuda - I don't know, but I never use it. Just create a formula in another cell "=1*A1" (where A1 is the address of the cell containing the date). Alt, you can just change the cell's number format to "general". HTH.

[raduvlase]

Very very good...it was extremely helpful. Thank you very much

[MsNuralamsyah]

i also cannot find it but u may go to format..then click cell.after that, change the date to number..gudluck!!

[Casanuda]

Any chance someone could tell me where the numerical value button is in 2003? I cannot find it.

[MsNuralamsyah]

i also cannot find it but you may go to format..click cells..click number..and number..then click ok!

[FGIRojo]

Fantastic. Explained well

[rajeshpc]

Thanks, was really useful

[jammymum]

thank you

[envirosho]

Could not have done this without you thank you so much!

[kmorrow88]

Lots of help. Thanks.

[popat13]

Cheers, very helpful... took a little longer to follow using a Mac

[R44633V]

Very helpful video.

Thanks

[Thesilentmind]

Muchísimas gracias, me sirvió mucho!!!

[MarietteWentink]

thank you so much, I will try to use that for my Final Project for the Hotelschool The Hague

[salman3922]

Excellent

[dixiecup555]

Thank you for putting this up! It was great help and very easy to understand

[johanj81]

Hm this is okay. but this doesnt allow easy changes if a project tends to go of limits or you wanna make adjustments

[plasticfloor]

It's amazing to see this right after i watched "how to make a gantt in google docs".

They have a plugin that does all this for you automatically plus lets you add the valuable "%complete" colume that colors your progress etc. and you create it in seconds.

[smdhavan]

A brilliant way. Thank you very much.

[The7r00p3R]

Thnx. I needed to do a project for my mom, and she was pissing me off with this stuff.

I was like omfg I kent do that. D: <

And then I found your video. Nice job, rated 5/5.

^^

[png2001]

nice work. very useful.

[sam10a]

Excellent - really clear - thank you so much.

[aahsan100]

Excellent! Thanks for sharing.

[handymanstud]

excellent

[karatepirus]

Thanks alot. My Gannt chart kinda just went down the toilet, so hopefully this video will help me fix it! Cheers

[aaronlw]

Finally someone explained how to do this well. Thank you!

[Mensah9]

very helpful!!!!!!!!!!!

[numberonefan]

Thank you for this.. it was much help to me.. :)

[TheSTART2010]

Excellent job! Congrats.!

[chizzle123456789]

Niicee work very helpful

[sonia1313xxx]

Great video :)

[awhitf1]

Great video. Is there anyway you can show activities with multiple start/stop dates?

[brian4ca]

good question..would you mind sharing the answer if you've figured that out? Thanks!

[senoritamina]

very helpful thanx!

[moreload]

thank you very much very helpful

[mzlonsdale1209]

How do you get the green circle thing on the cursor ? I caan't get the thing to copy as you did in this video.

[Tombray]

VERY HELPFUL!!

[wAtOnCiNhO]

Brilliant video.

Amazing

Thanks!

[76dano]

ty si čisty kar... pozdravuje ta Alaboner Sifoner z FESRR, ty cigan :D romale cavale

[fourstatefav]

you need to show how to put in dependicies

[chriswebbbath]

brilliant, just what i needed. thanks

[Punjabilove1]

hey how are ya ??

i m gonna ask you a random question...you know how at 1:34 end dates were calculated by itself.. but when i try to do that in excel i get this "value" error.. do you know why i m getting that error ? please reply asap thanks in advance:)

[chriswebbbath]

hi,

im not entirely sure as I did mine with hours of one day rather than dates.

however i found that when i changed the number formats of the cells, everything got screwed up. keep all of your cells as 'Number' or 'General' under the Number format menu in the Home tab.

When i tried changing mine, everything went wrong till i changed it back

hope this helps :-)

[pgaynor2007]

Thanks - very helpful

[trevtrash]

I like your style easy listening...took it all in.... I am doing a construction site management degree asking for Gantt charts.