Gantt Chart in Excel - Create Gantt Chart in Easy Steps

This Gantt Chart Tutorial explains, how to make a Gantt Chart in Excel for any Project Plan. Gantt Chart can be used as Project Chart or Timeline chart in Project Management. We can use simple conditional formatting and simple formulas in excel to create Gantt chart template.
Let me know in comments, if you want formula, used in tutorial.

[@laracanjar2714]

Finally, someone who described this in a way that I could actually get this to work! Thank you!

[@ExcelDestination]

Welcome

[@sstotty5686]

Brilliant video, thank you very much!

[@agungk305]

Thank you Bro. Just the one I needed👍

[@tmdasan]

very use full, thank you.

[@ExcelDestination]

Your welcome

[@raulvasquez3368]

Thank you for the video it is very helpful. Is there a way to go beyond the one month

[@ExcelDestination]

Welcome

[@pravinkadhane8851]

Very nice video. I have a doubt, how we can plot the GANTT plot without date, suppose we can make three parts of one year and continuing it for next five year.

[@gregorylourens1696]

How to highlights holiday in gantt chart in excell

[@DanielAwulu]

Giant

[@sudiptakar8968]

Hello,
I need to mark Friday as holiday, It would be grateful if you help me to make this along with total days calculation rules as its taking 02 days as holiday where I want for 01 day.
Thanks for the nice post!!

[@ExcelDestination]

you can do that using workday function or networkdays function

[@raulvasquez3368]

Is there a way to make it a live moving gang chart where the old days Disappear from the screen and the new days appear to the right of the screen?

[@vkbb102]

HOW TO EXCLUDE THE HOLIDAYS IN THIS CHART

[@momotaro0410]

I used the same formula but it highlights the date as well. Why is that so?

[@vigneshkumar6770]

How can we reduce network day to 6 from 5

[@yordanosabraham6462]

What will happen if you put “0” on total days

[@corporateinitiatives80]

Can you add a formula for "almost due"?

[@ExcelDestination]

ok

[@sanjayTECH04]

HOW TO HIGHLIGHT FRIDAY SIR...PLEASE I AM BEGGINER

[@mdakumara]

HOW TO HIGHLIGHT FRIDAY SIR.

[@drraguramiahkulandaivel5841]

SIR PLEASE TEXT THE FORMULA

[@Shauryafunnyvlog]

Sir, I need to learn this formula

[@ExcelDestination]

Sorry he is no more

[@shivannahr780]

userform to table transfer data vba