Making a Gantt Chart in Excel 2007

[MultiHadouken06]

you F-ing saved my life!!!!!!

[ch3lseafc4eva]

Thank u very much, extremely helpful!

[da44e]

I can't make the dates to excel numbers because while pressing comma, it only adds a little space behind a specific date. Can anyone help me?

[da44e]

@da44e Fixed it. Had to write date format 2012-01-23 instead.

[greenbubba]

simple, straightforward, genius - thanks

[omshantiom76]

Thanks sooooooo much!! Your video might have saved my PhD :D

[gabydelagui]

thank u soo much!! =D it helped me a lot!

[brittonnick]

I love your tuts RR!

[MrPhilip089]

Fantastic explanation!!! Thank you ;-)

[bruiserbrez]

thank you for taking the time =)

[kathleenuel]

thank you.it helps me for creating my gantt chart !!

[tomashoyanger]

Extremely helpful. Thanks.

[pagalvin1]

im trying to change the dates in a gantt chart, i'm just traying to make the lenght of it 2 months longer but i cant get the dates to show up on the chart, it jus ends on a random date and does not show all the chart

[azntaegrl]

thaaaaaaaaank you! I was actually recommended by my professor to watch you so you're making a big impact on the lives of not-so-savvy Excel college users. xD

[Ingrishka]

Thank you



[Dataone22]

Extremely helpful..thanks for the video..

[jshedden16]

thanks for the help!

[TIPtvTI]

Cheers for the help mate, Great vid

[benbmyers]

Hi. Great video. One problem though, I'm creating a Gantt chart that goes on for around 3 months. As I need to use this chart in a report I need to have a smaller scale on the dates. As of now the chart displays the date every ten days and I was wondering if you know of a way to show the date more accurrately, such as every day. Thanks!

[benbmyers]

@benbmyers Never mind, got it!

[pagalvin1]

@benbmyers hey, i dont know how to do this but did you find out? i really need to sort this out or else the shit will be hitting the fan. please get back to me if you know/ thanks

[benbmyers]

@pagalvin1 Yeah I got it. Whilst in the 'Format Axis' for the dates, simply change the Major unit from 'Auto' to 'Fixed'. I changed it from 10 to 5.0, and that gave me a smaller scale and made the dates easier to read. After that I had to change the text to appear vertically because it was still too bunched together when horizontal. Hope this helps, if not give me another shout and I'll get back to you!

[pagalvin1]

@benbmyers thanks, that work perfect. do you know by any chance how to add in a line to show the end of a month or the end of a week? that would also be a great help

[benbmyers]

@pagalvin1 Sorry for the late reply. Eh I've had a look and I can't seem to figure out how to achieve this. I know you can label the Major Axis lines differently than the Minor Axis lines, so you can make them bold/different colour etc to make them stand out, however my scale shows every 5 days instead of every 7, so doing this would not make any sense. However I am going to try and make the scale every seven days, thanks for the idea and I'll get back to you if I can make it work!

[benbmyers]

@pagalvin1 p.s managed to get the scale to show each day of the week.

[360MandaloreX]

Thanks for the guide!

[Cryofinsomnia]

Thank you so much :D

[glovejoy]

Thank you very much this was amazingly helpful and easy to follow, if we ever meet I'm buying you a drink.

[arunwuppuluri]

Awsome ..U made my day !!

[TheKawowski]

thanks alot your a legend!!!

[jasbb2]

*throws roses at rrphillips feet* Thanks so much. I'm at work and I was wondering the best way to convey a schedule with overlapping action items!! Where do send the check?

[mcinhouse]

I can't thank you enough

[TheAnatomias2]

you are a hero man...

[FerixChanderson]

thanks for saving my day ...

[savagelucy1]

Thank you for making and posting this, very helpful.

[hicksiskool]

Love you bro!! This save my trouble.......

[erlingjos]

Muchas grax!!! amigo me sirvio de mucho tenes un 10!!! sigue asi suerte...

[shaz118]

Very Helpful- thank you. Your video is very much appreciated

[SanBkCity]

Gracias!

[sebgbc]

This just saved my life!!! Thank you so very much :-)

[djdubls]

Thanks for this video, very helpful!

[TheMsLKG]

wow thankyou so much this helped me with my project for my exam, would have failed without it! thankyouu :D

[jackip14]

Fantastic! A really easy to follow video! Thanks so much

A real help!

[lynnybabii23]

Thank you so much. You definitely have a gift for teaching!!

[TriniIndia]

VERY HELPFUL. THANK YOU SOOOOO MUCH!!!!!!!

[fcofelixx]

great tutorial, i even enjoy the sound of your keyboard

[limyw18]

Thank you so much for this @rrphillips and your clear explanations! This saved my life :')

[samuelflakeparry]

Good job thank you. That was very helpful.

[spe7vpv]

4:04 am and finally i found this

[blademasterz1]

<3 from me to you

now this part of my assignment is done thanks

[TheMelze]

This helped me alot :) Thank u



[anhreid1]

great ilustraion,

much appreciated

[nurulrul]

thank you! :D

[TheDocmillie]

thanks so much . this was amazingly helpful

[robert37026]

thank you it helped me but if you can then please give me some hints on project making in powerpoint

[joecaufield]

To exclude weekends from the end date calculation use =WORKDAY(B4,C4)

[slappersplatter]

THANKS THIS HELPED SOOO MUUCH

[maadari]

thank you! nice job

[Ipally2601I]

dude this video was fucking awesome. It was exactly what i needed! thanks a lot much appreciated.

[anquero79]

Thanks man...

[RonaldMoD]

What a waste of efford. There are severel free alternatives to MS Project (google this) that will produce this in no time. In this example with Excel you assume that people will work in there weekends...

[amytexas85]

I use EasyProjectPlan

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

[MaceTheBarrowsLord]

Thanks very much! :D

[bijoumik]

thank you!

[vickyviji]

thanks

=

[midhuunaziz]

this video has helped me a lot..... thank u very much frnd... :)

[Ryansoh12]

OMG

TY SO MUCH!!!!!!

dont have to copy my friends gantt chat

[albertine330]

thakyou!

[azzaXD]

THANK YOU!

[protothaca]

THANKS!



[LeonPass]

u have no idea how much this video help me . thank you

[amytexas85]

I use EasyProjectPlan

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

[XtycorcolaX]

you just saved my ass for my astronautical engineering class. its due in 5 hours haha

[eyeamskeletor]

I just used this for a presentation to our Board of Directors - thank you, thank you, thank you! Fahk!

[amishite]

this is great!

got me thinking though, you can make a little tweek and add...

DEPENDENT TASKS:

add a column b/w "start"+"duration" i.e. your "dependent start" ["ds"]

make your "end" = "duration"+"ds"

top "ds" cell = top "start" cell

2nd "ds" cell use the following =IF(B5>=E4,B5,E4)

that is: = if this "start" is greater than or equal to the previous "end", use this "start", otherwise use the previous "end"

that way you can never start until the previous task is done.

hope it helps someone!

[kramercp]

Great video. Very clear. Helped me build one in minutes.

[prue0210]

u added B4 to C4 .. i guess it should be 8/7/07...but rather than that it good

thanks man it helps :)

[GameOvai5]

Thank you very much for this video. It was very helpful, clear and thorough. Explained so well, I was able to produce a gant chant in 30 mins, whereas before with other tutorials I had spent 4/5 hours and got nowhere. Thanks again mate.

[tycearnol]

Disregard my last comment.... Turns out that it wasn't my computer with the problem it was the operator! HA!

Thanks

[tycearnol]

Can anyone tell me why my excel wont let me select the date value for the start date? It keeps telling me that my formula has an error but I have tried every type of date format I can use.

Any help would be great!

[levinalim]

Thanks!! This was really helpful.

[levinalim]

Thanks!! This was really helpful.

[cjbcastillo]

Thank you!! My project was saved.....

