How to Make Gantt Chart in Excel

Подписаться 3 млн

Просмотров 554 тыс.

50% 1

🔥 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 RU-vid
ru-vid.com?...
🙌 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

Наука

Опубликовано:

26 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 166

@JDCruzer 10 месяцев назад

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!

@rishdhisabith2585 11 месяцев назад

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 11 месяцев назад

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

@richardblate9505 11 месяцев назад

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

@jezs1346 11 месяцев назад

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

@josercolmenares5261 11 месяцев назад

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

@lichialilyliu1226 9 месяцев назад

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

@tamargonsalves 8 месяцев назад

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

@robertk7484 11 месяцев назад

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

@i_Groomer_Dr.E 10 месяцев назад

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

@athinadimitriadis6026 6 месяцев назад

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!!

@constanciaeza6227 7 месяцев назад

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.

@dondiegodelavar 4 месяца назад

So perfectly explained! thank you so much!☺

@rai_zz 8 месяцев назад

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

@gerdsfargen6687 4 месяца назад

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

@dennisminn4017 Месяц назад

great tutorial. Clear and to the point explanation.

@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

@Leslielatrice 6 месяцев назад

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

@Hari-wb5ds 11 месяцев назад

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

@DOlu-tn5qz 26 дней назад

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

@MrluckyStrike0 2 месяца назад

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 11 месяцев назад

Omg, this is genius. Thank you

@kangkhang7341 8 месяцев назад

Love your video tutorials!!! Thank you!

@francesdobbins2964 10 месяцев назад

This was a very informative video. Thanks, Kevin.

@funny__bean 3 месяца назад

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 2 месяца назад

😂😂take heart

@paulobseme7522 Месяц назад

Try use the app not web

@bipmix 4 дня назад

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.

@platafacturi8774 Месяц назад

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

@24jsadana 10 месяцев назад

Thanks Kevin, very informational.

@joshuacampher3494 3 месяца назад

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🎉

@champs-u5829 Месяц назад

This is Amazing ！ Thank you Kevin!!

@spencewhitt 4 месяца назад

Genuinely, such a well done video. Thank you!

@andrewpritchett4058 4 месяца назад

Literally saved me hours today, thank you

@dyerconcepts2632 10 месяцев назад

This was very helpful. thank you.

@user-cg3if8un3i 4 месяца назад

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

@marprou 10 месяцев назад

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

@MashanChaudhry 5 месяцев назад

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

@user-pv6kz8yp6x 7 месяцев назад

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

@Stillgram Месяц назад

Thanks Kevin, saving my college life as per usual

@localgunguy4992 2 месяца назад

Your videos are AWESOME!! Thank you very much.

@revs81 7 месяцев назад

This was very helpful, thank you.

@lilinemes2747 7 месяцев назад

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

@A_WorldToDiscover 3 месяца назад

Thanks Kevin for this useful video!

@troymanatunga 9 месяцев назад

Life Saver!!! Thank You

@aldorodriguez2004 24 дня назад

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

@tasyaireen9082 Месяц назад

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

@antojerrinevincent9236 8 месяцев назад

Crisp and Clear.

@claurianngowi7933 2 месяца назад

Thanks you, my assignment done perfectly! through your guidance

@khan31088 11 месяцев назад

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

@lasantham9277 5 месяцев назад

Thanks Brother

@graciousbwishi3937 2 месяца назад

I did it without struggles thank you Kevin

@Organicalism 2 месяца назад

Thank you so much!

@mrfordf3508 3 месяца назад

Thank you sir! This is an excellent tutorial.

@JohnEPNR 7 месяцев назад

Very helpful. Thanks!

@Robylazarus 27 дней назад

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

@weston.weston 3 месяца назад

This was sooo good, thank you, Kevin.

@GregoryKodolanyiRitter 11 месяцев назад

Fantastic, thank you!

@KevinStratvert 11 месяцев назад

You bet!

@95theRasmus 12 дней назад

Thanks so much

@jordaanatsangbe6060 8 месяцев назад

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

@marinagonzalez8516 6 месяцев назад

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

@mandardewoolkar3417 10 месяцев назад

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

@dazein13783 16 дней назад

🤩 Really bright and Samrt, liked it so much

@stevechw 11 месяцев назад

Thanks!

@antoinebostyn7425 4 месяца назад

Thank you Kevin I love you

@arifkargin3092 2 месяца назад

Thank you very much, it was helpful :)

@benusinghal7208 6 месяцев назад

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?

@kriglics 7 месяцев назад

this was great, thank you !

@sharlanefenton6213 2 месяца назад

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

@johannaleiziaga5730 Месяц назад

Excellent video, very clear to understand.

@KevinStratvert Месяц назад

Great to hear!

@fishingfool2644 4 месяца назад

Thank you for this video.

@anastasijamitrofan2139 Месяц назад

Thanks a lot

@GeetanjaliChavan 6 месяцев назад

You are the best Kevin :)

@azrael_morningstar 3 месяца назад

Perfect 😁👍

@kingsleyatuba 5 месяцев назад

Thanks a lot for this 🙏🏽

@tutornick 11 месяцев назад

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

@nicholaskafantaris5497 4 месяца назад

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

@flirtuall78 13 дней назад

Thanks.

@jdanderson9727 5 месяцев назад

This is very helpful!

@95thjackfrost 5 месяцев назад

God bless you sir

@CICSIntegrity 9 месяцев назад

Well done!

@JCEurovisionFan1996 11 месяцев назад

Hope you do a tutorial on the Likert scale chart.

@jewelqueen5949 8 месяцев назад

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

@user-fz7xw6bd7o 8 месяцев назад

great tutorial

@xaquison 11 месяцев назад

Very nice!!!!!

@malickjappie1889 Месяц назад

Great video!

@marceau2834 7 месяцев назад

THANKS !!!!

@danieldasilva302 10 месяцев назад

Amazing!

@omkarghadigaonkar4137 6 месяцев назад

Thanks a lot man

@mindaugasmeller5319 6 месяцев назад

This is awesome!

@josei.garrigo5660 4 месяца назад

Thank you once again. You saved my cookies

@petitst 11 месяцев назад

Very usefull, THX!

@KevinStratvert 11 месяцев назад

Glad to hear that!

@Alan-wt1vo 11 месяцев назад

that was brilliant

@josercolmenares5261 11 месяцев назад

I'm a subscriber.

@PopBeerCan-rm6go 2 минуты назад

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

@tantiss99 3 месяца назад

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?

@kingwesleyXIV 11 месяцев назад

Hi everyone today at the Kevin cookie company we are going to discuss charts in excel

@KevinStratvert 11 месяцев назад

😂

@ManishSingh-ds3qn 9 месяцев назад

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

@AxeL-up7jm 9 месяцев назад

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 RU-vid. You sir, have saved me. High quality, easy to understand, divided into modular parts. Thank you. You have no idea how refreshing this is.