How To Create A Gantt Chart With A Progress Bar To Show Percentage Completion Of Tasks In Excel

[@theexcelhub]

Hi all, you can access the template featured in this video here:
theexcelhub.myshopify.com/

[@abderrahmaneazibi8056]

In my opinion it's far more interesting.
Many thanks for sharing.

[@frankcardonasanchez]

Excellent description to save your life, when you don't have Microsoft Project. Super Excel management. You are a SENSEI.

[@enzovitaloni7327]

Sir! I really appreciate for this video. It was really helpful and easy to follow to prepare an activity tracker!.

[@poetraabadi4608]

What a detailed and clear narration. I think this is the simplest. Thanks a lot.

[@theexcelhub]

Thank you very much!

[@bvasavi]

Thank you so much. You have solved my 8 hours of research on how to achieve whatever you have showed.

[@henrymwichemulenga7915]

Excellent work, after watching this video, I cracked in 15 minutes what I couldn't in 24 hours. Thank you.

[@theexcelhub]

Great to hear, thanks!

[@virginiabotte7862]

Thank you a lot. Now I feel like a genius because I've succeeded in doing a Gantt Chart.

[@pawanrai722]

What a video....extremely informative and useful. Thanks a lot for this video.

[@theexcelhub]

Thank you for watching!

[@rayanabouali1261]

Hey bro you dropped this 👑

[@BlackRose_01]

This was extremely detailed, easy to listen to and understand. Really very helpful for a simple project. Now for the practice.

[@theexcelhub]

Glad it helped, thank you!

[@debieeo]

I wish I could like this a million times. Thank you so much 💞

[@theexcelhub]

Thank you Debiee that means a lot!

[@edgarindainyapadi]

Absolutely wonderful. It was easy to follow!

[@raymondarce4043]

awesome, i looked at several other videos from other pages and was not able to do it. Thanks for taking your time, not skipping steps, and showing the work. I appreciate it

[@sandeeptalwar1790]

Great Video, explained in detail and in simplest way. Thanks for your inputs through this video.

[@sharontyr877]

Very clear and precise tutorial, thank you.

[@annacolognese1671]

thank you so much! I have done my first Gannt chart following your instructions

[@gigupp]

you are a champion, thank you very much for this enlightenment. Very useful to me

[@deepaksingh-vt5qt]

This was really helpful; so good to keep track of KRAs at workplace.

[@ruralkh1948]

Really good and simple as me a beginner. Much Thanks!

[@theexcelhub]

Thanks for watching!

[@hollym8453]

Your tutorials are sooooooo good! Thank you so much

[@theexcelhub]

I'm glad, thanks for watching!

[@santoshshinde8956]

Thank You So Much! This was truly truly helping hand!

[@theexcelhub]

Glad to hear, thanks for watching!

[@lisalacy4206]

This was very helpful and easy to follow. Thank you!

[@raphaeluzor6193]

Excellent tutorial! Thanks for sharing!

[@EmmanuelNgwu-mf4nh]

I absolutely enjoyed this

[@tameraziz2104]

Extremely Useful - Thank You

[@bounyoothammavong5712]

Wow, I just found this video, very useful and share thanks for your share🤩

[@AniSepherd972]

great tutorial!!

[@olabisiakinyele810]

This video is excellent! Thank you for sharing!!

[@theexcelhub]

Thank you!

[@mrmagoo-i2l]

Excellent, a lot easier than the method I was shown in class.

[@kushhindule7854]

Thank you for the help

[@monchlogoc2373]

Thank you very much. This is truly helpful. Thank you for sharing your knowledge.

[@theexcelhub]

Thanks for the feedback!

[@nawarajkhadka9502]

wonderful! you're a saviour man!!

[@pmomalley]

WOW!! Amazing tutorial.

[@balrajvirdee1087]

Thanks great tutorial

[@theexcelhub]

Thank you!

[@theexcelhub]

Thank you!

[@SunnySharma-gv7rx]

Very helpful and very easy to understand. Thanks

[@theexcelhub]

Glad it helped!

[@Dias10099]

Thank you very much for your information. It helps us alot for our projects. ❤

[@sonajaleel]

Very useful. Thank you so much

[@osamamohd007]

Great video, thanks for sharing

[@theexcelhub]

Thank you!

[@Permagrinful]

Straight and to the point, easy to follow. Thank you

[@theexcelhub]

Thank you very much!

[@MahendraPatel-xb1sn]

Very well explained Sir 🙂

[@alexallenmice]

Dear Michael, it's you that make register for youtube, I follow your tutorial from bilibili to your channel here and I'll continue to support

[@areihaile]

Good it is very clear.

[@athh.3457]

Very helpful excel lesson, very simple tutorial

[@theexcelhub]

Glad to hear, thanks for watching!

[@malladiprasad2143]

Excellent video, easy to follow. Thank you

[@TYapril]

Very good tutorial. Thanks!

[@johnfitzgerald8203]

Thanks for sharing, well done

[@theexcelhub]

Thank you!

[@SteveBFamily]