[steakfajitas]

thank yoooou so helpful

[MrVinceb]

Makes me look like I know what I'm doing in Excel! Thanks

[Shahbaz7371]

thank you very much, good guy

[NewKurDLanD]

Thanks you very much 

[hellomateyinnit]

ur a fucking hero

[SirFair1]

Haha, I feel stupid now :P

Thanks for the help, I have an assignment involving this :)

[gamesmaster124]

tytytytytytytytytytytytytytyty­

[puroShkodran]

Great video. Thanks

[xclmedia]

thank's, Excel Chart

from : xclmedia.com

[sleez0]

how do I get this for say 30 mins segments of meetings instead of full days? cheers

[ravensnut52]

youda youda man

[cozzeh86]

helped a lot - cheers.

[sleez0]

excellent thaks

[abubaby20]

Excellent, I was looking for this last one week, thank you sir.

[oldhighlandguy]

This was a big help to a project I am working on. I appreciate the video

[GreatAmericanMoneyTV]

This is a reeeeally cool video. Why can't I find you on Excelville? With skills like that, you should be getting paid!

[Booyeah10]

Why does my feed back says I "liked" this video when I haven't watched this video in my life? S:

[ScuderiaJabardos]

What an amazing video! Thank you very very much indeed! Really helpfull! Take care

[ScuderiaJabardos]

What an amazing video! Thank you very very much indeed! Really helpfull! Take care

[ZioTommy83]

thank you so much

you save my life with those instructions

have a good one

cheers

[LLUUCCiiAANNO]

man was this a help, last second business project for college lol procrastinations a bitch.

thank god for youtube

[tafino]

Hey, great vid... Question though: for the days, relating to the start date and the duration, doesn't simply adding them actually add one day to the task? Excel is adding x days to the start date assuming the start date is also a value. In other words, 8/1/07 plus 4 duration days is resulting in an end date of 8/5/11 when in reality it should be 8/4/11 given that 8/1/11 should be included as a duration day.

[tafino]

Hey, great vid... Question though: for the days, relating to the start date and the duration, doesn't simply adding them actually add one day to the task? Excel is adding x days to the start date assuming the start date is also a value. In other words, 8/1/07 plus 4 duration days is resulting in an end date of 8/5/11 when in reality it should be 8/4/11 given that 8/1/11 should be included as a duration day.

[rafiqepm]

well excellent thanks for uploading

[Mk4532ctr356]

Excellent :) Very well explained Sir ... !!

[jaatvedo]

Thanks a lot

[jaatvedo]

Thanks a lot ,

[Ryukyoto2]

Hey thanks so much for this video, really needed to make one of these for something and was ready to give up.

[infestedpeon]

Thanks a lot

[leox1118]

you the man!

[wellar6]

is there some way you can calculate the days between dates? i need an answer by tomorrow for my hsc major. thanks.

[pinkolive2010]

thanks so much for the help, your video was great and now i understand, please do a updated format for the Gantt Chart with cost management if you can, thanks

[MagicMissile17]

Thanks, this was really helpful and easy to follow.

[slimtunks]

Thank you very much. Awesome but any idea on how I can create a network diagram using the same information, I don't have a PM application. Please advise. Thanks

[kellytrios]

You are a blessing in disguise! I have an assignment due and had to prepare this 2nite, i had no prior idea about gantt chart, but u made it so easy for me. Thanks. I owe you one!! ;)

[paulwieczorek]

Is it possible to create a Gantt chart for projects that do not include weekends when displaying task durations? i.e. Saturday and Sunday are shown but are excluded from the task duration. Thanks.

[richmancool]

YOU HAVE MADE MY WILDEST DREAMS COME TRUE

[Naddibabe]

hi, thank you for your video. What if the date is 1/1/1700? Excel doesn't allow me to convert it into a comma. it doesn't go lower than 1900. Can you please advise me.

Thanks. My Start date should be 1/1/1700 and my end date present. Is there a trick?

[RattlerXA]

