Easy Excel Gantt Charts - Perfect for Project Management

In this video I’m going to show you how easy it is to build Gantt charts in Excel using Conditional Formatting. We’ll also look at how we can highlight tasks that are overdue and the current date.
Note: the formula in column F should be: =IF(ISBLANK(B5),"",WORKDAY.INTL(B5-1,C5,1))
Download the completed Excel file here: bit.ly/3xKbYYF
Conditional Formatting with Formulas Explained: • Conditional Formatting...
View my comprehensive courses: www.myonlinetraininghub.com/
Connect with me on LinkedIn: / myndatreacy
0:00 Excel Gantt Chart uses
0:22 Setting up for Gantt Charts in Excel
0:59 Calculating the Completion Date using WORKDAY.INTL
1:59 Gantt Chart Conditonal Formatting Rules
4:44 Highlight Overdue Tasks
6:19 Highlight the C urrent Date
7:08 Troubleshooting Conditional Formats

[@Chiddu_Chingari298]

Hi Mynda, truly amazing!!👌🏻 Thank you so much for this video on Gantt Charts. Really means a lot to me. You're really helping many professionals like me to develop ourselves, gain knowledge & explore more. Take care & stay blessed.

[@MyOnlineTrainingHub]

Thanks for your kind words 🙏

[@IvanCortinas_ES]

Good approach to conditional formatting in a Gantt chart. Thank you very much Mynda. The issues of the channel are very practical.

[@MyOnlineTrainingHub]

Glad you like them!

[@rigobertogarcia]

Excellent as always, Mynda. Thank you very much for sharing such valuable knowledge that results in a profound improvement of our professional development.

[@MyOnlineTrainingHub]

You are so welcome!

[@MohammadArifRahim]

I had used this technique before. But yours have lots of layers. Thanks for sharing. Loved it.

[@MyOnlineTrainingHub]

Awesome! Thank you!

[@davidlinton4127]

Great stuff, thanks Mynda!

[@MyOnlineTrainingHub]

My pleasure!

[@giulianopierucci2903]

Excellent Mynda! Thank you!

[@MyOnlineTrainingHub]

Glad you liked it 😊

[@chrism9037]

Thanks Mynda! I've used something similar before but I like yours a bit better.

[@MyOnlineTrainingHub]

Glad you liked it, Chris!

[@RandyMcNeil2]

Was all set to see the use of dependencies on tasks and the effects of a change or delay of one item and how it affected the rest. But for a standard training representation of how to format using conditional data in a real life gant chart, this was very good

[@MyOnlineTrainingHub]

Glad it was helpful 😊

[@andriikulishov3371]

Dear Mynda, it looks absolutely fantastic! Would use that at work.

[@MyOnlineTrainingHub]

Great to hear!

[@c.s.m.k5737]

Very Cool. Enjoyed this example for project management visualization

[@MyOnlineTrainingHub]

Great to hear! You'll love my Project Management Dashboard then: kzbin.info/www/bejne/jIaXn5Z4h5WDj9k

[@darrylmorgan]

Hi Mynda!Really Great Tutorial,Will Definitely Be Trying This Cool Technique Out...Thank You :)

[@MyOnlineTrainingHub]

Great to hear, Darryl!

[@brianwied3702]

Great tutorial, this is better than buying MS Project and it integrates better into program management dashboards.

[@MyOnlineTrainingHub]

Glad it was helpful!

[@yahyaalsulaiman9705]

u re awesome and really appreciate that you are sharing such brilliant knowledge... you always make my day

[@MyOnlineTrainingHub]

Thank you so much 😀

[@nadermounir8228]

Thank you for this great tutorial

[@MyOnlineTrainingHub]

You're very welcome!

[@GingerMan2342]

Excellent video as always - thanks! I wish Excel allowed you to create names for conditional formatting rules - it would be so much easier to understand what potentially complex formulae are doing if instead of seeing the formula in the manage rules dialogue, you saw a user defined name that described the result of the formula.

[@MyOnlineTrainingHub]

Yes, Names would be helpful indeed!

[@Fredick.7]

🙂...Genial, gracias por compartir estos muy interesantes aportes. Me suscribí desde que vi tu primer video ....👍

[@MyOnlineTrainingHub]

Mucho gracias!

[@fjrxj1134]

Amazing, many thanks just want I needed.

[@MyOnlineTrainingHub]

Glad it helped!

[@Steve157Oh]

Ooooh - this looks very useful. I use MSP a lot but it's not easy to read if you're not a regular user; these charts are a lot more accessible.

[@MyOnlineTrainingHub]

Great to hear, Steve!

[@dragonkungfu19901991]

your videos help me a lot thank you very much. I also share your videos to collegues also. You are very talented.

[@MyOnlineTrainingHub]

Thanks so much for your support 🙏

[@szadzik53]

Wonderful. Very useful tutorial.

[@MyOnlineTrainingHub]

Thank you! Cheers!

[@arbazahmad7177]

Great and easy to make 👌 Thanks

[@MyOnlineTrainingHub]

Great to hear!

[@ibugurudyah]

Thank you, it's very useful...

[@MyOnlineTrainingHub]

Glad to hear that 😊

[@adamchmielewski61]

I have a slightly different technique. Instead of having the logic in the conditional formatting I have it all in the formulas. And the result is a number (1,2,3) or a short text (ok,x,bad) with the status and an empty string if nothing. And then I apply the conditional formatting to the value (e.g. if value = 2 then font and background green) Thanks to that I can use other formulas (like countif) to reference this. Like count the number of overdue days etc. But with what you gave, it’s easier to change the priority of colours and give comments directly in the cells.

[@MyOnlineTrainingHub]

