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.

[@euandelaney4319]

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

[@ReggieWhite15]

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

[@innovative_learner]

Thank you very much 😊.

[@gordonresquer4604]

@@innovative_learner , sir if I change the column tasks to Employee and start / end date to start / end TIMES (to reflect duration of a job assignment during the day) as an example, could I have. Employee1 have several job assignments/tasks on one line?

[@chipossikwati2054]

Best Gantt chart tutorials I’ve seen

[@raziaaga1652]

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

[@adamfreden2267]

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!

[@traceywilliamson7179]

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 :)

[@innovative_learner]

Thank you very much.

[@moumitadeb9337]

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

[@MurilloProenca]

Easy and simple, thank you very much!

[@RefinerSimilitude]

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

[@innovative_learner]

Thank you very much. You might also like my other new video on Gantt chart at czcams.com/video/9eqXYNgtIAA/video.html

[@c.enrique9716]

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

[@masudcseku]

Surprisingly simple way of doing Gantt chart, great work!

[@innovative_learner]

Thanks :-)

[@aprilhartzel-lewis3783]

I've watched several videos for help with Gantt charts and yours was the first that I was actually able to follow and apply. Thank you!

[@innovative_learner]

Thank you very much. It's a pleasure for me to hear my video was helpful for you.

[@abundantrain7782]

YOU THE MAAAAAN, 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! 😄🎉🙌

[@sellingouts3022]

Thank you very much

[@innovative_learner]

Thank you very much

[@tshepochokoe2003]

Amazing video! Now I can do my project planning properly.

[@chididavid-onuoha4309]

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

[@tia3222]

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

[@innovative_learner]

You are welcome. Thank you very much.

[@pushpakkothekar9271]

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

[@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

[@innovative_learner]

Thank you very much. Please subscribe, share and like...

[@stevenxowens792]

Fantastic Tutorial. Thank you so much!

[@Cloudkiker97]

this SAVED ME, thank you senpai

[@copains5]

Thank you so much! This is the best one I found!😀

[@jyoungjyoung1701]

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

[@innovative_learner]

Thank you very much. You might also like my other new video on Gantt chart at czcams.com/video/9eqXYNgtIAA/video.html

[@QueenBabbz]

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

[@innovative_learner]

Thank you very much

[@willeggleton6516]

you are an absolute genius !!

[@Machiuka]

Very informative tutorial. Thank you for sharing.

[@nadiarostami7857]

Very good tutorial! Thank you so much.

[@nyikomhlarhimusic]

Thank you very much for this awesome lesson.

[@innovative_learner]

Thank you very much 😊

[@raghuj8163]

Very nice, crisp and clear. Thanks a ton

[@innovative_learner]

Thank you very much.

[@venoriillukthanna3199]

Very well explained. Thank you☺️

[@josephinegondwe8590]

thank you. this video is really helpful and easy to follow. kudos

[@shadeoyebode2249]

Thank you! Found this very helpful

[@sudheer0909]

Implemented and learnt new things as well...Good job and keep them coming !!!

[@chiedozieogbuagu4315]

Thank you very much. It was simple and less ambiguous.

[@nursyahirah9020]

really great video!!done my assignment just in few minutes!!

[@innovative_learner]

Thank you very much 😊

[@2Fast2Furious4U]

Wow man, you are one creative genius. Thank you.

[@innovative_learner]

Thank you so much

[@UnderSix1]

The best explanation🤘🏼🤘🏼

[@Samisami-tq1gr]

Awesome explanation..Thank you so much.. Found it very useful✨

[@josephpedrofabila6964]

Awesome. Thanks. The bottom horizontal bar also needs the data to entered in reverse order. How do you do that?

[@sunshinemannod1186]

HELPFUL. Thanks!

[@morrismashike8330]

straight to the point you saved me... Thank you!! Consider me a subscriber cant wait to check out more of ur content

[@innovative_learner]

Thank you very much

[@arafama52]

THANK YOU !! This was veryyyy helpful!

[@innovative_learner]

Thank you very much.

[@sangeetajadhav5491]

try bb yyyyyyuû

[@Daarn1]

You're a life saver bro🤜🤛

[@hoamichim7349]

Thanks man! Very useful!

[@innovative_learner]

Thanks. Pls subscribe to support my channel.

[@narayanbhat2483]

This is very good tutorial . thank you very much.

[@innovative_learner]

Thank you very much.

[@jolleyolley1204]

Very helpful, thank you!

[@innovative_learner]

Very happy to know you found it useful. Please like, subscribe and share to support my channel. Thank you very much.

[@burhanhyder26]

Very helpful! Thank you

[@aliceritho]

This is the best tutorial ever

[@TheAnan7777]

Easy to follow. Thanks!

[@innovative_learner]

Thank you very much 😊.

[@bhoomikadhemare2639]

Thank you very very much sir really very helpful 🙏🙏

[@alexdelacruz185]

Amazing, thank you very much!

[@innovative_learner]

Thank you very much 😊

[@haroldasraz]

Cheers, for a great video.

[@aderinolalawal6800]

This was very helpful. Thanks

[@ravishingofficial6016]

Thank you, I just finished my assignment. easy to understand

[@innovative_learner]

Thank you very much. Please subscribe, share and like...

[@venkatakutumbaramamurthyma6802]

Thanks . Simple and easy

[@divyabalan6011]

it is nice one tq

[@yanqimao780]

Thank you for doing this video that helps me a lot!!!

[@innovative_learner]

Thank you very much

[@norasardar]

Thank you so much, really well explained and helpful.
All the best
Nora

[@koushiknandi3082]

So much grateful to you brother

[@innovative_learner]

My pleasure

[@visualpmpacademy2230]

Great Effort Thank you so much

[@o9o7_]

Thanks man super helpful

[@inhcanh1633]

Very very Beautiful

[@ailecdreifuss8627]

Thank you so much!

[@theonlyroone1237]

You are a big legendddd

[@md.nuraalamseddeki2018]

I did this job. thanks for your suggestion.

[@saulbasurto3627]

Is there a way to color code the bars depending on who manages it?

[@shengyiwang6611]

That's an awesome video!! The chart looks amazing! I have a question if the task has been finished in non-consecutive days, how should it be caught by this Gantt chart? Thank you very much!

[@innovative_learner]

Thank you very much. You might also like my other new video on Gantt chart at czcams.com/video/9eqXYNgtIAA/video.html

[@henriettahoward8265]

Very helpful video

[@sivanreads]

BEST VIDEO EVER TYSM

[@innovative_learner]

Delighted to know you found it useful. Please subscribe to support my channel. Thank you very much.

[@VVW_Media]

Good one

[@Rincon009]

Thank you!!

[@msog8488]

Thank you !

[@nihilaantony666]

Really Helpful. Thank you

[@innovative_learner]

You are welcome

[@gloriasif7769]

great video indeed!
easy to understand!

[@brings2520]

Thank you for the video

[@basantbhatta6378]

Thank you very much brother really helpful for me❤️

[@innovative_learner]

Thanks brother. Please let me know if you want any other type of video. Cheers.

[@basantbhatta6378]

@@innovative_learner can you help me making IoT based theft detection machine using Raspberry pi
I want to know more about that available video in CZcams give less knowledge 🙂

[@olgaermakova5751]

Thank you!!!!

[@mustafaelkholy4122]

You are a genus

[@naturelove9654]

Well Explained. Thanks Boss (Y)

[@innovative_learner]

Thank you very much :-)

