How to make Gantt Chart in Excel

A Gantt chart is a type of bar chart that illustrates a project schedule, named after its inventor, Henry Gantt.
You normally make a Gantt chart to organize and spread out your task in a graphical way so it is easy to see for each task, its start date and the end date in the form of a bar. This gives a very easy overview of the future tasks in one place.
It is very easy to make a Gantt chart in Excel. All you need is a start date for each task and the duration of each task and leave the rest to Excel.

[pushpakkothekar]

There is always some Indian dude helping out with computer-related stuff. Thanks, Man.

[adamfreden]

I have some projects that do not have dates yet, so the chart creates dates as far back as the year 1900, which shows the project as tiny blips.

I had to fix that by selecting the dat axis at the bottom, right-click "Format axis", go to the "Format axis" tab (looks like a graph - the right-most one after "Fill & line", "Effects", and "Size and Properties"), expand "Axis Options", and in the "Bounds" --> "Minimum" value I put a recent date - "1/1/2023". Then it showed up fine.

This was great! Thanks so much!

[euandelaney]

Mate you are an absolute legend, will be praying for your good health you studmuffin. May Allah grant you eternal passage through the gates of heaven on the prophets shoulders

[ReggieWhite]

This is one of the best for beginner Gantt chart creators. Would love to see more complex scenarios going forward.

[abundantrain]

YOU THE thank you so much for your help!!! This is a quick way to generate a Gantt Chart with decimal values, and so neat as well! 😄🎉🙌

[traceywilliamson]

This is such a good tutorial for people who are not familiar with using excel. Very easy to follow and really well explained. Thank you so much :)

[Antonianapoli]

wow!! thank you so much, i struggled so hard to make this, watched about 7 videos until i found this video!! youre the best man

[RefinerSimilitude]

This was so much easier to follow than the pdf provided by the class! Thank you!

[MurilloProenca]

Easy and simple, thank you very much!

[masudcseku]

Surprisingly simple way of doing Gantt chart, great work!

[raziaaga]

Very well explained. Looks like a piece of cake to make a Gantt Chart now. Thank you so much

[moumitadeb]

Excellent video ! I learnt how to make the chart from scratch you

[chididavid-onuoha]

Thanks for the video. it was easy to follow and understand. did my first Gantt chart learning from the video

[tia]

Very concise and easy to apply. Thank you so much.

[narayanbhat]

This is very good tutorial . thank you very much.

[jyoungjyoung]

this is an amazing tutorial, thank you! your presentation was perfect and so easy to follow. <3

[c.enrique]

Best video ever about this topic !!! Thank you so much.

[QueenBabbz]

Thank you so much! This was very helpful and easy to understand. Much appreciated!

[nyikomhlarhimusic]

Thank you very much for this awesome lesson.

[stevenxowens]

Fantastic Tutorial. Thank you so much!