Yo Do you wanna learn Excel like an expert?

go to this video.

/watch?v=FG3CboG8HVE

[vinafc]

Thank you, very clear and easy to follow. Excellent work.

[NightwingGurl]

Thank you so much! This was very much helpful! =D

[mcgee130]

cheers

[salfetka]

great tutorial mate

well explained

[khayyam3872]

thanx man :)

[okeefe1979]

This gantt chart is incomplete. It should indicate which tasks are dependent on the completion of others. Is this possible in excel?

[rrphillips]

@okeefe1979 No real slick way to show the task dependencies in Excel. That's where a project management application is best.

[191WildHorse]

@rrphillips , @okeefe1979 If you want task 2 depend of finishing of Task 1, Just Formulate the B5 ( start date of project 1) = D4 ( End date of task 1) . ( and so on for other dependent) So by doing this, you automatically update the whole project. Even with deplay, u can have delay in seperate colume. Play around with excel.

[brewskhee]

@okeefe1979

Try OpenProj, it's free but it does have some limitations.

[xlc88]

You are a life saver! Thank you for such an informative video!

[youpooter]

wow, i can't count how many times i did a static gantt chart excel !!

you can also use a free project mgt tool that will make very easily a dynamic chart for you, then you can export it to Excel, PPT, etc...

Check out Projelead (open source and web based)

[youpooter]

klgljg

[TheCapitanSantos]

Fantastic video.

Thank you so much for helping me out!

[TheWolfmanG]

You just saved me... you have no idea. Thanks!

[passivenexus]

WOOT! THANK YOU SO MUCH!

[k17k23]

Thanks!!! Very helpful....

[benishah]

Thanks a lot !! I think this really helps out when you don't have microsoft project....:):)

[pumpbreaks]

OMG JUST CUM

[SpreadsheetTutorials]

Wow that was REALLY sharp. I was very impressed with the technique you used to hide the first series of data bars. I could not have done it better myself, but maybe I can write a VBA macro to do a lot of it automatically :)

[fuschia231]

Really Great Video!!! Thank You for your help!

[nancysmith23]

Very helpful indeed, thank you!

[nancysmith23]

Very helpful indeed, thank you!

[Commenter866]

how do you name the y axis or x axis?

[saraxk]

This has been very useful! BUT I'm having one little problem... I have 12 tasks, and when i select data to include all my tasks - it won't include my last task in the Gantt graph (all tasks appear apart from task 12). Can you help??

Thanks! 

[wesleyc38]

Hi, My gantt chart is in months, how do i calculate the end date with that?

[rubbersoul420]

nice, very nice....

[Aasmundar]

Thank you very much. :)

[Abrilariel]

Beautiful, It is true!!!

[DCecil21]

RRPHILLIPS! THANK YOU FOR POSING THIS! YOU ARE THE MAN 1,000%!! KUDOS AND PROPS TO YOU!!

[smithjt1]

soooo helpful!

[larryteoh]

may i know wat program u used to do the recording? i love the zoom in and out feature. camstudio can't do tat.. :(

[rrphillips]

@larryteoh I use Camtasia Studio, by Techsmith

[larryteoh]

@rrphillips icc.. thanks for the info.. i'll check it out!

[jwneuend]

@larryteoh Hello.  Yes, Camtasia Studio can zoom and pan.

[iScvot]

thank u so muuuch!!

[coymelody]

Thank you so much, you are absolutely amazing!!!

[midwinterphoto]

Good video, but I wish you had explained the keyboard shortcuts you were using.

[FazWardak88]

awsome

very clear explaination. thanks

[PajamaPenguins]

That was an excellent tutorial with thorough and clear explanation.

It saved me so much time! Thank you so much!

[PAP4BEAR]

I love you man!

[ctutky]

thank you very much for your detail explanation

[jacobotueme]

What happen if i need to repeat the task in a diferent time? how can i do it?

[leecl08]

thanks~ it's really helpful!

[t0v3]

Great tutorial, it's helped me with my system analysis project. Many thanks.