[@NXSISLAM]

thank you!

[@savizsasani8310]

Perfect tutorial

[@innovative_learner]

Thank you very much for appreciation and encouragement. Have a lovely day :-)

[@russelprudente2170]

Good for beginners, thanks a lot!!

[@innovative_learner]

Thank you very much.

[@roeltari3669]

guuuuud

[@muhammedseid4679]

Thanks !

[@eribaik]

who want to reverse order, you can try right click at task 1-7 ->axis options-> axis position-> tick categories in reverse order

[@lites4555]

I love you my guy

[@pravinteli5290]

Thank you so much brother

[@innovative_learner]

Thank you very much. You might also like my other new video on Gantt chart at czcams.com/video/9eqXYNgtIAA/video.html

[@santhoshvarghese5640]

Thank you sir

[@azibambo9275]

Thank u so much

[@huiguansun4340]

Hi there, this is a great video. One question though, the table at the bottom looks like have the wrong order showing from task7 to task 1. Is there a way we can reverse it? Thanks!

[@juliesalah2409]

I would like to know as well. Thanks

[@eribaik]

any solution?

[@GetGot-ry7kf]

Thank you! I made it for 10min, other videos made me feel stupid😭

[@jasleenthanwal487]

Great

[@rachy3259]

Thank you very much

[@innovative_learner]

Thank you very much too.

[@dalyaalzard8661]

Hi, how do I reverse the order of the dates and the task numbers in the data table?

[@innovative_learner]

Thanks for your question. Yes, it is possible to change order of table but you will, first, have to skip changing order of tasks in vertical column so in vertical axis Task-7 should be on the top and below it would be Task-6, -5, -4, -3, -2 and thus Task-1 will be on the bottom. This should still be perfectly fine as it would mean that your oldest task (Task-1) is on the bottom and other tasks are piling up thus your latest task (Task-7) is on the top. By doing so the data table will start with Task-1. Hope that helps. Please let me know if that still doesnt answer your question and I will try my best to resolve your problem. Thanks.

[@shirinparvaresh]

Hello, is there a way we can have the data table in the bottom start with Task 1, instead of task 7?

[@innovative_learner]

Thanks for your question. Yes, it is possible to change order of table but you will, first, have to skip changing order of tasks in vertical column so in vertical axis Task-7 should be on the top and below it would be Task-6, -5, -4, -3, -2 and thus Task-1 will be on the bottom. This should still be perfectly fine as it would mean that your oldest task (Task-1) is on the bottom and other tasks are piling up thus your latest task (Task-7) is on the top. By doing so the data table will start with Task-1. Hope that helps. Thanks.

[@eribaik]

right click at task 1-7 ->axis options-> axis position-> tick categories in reverse order

[@holaitsesteban]

I'm stuck. I don't have that menu after right clicking on the blank chart.

[@kidsdrawing9969]

thank share

[@sunjidasunju9095]

Thanks

[@Around_The_Home]

I think for Duration the formula should be =(enddate - startdate + 1). Otherwise, something that starts and ends on the same day will have zero days duration.

[@Around_The_Home]

@@christinaperkins7600 A one day task will begin and end on the same 1 day. Otherwise, it is not 1 day. Thus enddate and startdate will be the same. Therefore, =(enddate - startdate +1) will resolve to = 0 + 1 which will resolve to = 1. Hope this makes sense.

[@sandrakristine92]

THANX!

[@innovative_learner]

Thank you very much

[@sandradavis2730]

Thank u