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

👍 Ready made and ready to use.

How to make the absolute BEST weekly Gantt Chart in Excel, that looks like Microsoft Project and is easier and better to use! Your managers and team will ask you "Where did you get this from?" and "Can I use it?" because it looks so good when you're updating your project.

Features include: milestone diamonds, automatic Gantt chart bars, automatic counting number of working days, automatic percent complete on Gantt bars, coloured bars for complete tasks and for blocked tasks, and automatic calendar.

Timestamps:
00:00 Gantt Chart overview
01:53 Getting Started
02:31 Creating the Calendar
05:26 Adding lines and borders
06:40 Number of Working Days
07:24 Status drop down list
09:21 Adding milestone diamonds
10:27 Adding the Gantt bars
12:33 Adding the percentage complete on the bars
13:12 Adding the complete golden colour
14:03 Showing blocked items
15:12 Freeze panes for scrolling

#ProjectManagement

[trustedconsultingllc]

David, you're a natural born teacher. Very much appreciate your positive and encouraging tutorial on how to do these things for yourself.

[j.c.]

Here is the DAX for the video.
Top row dates: =IF(MONTH(D3-WEEKDAY((D3), 2)+1)<MONTH(D3), (D3-28-DAY(D3)+7)-WEEKDAY((D3-DAY(D3)+7), 2)+1, (D3-DAY(D3)+7)-WEEKDAY((D3-DAY(D3)+7), 2)+1)
Calculating active days: =IF(F6="", "", NETWORKDAYS(E6, F6)),
Conditional formatting below.
Current day line: =K$4=(TODAY()-WEEKDAY(TODAY(), 2)+1)
Project due date: =AND(K$4>=$E6-(WEEKDAY($E6, 2)+1), K$4<=$F6)
Project progress to date: =AND($I6>0, K$4<=($E6+($F6-$E6)*$I6)-WEEKDAY(($E6+($F6-$E6)*$I6), 2)+1, K$4>=$E6-WEEKDAY($E6, 2)+1)
Completed: =AND($H6="Complete", K$4=$F6-WEEKDAY($F6, 2)+1)
Blocked: =AND($H6="Blocked", $I6>0, K$4<=($E6+($F6-$E6)*$I6)-WEEKDAY(($E6+($F6-$E6)*$I6), 2)+1, K$4>=$E6-WEEKDAY($E6, 2)+1)

Hope this saves future viewers some time!

[derekmurray]

Took me a bit longer than 15 minutes to get the hang of it. Wish I had read these comments beforehand and noticed somebody was kind enough to drop all the Excel formulae.
Well worth the effort though. This is a great tool.

[DubseditionTCG]

I can honestly say, my team was impressed when I whipped this out to present the other day

[jaredbarber]

This video is fantastic and the presenter does an amazing job. David's enthusiasm is infectious and I honestly had fun making a Gantt chart for my project - never thought I'd say that!

[carolinewarren]

Thank you, David, for an (almost) idiot-proof tutorial on creating a customized Gantt chart. It took me about 4 hours, but I'm thrilled with the result, and the fact that I can use this template for other projects in the future. Many, many thanks for your help!

[shreyapandey]

Simply amazing! I had no idea excel sheets could look so aesthetic. You've completely changed my life, this Gantt chart is a game-changer!

[meaningofmovementpodcast]

This is a straight-up amazing walkthrough on how to create a well functioning Gantt Chart. Thanks so much for sharing, it will be put to great use!

[mikekennedy]

Thanks David, this is one of the best tutorials available for Gantt Chart creation and Conditional Formatting

[Simon-jgqf]

Thank you David, this is incredibly useful as I am a civil engineering student at a university that does not provide access to MS Project regardless of the crazy fees that I'm paying 🤣

[simondavis]

I'm currently undergoing a Site Management course. I've been banging my head against the wall trying all sorts of formulas to get this right. This is by-far one of the best examples of a self-build Gantt Chart, and has become indispensable to me! Many Thanks, David!

P.S. I've managed to manipulate a formula to introduce and over run on any particular task! Again Thanks David!

[kasperraunholst]

Such contageous enthusiasm. I love how a square becomes "a beautiful diamond". Thanks a lot for making this one.

[hamodeosso]

Hands down the most straight forward and visually appearing GANTT chart

[hettardsplat]

Fantastic step by step! Some of the bits went a little quickly so a LOT! of pausing and repalying but I now have an amazing Gantt chart to use across multiple projects! well worth the time invested.

One suggestion would be to post the different formulas in the description to make it easier and save a LOT of typing and re-typing when things go wrong.

[martin]

Your positivity has made excel bearable for me. Thank you

[ejvideos]

Oh my Lord !! This changes everything I do at work. I thought the answer was to use Charts, but this is so much better. Thank you.

[Sali]

Absolutely amazing and much needed, I was looking for some advanced Gantt chart for. months, and here I got it, many thanks, considering buying your template, looking for some discount !

[chantellelavie]

Excellent tutorial! Exactly what I was looking for. Thank you for taking the time to create and share it.

[laielatolentino]

Finally got the hang of it, many many thanks, super worth having spent my 5 hours with you...All the very best and hope for more videos to come :)

[heshamhamoodalshaif]

Amazing, thank you! You taught me more in 16 minutes than my prof did in 4 weeks!