How to Make the BEST Gantt Chart in Excel (looks like Microsoft Project!) 

Thank you so much, you saving lives here Master!

Thank you so much for saving my life!

thanks so much!

do you know how i would adjust the formulas if i choose to show every day instead of every monday?

just huge respect man!

@@dwightPhoenix How and where?

I am stranded at the addition of ghantt bars. what could be doing wrong

@@nicholastugume1081 i managed to do that, but i am stucked at the diamond milestone

@@nicholastugume1081 same, my ghantt bar isnt visible even after applying the right formula. Some formatting in the later part is not working too. Can someone help - what may be going wrong ?

Mine are not working though. "problem with formula"

@@PatchedBanditI need to change “,” to “;” and worked for me. Hope you solve that problem.

😄😄😄💪

my thought exactly

I can't get any of the formulas to work, giving up. Wasted soooo much time trying. Will just buy a project software.

Amit do you mind sharing code for overdue items please?

p/s my team are IMPRESSED with this ganttchart for real !!!!!

That is amazing Linda, congratulations! You have conquered a very difficult task 🙂

@@davidmclachlanproject Hi David . Thanks for the video , was really helpful . How can I get this template please ? I tried creating it , but getting stuck at the end . Thanks 🙂

An hour, that's impressive! It took me about a week after work to figure out all the bits and pieces, so: time saved 🙂

@@davidmclachlanproject can you please give us the functions for day per day ?

​@@davidmclachlanprojecthey David I'm making this right now, an absolute beginner here. I just don't get how to like get that calender thingy. I mean the rows and columns size and height after I how to do that?

@@yourfatherofyourmother2035 Did you ever find out

It is the same example I requested now hope David give us a tutorial or a template to buy with that issue. I really need it for planning tasks!!!

👍

💀☠💀masterpiece comment. what a genius😏

bye

@@kelon_ good. stay away

Nice presentation

It took me 2 weeks, so you did well 😂

A2¹

Nice one! 👍

How to change if i want month

Hey Paul what cells do you apply this to?

I think you are asking about 2 consecutive calendar years: How do you sort by start dates if your project spands TWO years?

I agree. The point of using a tool like MS Project is for predecessors and successors and the whole scheduling engine. Also, summary tasks and other features for navigating a large project schedule. Not to mention resourcing features. Excel might be OK for a very simple task list but I can't imagine running an actual project without something like MS Project!

See my question about the FOUR types of dependencies.

I think how important this is depends on the size of the project, Many mini projects can and are managed on excel sheets manually and this automates some of the basic functions of laying out a chart. I find managing an ms project plan cumbersome in pretty much all but the most rigidly defined projects. Equally i often find faults in the ms-project scheduling engine that can put your entire plan out of kilter, meaning you up end spending more time getting your plan to behave correctly than you do actually delivering anything. In the kind of environments i manage manage projects in i need something that is quickly editable on the fly at a whim, without being to concerned with what impact changing one line may have on the rest of the plan. I can make notes against the cells in excel and cater for the dependencies later when i have time. Also in complex changing environments dependencies are always changing , and often things that you thought were dependencies turn out not to be and vica versa. In my experience having a plan that is a little looser in is restrictiveness can actually be helpful for a busy project manager.

@@danielbarnatt9332this has been my experience as well. Any MS project schedule I create is like a beautiful work of art on Day 1. But I’ve never successfully tracked progress in it. I’ve been developing a “task list” in excel that simply has tasks, estimated hours per task, and a “percent complete” cell, which drives 10 conditionally formatted cells that represent a “gas gauge” - how close to done the task is, From 1-10 Real life is always way more complicated than an MS project schedule. The fact that project doesn’t let me take notes anywhere on the screen just kills me. I’m reinvigorated with the idea of doing this in excel (and keeping it very simple) due to recently working with a very competent project manager who uses a white board and post-it notes. He doesn’t use a computer at all, let alone MS project. (And I just save the excel file with a new date in the filename each time, so I could always go back in time super easily if I ever wanted to…)

It took me two weeks to figure it all out and put it together, but I am not the fastest person 😂

Im a project manager and that chart is going to become part of my arsenal. Thank you!

Did you ever find out how to do this?

@@Safari_Secrets. no

I'm afraid it did not work for me to just copy paste the formula.

Problem solved :-) Human error from my side of course.

I get and error at ,2. Somehow formula loses D3 after that.

These are great ideas, certainly do-able 🙂

@@davidmclachlanproject David, glad you found my thoughts of interest. One more thought, in my domain, a milestone is a durationless event; I identify a milestone as an activity of zero duration: so start and end dates are the same. They usually come at the end of a sequence of activities that produce a work package or discrete component.

Would love to see this as well! Let me know if you found somewhere else to do this

that would be awsome, since the critical path is.. well.. CRITICAL in any project

Not yet but it's a good idea 🙂 Will get on it soon!

@David, answer please to this question

Do we already have an answer for this? 🙏

Instead of +7 change to +1

@@vcanadian1971 The conditional formatting formulas need to be changed as well.

Agree. Great video but for a beginner, formatting the cells went way too quickly.

You tube allows for playback down to 25% to 75% of normal.

Same place i got stuck because if I put the formular it gives me error. Did you find a way around it?

@@ibd991 yes. I found the solution. how about you?

@@chloehugaga2203can you please share it?

I agree…what formula would you recommend?

Great question, having the same issues.

Great question. Having the same issue.

The Gantt bar formulae need to be entered as Conditional Formatting rules. If you've created all the dates in row 4, and all the row data you are using in columns C to I, then you need to click on cell K6, then press Ctrl+Shift+End and it'll highlight the range of cells you are testing. Up on the Home menu, click Conditional Formatting, New Rule... then select the bottom rule type "Use a formula to determine which cells to format", enter the formula in the box below, set the Format... you want. Click OK, then Apply, then OK.

Great video, yes I am having the same issue - please help

Hey, did you get an answer or resolve yourself? I also can’t get the symbol to appear.

manually add the formula, also do the fancy thing formula he said right at the beginning when he just start adding the day and month e.g., 22-Sep

Work Around: I inserted a Column for Week Number for the End Date and used this formula =IF($G5-WEEKNUM(L$4)=0,"u"," ")

Work smarter not harder 😂😂😂

Try using " ; " instead of " , " That worked for me

One thought: if you're not using the "fancy" start date formula, make sure your project date starts on a Monday. This should work with the rest of the formulas!

@@davidmclachlanproject I tried changing the start date to Monday and it still doesn’t work. It’s a shame I really like to look at this chart but I can’t go any further. I spent a few hours designing this and now I can’t use it

I'm getting the same :(

same

He never responded did he? I'm stuck on the same thing.

I think that's where almost everyone got stuck...is he going to respond on it or not?

had the same but resolved it this way: Added a closing parenthesis for the WEEKDAY function before the +1 in the second argument. Changed the greater than or equal to sign (>=) to just the greater than sign (>) in the third argument.