Great video. Thank you!

[@epitaphmandal8804]

Very helpful.Thanks

[@chochrissy]

This is extremely helpful and what I exactly need. Appreciate your help!

[@1000Zebedee]

Wonderful narration and great to listen to and understand. Your pace was perfect and extremely clear and concise in your delivery. 💯

[@afafazizan2433]

Thank you! Your video is so helping. Clear explaination 👍🏼

[@theexcelhub]

Thank you for watching Afaf!

[@MrsMojaRising]

thank you! That was very clear and helpful!

[@theexcelhub]

Thanks for watching!

[@senthilnathan9331]

Thanks a lot for this video.. Kudos...

[@abbygot]

Thank you very much..

[@theexcelhub]

Thanks for watching!

[@samirparmar3318]

It's very useful n easy

[@theexcelhub]

Thank you!

[@tipsforexcel-l5r]

Excellant video

[@theexcelhub]

Thank you!

[@Deven1485]

Amazing. Well presented.

[@theexcelhub]

Thank you very much!

[@zk6239]

Just perfect

[@theexcelhub]

Thank you!

[@gersonordena]

Thank you! Very detailed indeed.

[@nj742]

Excellent

[@fjrxj1134]

How do you set up the % progress, what formula do you use?

[@BothoSalani-od7os]

That was beautiful

[@dannifeng8339]

Beautiful.

[@km2612]

Great video, how can we exclude weekend in the progress bar?

[@zulfchoudhary2746]

Great and so useful

[@theexcelhub]

Glad it helped!

[@yaa-lala]

Awesome!!!

[@theexcelhub]

Thanks!

[@stanleygeorge7436]

thanks

[@raselsheikh9982]

Really helpful.
Please describe if task complete, i want to add another date. Is it possible to show same horizontal wise

[@vipin_rahul]

This is very nice and useful.

[@theexcelhub]

Thanks for watching!

[@rijaluddddin]

What mouse do you use? the sound is so soft...

[@yazanshehab-u8j]

How u can calculate the percentage of progress??

[@netaniahanlon1512]

Hi, thanks for this tutorial. Is there a way to apply dynamic dates to the date axis and apply a scroll feature? For example, if I had a project program that spread out over 2 years and wanted to show a 2 month period at a time, could a scroll be added so that I could scroll through the different months and only see the months applied at the time?

[@cb13526]

Excellente

[@valdenuzadacol9835]

Thank you so much. This was very helpful! Excellent explanation.

[@theexcelhub]

Glad it helped!

[@bobykumar3960]

thanks...

[@musi6666]

Phenomenal!

[@theexcelhub]

Thank you.

[@Murkulat0r]

Great video, thanks! For me, the height of the vertical today line did not work. I made a chart with 43 lines for tasks and could not find a way to get the line to reach from top to bottom.

[@MOHAMED7astanak]

perfect!

[@olodium6755]

could be hourly?

[@samirparmar3318]

Please if you can make vedio on material stock also in projects

[@larabdsantos]

Is it possible to change the horizontal axis to show only the months?

[@rayvanrensburg93]

Could you help with how you ad the actual if they did not complete in the set date time but over run by a few days to be able to show a minus progress of delayed time

[@RitikThakur-r6f]

Dammmmm still useful thanks buddy

[@moses2061]

Thank you

[@simeonafouda7455]

What excel version have you used for this tutorial?

[@xyzmsbright]

Thank you!

[@theexcelhub]

Thanks for watching!

[@RonaldRobijns]

hello for some reason my bars are not showing anymore.
i use the planner now 1 and a half year forward.
is there a way to reset the formula ?

[@shobanamasilamani7654]

How to create gannt chart for frequently repeated actions like monthly weekly and yearly

[@carlavandewiel]

Thank you so much! So helpful! Short question: how can I add more moment at the horizontal axis? (I made a year plan and the chart shows not all months. (March, June, August and November are missing...) Thanks again!

[@oktasumahendra]

related to the duration, if i have start date 1 july until 1 july. how to calculate the duration ?

[@sonaraaj6461]

Thanks a ton for this. This is exactly what I was looking for. I made the same for my project, but when I changed the dates later, the bars are not getting updated as per the new dates and number of days. Could you help in how do I refresh the chart?

[@yazanshehab-u8j]

Check included data

[@marcmclean4972]

How did you populate the progress column is there a formula behind it?

[@tharidhuheshan]

nice

[@anupharne]

Thanks

[@flowcharttocodeconverter936]

Great!

[@nishantkumar-lw6ce]

How do we convert the duration to hours spent instead of days?

[@SebenzileNcanana]

Please do the same tutorial but using a phone

[@hseerah1986]

Very essential literacy

[@LT72884]

how would you make sub topics for a main category and show the progress for each subtopic BUT a progress bar for the MAIN category as well? IE, if i had to build a motor mount for a prototype rocket i would want a main category called "motor mount" and then under that would be 3 or 4 tasks, each with their own progress bar, BUT the main "motor mount" progress bar would show the progress of the tasks added together?
thanks