How to Make Gantt Chart in Excel

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to make a Gannt Chart in Excel. We start by creating a data table with start dates and estimated time needed. Next, we insert a stacked bar chart and make some tweaks to the chart to make it appear as a Gannt Chart.
📚 RESOURCES
- Sample workbook to follow along: 1drv.ms/x/s!AmxrofZZlZ-whZ9_x...
⌚ TIMESTAMPS
0:00 Introduction
0:16 Format data
2:39 Insert stacked bar chart
3:24 Turn into Gantt chart
7:08 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: • ❎ How to use Excel
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON UA-cam
ua-cam.com/users/kevlers?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
#stratvert #ganttchart #excel

[@tarekmahmud7206]

simple but still useful Gantt chart. this tutorial must help excel users.

[@JDCruzer]

Hi Kevin, I've always been wanting to do a Gantt Chart in Excel for my home reno without using Microsoft Project. You made it a reality with your excellent tutorial. Thank you so much!

[@richardblate9505]

This great! Can you do another on that expands on this to include-
1. planned start/end dates
2. dependencies?
3. % complete

[@jezs1346]

I’m so glad your shorts turned up on my feed, your tutorials are really well presented and easy to follow. Thank-you.

[@rishdhisabith2585]

I used gant chart 3 years back for a course assignment. Now I joined another one,Perfect timing as Iam supposed to do assignments and completely forgot how gant chart works

[@KevinStratvert]

It's a little tricky in Excel, but once you run through it, it works quite well. 👍

[@robertk7484]

Once again I see immediate value, benefit, and uses for this. Excel-lent explanation.

[@tamargonsalves]

This is such a great easy to follow tutorial. Thank you!

[@lichialilyliu1226]

Keven, thank you very much for the clear explanation at an appropriate speed. Highly useful! :)

[@constanciaeza6227]

Wow just did my first Gantt Chart for my project management on my Master's. Oh god, I'm proud of myself. ThankThank Thank you so much yes. You are the greatest.

[@athinadimitriadis6026]

The perfect tutorial!! I had no clue what a Gantt Chart is and how to do it for my homework, and this video saved me. Thank you!!

[@i_Groomer_Dr.E]

You are legend bro.....
I just helped my girlfriend with her project and she thinks I'm a super star....
Subscribed already 👏👏👏

[@josercolmenares5261]

Excellent tutorial and a great improvement towards what I previously used to do. Thanks so much!

[@davimasondo6150]

I had to re-watch this vid 3 times and kept on pausing every step of the way but, finally I made it! thank youuuuu

[@rai_zz]

amazing tutorial, I always sucked at making charts, you saved me big time.

[@gerdsfargen6687]

You Kevin are a master. A master who saved my task bacon. Thank you so much! Nick

[@dondiegodelavar]

So perfectly explained! thank you so much!☺

[@DOlu-tn5qz]

This video is a life saver literally took 5 minutes very useful considering it's 2.5 hrs before my assignment deadline

[@MrluckyStrike0]

Very Helpful. My class wanted me to use PPT template for an assignment but this was easier for me. very self explanatory! Thanx for the video man!

[@HayaJi]

Omg, this is genius. Thank you

[@lilinemes2747]

It was soo useful to me, thank you to speak slowly, it was easy to understand for not perfect English speakers too😊

[@platafacturi8774]

You are a great teacher!!! All the best from the entire world!

[@kangkhang7341]

Love your video tutorials!!! Thank you!

[@dennisminn4017]

great tutorial. Clear and to the point explanation.

[@funny__bean]

i tried this but failed miserably, maybe because I am an excel noob. But there are no other tutorials available which are recent. So I am going to give this another try.

[@danielgiathi1546]

😂😂take heart

[@paulobseme7522]

Try use the app not web

[@bipmix]

take it slow and don't move forward until you have completed the tasks exactly the way they are explained. It takes a bit of time but this is the best tutorial for gantt charts in Excel. it also gets easier after you have done it a couple of times.

[@Leslielatrice]

Thanks so much! This was really helpful! Now I have a good Gantt Chart for my Project Milestones

[@francesdobbins2964]

This was a very informative video. Thanks, Kevin.

[@Hari-wb5ds]

Kudos to you 👏🏻👍🏻. support from India ❤

[@joshuacampher3494]

Thank you Kevin, this video was very quick and easy to follow

[@de5505]

Thank you Kevin. I needed this for my final college Senior project!!
I graduate next month🎉

[@24jsadana]

Thanks Kevin, very informational.

[@spencewhitt]

Genuinely, such a well done video. Thank you!

[@aldorodriguez2004]

Thank you so much, I needed to make a Gantt Chart for College Project!

[@andrewpritchett4058]

Literally saved me hours today, thank you

[@marprou]

Great video. Always wanted to get a gannt view in Excel

[@MashanChaudhry]

I am very impressed because I learned a new skill called creating a Gantt chart.

[@khan31088]

Kevin love from Pakistan. Your way of teaching/coaching is awesome 😎

[@antojerrinevincent9236]

Crisp and Clear.

[@user-cg3if8un3i]

hey kevin.. short and effective guidance. I got it well. Thanks !!!

[@mandardewoolkar3417]

Great video Kevin! Is it also possible to mark tasks with % completion to see progress in the gantt chart? Thanks un advance.

[@graciousbwishi3937]

I did it without struggles thank you Kevin

[@user-pv6kz8yp6x]

Fantastic and very helpful video. You are a life saver!!!

[@troymanatunga]

Life Saver!!! Thank You

[@champs-u5829]

This is Amazing ！ Thank you Kevin!!

[@dyerconcepts2632]

This was very helpful. thank you.

[@localgunguy4992]

Your videos are AWESOME!! Thank you very much.

[@Stillgram]

Thanks Kevin, saving my college life as per usual

[@benusinghal7208]

Thanks Kevin, this was really helpful. Any idea how to plot if there are multiple sub-tasks under each task/activity, with different start dates and end dates?

[@claurianngowi7933]

Thanks you, my assignment done perfectly! through your guidance

[@tasyaireen9082]

Hi Kevin! Thank you so much for this video. It helps me a lot.

[@revs81]

This was very helpful, thank you.

[@weston.weston]

This was sooo good, thank you, Kevin.

[@A_WorldToDiscover]

Thanks Kevin for this useful video!

[@Robylazarus]

Brilliant vid, thanks for sharing this Kevin....

[@GregoryKodolanyiRitter]

Fantastic, thank you!

[@KevinStratvert]

You bet!

[@gayan6438]

Awesome video. Thank you sir ❤

[@mrfordf3508]

Thank you sir! This is an excellent tutorial.

[@JohnEPNR]

Very helpful. Thanks!

[@jewelqueen5949]

This is great. Question... is there any way to add value field to each task, that would show on each date, that would calculate the total on the x axis? I hope that makes sense. Thanks

[@jordaanatsangbe6060]

thank you for making these updated tutorials! they were completely out of date.

[@95thjackfrost]

God bless you sir

[@95theRasmus]

Thanks so much

[@kriglics]

this was great, thank you !

[@antoinebostyn7425]

Thank you Kevin I love you

[@dazein13783]

🤩 Really bright and Samrt, liked it so much

[@fishingfool2644]

Thank you for this video.

[@arifkargin3092]

Thank you very much, it was helpful :)

[@marinagonzalez8516]

Very nice gantt chart in Excel ! I'll try it

[@kingsleyatuba]

Thanks a lot for this 🙏🏽

[@jdanderson9727]

This is very helpful!

[@tutornick]

Great tutorial video as usual Kevin. I will share this with my project management students next week!

[@GeetanjaliChavan]

You are the best Kevin :)

[@stevechw]

Thanks!

[@anastasijamitrofan2139]

Thanks a lot

[@lasantham9277]

Thanks Brother

[@flirtuall78]

Thanks.

[@CICSIntegrity]

Well done!

[@jfoster1664]

this is great

[@mindaugasmeller5319]

This is awesome!

[@johannaleiziaga5730]

Excellent video, very clear to understand.

[@KevinStratvert]

Great to hear!

[@Organicalism]

Thank you so much!

[@malickjappie1889]

Great video!

[@JCEurovisionFan1996]

Hope you do a tutorial on the Likert scale chart.

[@xaquison]

Very nice!!!!!

[@danieldasilva302]

Amazing!

[@nicholaskafantaris5497]

You are a genius... I barely followed this lol.

[@sharlanefenton6213]

The best content creator in explaining the steps to make a GAANT chart. Are you on skillshare??

[@marceau2834]

THANKS !!!!

[@user-fz7xw6bd7o]

great tutorial

[@Alan-wt1vo]

that was brilliant

[@omkarghadigaonkar4137]

Thanks a lot man

[@petitst]

Very usefull, THX!

[@KevinStratvert]

Glad to hear that!

[@tantiss99]

Thank you for this! And I'm just wondering whats the point of using workday if you need to factor in weekends? Is there another way to do this?

[@thelunatick1993]

Can this be used to visualize cash flow?
Either daily or hourly?

[@azrael_morningstar]

Perfect 😁👍

[@martinargimon730]

HI kevin. why did you have to change the format of dates to 'numeric/ ( general) before creating the chart ? Thanks

[@KevinStratvert]

The Stacked bar chart we want doesn’t show up as an option if not 👍

[@ManishSingh-ds3qn]

Thanks for sharing this video, Could you please share working sheet, thank you

[@markwhitelaw7192]

Hello, this was very helpful, thank you! However, I'm new to Gantt charts, I'm wondering why you created a stacked chart only to remove one of the stacks? What is the purpose of this?
Thank you!

[@PopBeerCan-rm6go]

Hello Kevin
Some of the "the to do items" get omitted from the chart although I have highlighted them on the table.

[@sammy0boi]

Super vid!

[@AxeL-up7jm]

Here I was, concerned about getting given nothing but broken accented, royalty free music, low quality screen cam videos. Because that is what tends to happen when you ask more and more specific questions on UA-cam.
You sir, have saved me.
High quality, easy to understand, divided into modular parts.
Thank you.
You have no idea how refreshing this is.