Nice idea, Adam. I can see that being useful if you need to count results.

[@christopherjohndavis5882]

Hi Mynda, I came across your videos on KZbin and think they are brilliant. I am trying to build a maintenance schedule and have a start date but in some cases the maintenance can be fortnightly, monthly, quarterly, 6 monthly and annual depending on the task. I assume that this is something similar to a Gantt chart. do you have a tutorial that you can point me to please and thankyou for everything so far Love it.

[@MyOnlineTrainingHub]

Glad you've found my tutorials helpful 🙏 I don't have anything like you describe, but if you get stuck implementing it, you're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@colinwheatley387]

Great video Mynda, however, is there a week function rather than days? Just so you can compress the Gantt field of view..

[@MyOnlineTrainingHub]

Not a week function as such, but you can change the formula to calculate based on weeks. I don't have an example file, but you can post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@magsarjavbolor5305]

Hi Mynda. Thank you for all that you do. It was very helpful! Could you tell me the way that we can highlight the task in column A? 😬

[@MyOnlineTrainingHub]

Glad you found it helpful. Not sure what the conditions are for highlighting a task. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@magsarjavbolor5305]

Condition is the same as the one that you did on the video 😬 if the task is overdue, i want that task to be highlighted as well.

[@MyOnlineTrainingHub]

I don't have time to do it right now, but this video teaches you how to write conditional formatting formulas: kzbin.info/www/bejne/iKvdaoOvm9ycjLM

[@karlamartin123]

Hello, do you have a video or tutorial on how to set up task dependencies within an excel worksheet?

[@MyOnlineTrainingHub]

No, I don't sorry.

[@srizki]

Thank you Mynda, I learned a lot from your videos. I have a question, why did you use 'isblanck", instead of =IF(B5 = " ", " ", ....

[@MyOnlineTrainingHub]

Great to hear 🙏 No reason for using ISBLANK instead of ="" Use whichever you prefer.

[@srizki]

@@MyOnlineTrainingHub Thank you, Mynda.

[@vivekanandareddy1134]

AND(ISNUMBER(B2),LEFT(CELL("format",B2),1)="D") I am using this formula as conditional for to restrict data other than date. But the thing is that this condition is not working online mode, it shows an error. So can you help me on this. I want to restrict a column to enter date only.

[@MyOnlineTrainingHub]

The CELL function isn't available online. I'm not sure how you could do this another way off the top of my head, but if you post your question and sample Excel file on our forum we can help you further: www.myonlinetraininghub.com/excel-forum

[@mt3690]

Hello Mynda, I am having trouble for the formula if my completed days are in the same column as the estimated days since I want to show to bar graph for estimated and completed in parallel. Thank you in advance.

[@MyOnlineTrainingHub]

I recommend you separate the completed days and estimated days into separate columns to facilitate the graph.

[@kletops46]

Wait.. what was that 'Double-Click' thing to Auto enter all the formatting data ?

[@MyOnlineTrainingHub]

Not sure at which point you mean, but I probably covered it in my double click tips video: kzbin.info/www/bejne/earYnXZ5gb14m8U

[@kletops46]

@@MyOnlineTrainingHub @ 01:58... I'll search for your Double Click tips. Thanks

[@MyOnlineTrainingHub]

Ah, that's double clicking the fill handle in the bottom right of the cell to copy down the formula. I still recommend watching my double click tips video linked to in my comment above though 😊

[@Jakeu1701]

the portion of the first formula will return the false condition every time. Simple example: =IF(ISBLANK(A2)="","True", "False") is incorrect. To have the formula work correctly, it should read =IF(ISBLANK(A3),"True", "False")

[@MyOnlineTrainingHub]

oops, yes I had a moment writing that formula! I think originally I had =IF(B5="",... and then decided to use ISBLANK but forgot to remove the ="" part. In my written tutorial I have: =IF(ISBLANK(B5),"",WORKDAY.INTL(B5-1,D5+E5,1))

[@Jakeu1701]

@@MyOnlineTrainingHub no worries. I use isblank all the time and noticed it. I pulled up Excel and tried it because I don't know everything and I've seen some formulas done differently than I would write them. Thanks for the reply. I like your videos and recommend them to others. Keep up the good work.

[@ibugurudyah]

Amazing

[@brightdaniel1830]

God bless, first to Comment

[@MyOnlineTrainingHub]

Thanks for watching!

[@brightdaniel1830]

Blessings from Nigeria

[@ibugurudyah]

@@brightdaniel1830 well

[@brightdaniel1830]

@Dyah Hastuti, greetings

[@laimajanaudite2141]

I'm having issues with the formula. I put everything in however it doesn't highlight anything. Please help 🥺

[@MyOnlineTrainingHub]

Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@MiRofek]

Not useful at all... (just kidding). Excellent tutorial (as always) 😊

[@MyOnlineTrainingHub]

😁 phew! Glad you liked it.

[@daisypowell2555]

Hello Mynda, I've created a Gantt Chart, however, i have a problem in the formula [=IF(H16>=1, WORKDAY.INTL(I16, INT(H16), "0000011") + IF(MOD(H16,(INT(H16)))>=1, TIME(12, 0, 0), 0), WORKDAY.INTL(I16, INT(H16), "0000011") + IF(H16>=1, TIME(12, 0, 0), 0))]. Here the Col. H is duration, Col. I start date, end date is calculated in Col. J. Now the issue is when the task requires 1 day to complete instead of the output result being the same day, it is taking an extra day and resulting in the next day as end date. I need the end date to be the same day, similarly if the task requires 2 days and the start day falls on a Friday, the end date should be the following Monday, which excludes the weekends. Pls help

[@MyOnlineTrainingHub]

Please post your question and Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum