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

A Gantt chart is a bar chart which is used to illustrate tasks that are to be completed over time in a project. To create our Gantt chart, the first step is to set up a project table with a list of tasks to be completed and their start and end dates. The next step is to calculate the duration of each task which is the end date minus the start date. Later on, we will use the start date and duration columns to create our Gantt chart. We can also include the progress towards achieving each task and use this to identify how many days of each task have been completed. To create our Gantt chart, we will insert a stacked bar chart. We will use error bars, data labels and other techniques to make the bar chart look like a Gantt chart which will give us a clear overview of the tasks that must be completed and how much progress has been made so far.
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• How To Create A Gantt ...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
theexcelhub@outlook.com
Overview: (0:00)
Set Up Project Table: (0:23)
Create Gantt Chart: (1:32)

Пікірлер: 134

  • @edgarindainyapadi
    @edgarindainyapadi Жыл бұрын

    Absolutely wonderful. It was easy to follow!

  • @frankcardonasanchez
    @frankcardonasanchez11 ай бұрын

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

  • @abderrahmaneazibi8056
    @abderrahmaneazibi80563 ай бұрын

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

  • @lisalacy4206
    @lisalacy4206 Жыл бұрын

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

  • @sharontyr877
    @sharontyr877 Жыл бұрын

    Very clear and precise tutorial, thank you.

  • @Permagrinful
    @Permagrinful Жыл бұрын

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

  • @theexcelhub

    @theexcelhub

    Жыл бұрын

    Thank you very much!

  • @raphaeluzor6193
    @raphaeluzor6193 Жыл бұрын

    Excellent tutorial! Thanks for sharing!

  • @chochrissy
    @chochrissy10 ай бұрын

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

  • @bvasavi
    @bvasavi Жыл бұрын

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

  • @user-jz8di4mu6l
    @user-jz8di4mu6l Жыл бұрын

    Thanks a million! Very useful and easy to follow

  • @raymondarce4043
    @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

  • @malladiprasad2143
    @malladiprasad2143 Жыл бұрын

    Excellent video, easy to follow. Thank you

  • @BlackRose_01
    @BlackRose_012 жыл бұрын

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

  • @theexcelhub

    @theexcelhub

    Жыл бұрын

    Glad it helped, thank you!

  • @tameraziz2104
    @tameraziz2104 Жыл бұрын

    Extremely Useful - Thank You

  • @annacolognese1671
    @annacolognese16716 ай бұрын

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

  • @lesserspottedmugwump.363
    @lesserspottedmugwump.363 Жыл бұрын

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

  • @nawarajkhadka9502
    @nawarajkhadka9502 Жыл бұрын

    wonderful! you're a saviour man!!

  • @TYapril
    @TYapril Жыл бұрын

    Very good tutorial. Thanks!

  • @hollym8453
    @hollym84532 жыл бұрын

    Your tutorials are sooooooo good! Thank you so much

  • @theexcelhub

    @theexcelhub

    2 жыл бұрын

    I'm glad, thanks for watching!

  • @poetraabadi4608
    @poetraabadi46087 ай бұрын

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

  • @theexcelhub

    @theexcelhub

    7 ай бұрын

    Thank you very much!

  • @afafazizan2433
    @afafazizan24332 жыл бұрын

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

  • @theexcelhub

    @theexcelhub

    2 жыл бұрын

    Thank you for watching Afaf!

  • @Dias10099
    @Dias10099 Жыл бұрын

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

  • @pmomalley
    @pmomalley Жыл бұрын

    WOW!! Amazing tutorial.

  • @olabisiakinyele810
    @olabisiakinyele810Ай бұрын

    This video is excellent! Thank you for sharing!!

  • @samirparmar3318
    @samirparmar331814 күн бұрын

    It's very useful n easy

  • @gersonordena
    @gersonordena10 ай бұрын

    Thank you! Very detailed indeed.

  • @SteveBFamily
    @SteveBFamily Жыл бұрын

    Great video. Thank you!

  • @1000Zebedee
    @1000Zebedee11 ай бұрын

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

  • @MrsMojaRising
    @MrsMojaRising2 жыл бұрын

    thank you! That was very clear and helpful!

  • @theexcelhub

    @theexcelhub

    2 жыл бұрын

    Thanks for watching!

  • @santoshshinde8956
    @santoshshinde8956 Жыл бұрын

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

  • @theexcelhub

    @theexcelhub

    Жыл бұрын

    Glad to hear, thanks for watching!

  • @sandeeptalwar1790
    @sandeeptalwar17905 ай бұрын

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

  • @enzovitaloni7327
    @enzovitaloni73273 ай бұрын

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

  • @deepaksingh-vt5qt
    @deepaksingh-vt5qt9 ай бұрын

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

  • @gigupp
    @gigupp Жыл бұрын

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

  • @valdenuzadacol9835
    @valdenuzadacol98352 жыл бұрын

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

  • @theexcelhub

    @theexcelhub

    2 жыл бұрын

    Glad it helped!

  • @AniSepherd972
    @AniSepherd972 Жыл бұрын

    great tutorial!!

  • @virginiabotte7862
    @virginiabotte7862 Жыл бұрын

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

  • @EmmanuelNgwu-mf4nh
    @EmmanuelNgwu-mf4nh9 ай бұрын

    I absolutely enjoyed this

  • @kushhindule7854
    @kushhindule7854 Жыл бұрын

    Thank you for the help

  • @debieeo
    @debieeo2 жыл бұрын

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

  • @theexcelhub

    @theexcelhub

    2 жыл бұрын

    Thank you Debiee that means a lot!

  • @monchlogoc2373
    @monchlogoc23732 жыл бұрын

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

  • @theexcelhub

    @theexcelhub

    Жыл бұрын

    Thanks for the feedback!

  • @johnfitzgerald8203
    @johnfitzgerald820317 күн бұрын

    Thanks for sharing, well done

  • @sonajaleel
    @sonajaleel10 ай бұрын

    Very useful. Thank you so much

  • @pawanrai722
    @pawanrai7223 ай бұрын

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

  • @epitaphmandal8804
    @epitaphmandal8804 Жыл бұрын

    Very helpful.Thanks

  • @rayanabouali1261
    @rayanabouali12613 ай бұрын

    Hey bro you dropped this 👑

  • @stanleygeorge7436
    @stanleygeorge7436 Жыл бұрын

    thanks

  • @osamamohd007
    @osamamohd007Ай бұрын

    Great video, thanks for sharing

  • @areihaile
    @areihaile Жыл бұрын

    Good it is very clear.

  • @zk6239
    @zk6239 Жыл бұрын

    Just perfect

  • @theexcelhub

    @theexcelhub

    Жыл бұрын

    Thank you!

  • @SunnySharma-gv7rx
    @SunnySharma-gv7rx Жыл бұрын

    Very helpful and very easy to understand. Thanks

  • @theexcelhub

    @theexcelhub

    Жыл бұрын

    Glad it helped!

  • @senthilnathan9331
    @senthilnathan93315 ай бұрын

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

  • @dannifeng8339
    @dannifeng833910 ай бұрын

    Beautiful.

  • @MahendraPatel-xb1sn
    @MahendraPatel-xb1sn Жыл бұрын

    Very well explained Sir 🙂

  • @xyzmsbright
    @xyzmsbright2 жыл бұрын

    Thank you!

  • @theexcelhub

    @theexcelhub

    2 жыл бұрын

    Thanks for watching!

  • @Deven1485
    @Deven1485 Жыл бұрын

    Amazing. Well presented.

  • @theexcelhub

    @theexcelhub

    Жыл бұрын

    Thank you very much!

  • @MOHAMED7astanak
    @MOHAMED7astanak Жыл бұрын

    perfect!

  • @ruralkh1948
    @ruralkh19487 ай бұрын

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

  • @theexcelhub

    @theexcelhub

    7 ай бұрын

    Thanks for watching!

  • @bobykumar3960
    @bobykumar3960 Жыл бұрын

    thanks...

  • @BothoSalani-od7os
    @BothoSalani-od7os10 ай бұрын

    That was beautiful

  • @yaa-lala
    @yaa-lala Жыл бұрын

    Awesome!!!

  • @theexcelhub

    @theexcelhub

    Жыл бұрын

    Thanks!

  • @moses2061
    @moses20618 ай бұрын

    Thank you

  • @vipin_rahul
    @vipin_rahul2 жыл бұрын

    This is very nice and useful.

  • @theexcelhub

    @theexcelhub

    2 жыл бұрын

    Thanks for watching!

  • @flowcharttocodeconverter936
    @flowcharttocodeconverter9368 ай бұрын

    Great!

  • @nj742
    @nj74211 ай бұрын

    Excellent

  • @athh.3457
    @athh.3457 Жыл бұрын

    Very helpful excel lesson, very simple tutorial

  • @theexcelhub

    @theexcelhub

    Жыл бұрын

    Glad to hear, thanks for watching!

  • @zulfchoudhary2746
    @zulfchoudhary27462 жыл бұрын

    Great and so useful

  • @theexcelhub

    @theexcelhub

    2 жыл бұрын

    Glad it helped!

  • @bounyoothammavong5712
    @bounyoothammavong57123 ай бұрын

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

  • @anupharne
    @anupharne4 ай бұрын

    Thanks

  • @carlavandewiel
    @carlavandewiel2 жыл бұрын

    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!

  • @henrymwichemulenga7915
    @henrymwichemulenga79158 ай бұрын

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

  • @theexcelhub

    @theexcelhub

    7 ай бұрын

    Great to hear, thanks!

  • @cb13526
    @cb13526 Жыл бұрын

    Excellente

  • @user-ct5lz7sr6m
    @user-ct5lz7sr6m6 ай бұрын

    Dammmmm still useful thanks buddy

  • @tharidhuheshan
    @tharidhuheshan Жыл бұрын

    nice

  • @alexallenmice
    @alexallenmice2 жыл бұрын

    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

  • @netaniahanlon1512
    @netaniahanlon151211 ай бұрын

    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?

  • @hseerah1986
    @hseerah19867 ай бұрын

    Very essential literacy

  • @km2612
    @km26122 ай бұрын

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

  • @user-pg6yh7zk1r
    @user-pg6yh7zk1r Жыл бұрын

    How u can calculate the percentage of progress??

  • @samirparmar3318
    @samirparmar331814 күн бұрын

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

  • @fjrxj1134
    @fjrxj11343 ай бұрын

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

  • @simeonafouda7455
    @simeonafouda7455 Жыл бұрын

    What excel version have you used for this tutorial?

  • @developmenthub9663
    @developmenthub9663 Жыл бұрын

    You 👏👌

  • @Chips505
    @Chips505 Жыл бұрын

    👏👏👏👏

  • @larabdsantos
    @larabdsantos Жыл бұрын

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

  • @sonaraaj6461
    @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?

  • @user-pg6yh7zk1r

    @user-pg6yh7zk1r

    Жыл бұрын

    Check included data

  • @raselsheikh9982
    @raselsheikh99829 ай бұрын

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

  • @user-nq6tm2kl7l
    @user-nq6tm2kl7l5 ай бұрын

    Please do the same tutorial but using a phone

  • @Murkulat0r
    @Murkulat0r5 ай бұрын

    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.

  • @marcmclean4972
    @marcmclean4972 Жыл бұрын

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

  • @oktasumahendra
    @oktasumahendra Жыл бұрын

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

  • @oldiesmusicsj1708
    @oldiesmusicsj17082 жыл бұрын

    I HAVE A QUESTION WHEN I SELECT THE DATA THE GRAPH MOVES LIKE DHSJJD

  • @LT72884
    @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

  • @rayvanrensburg93
    @rayvanrensburg937 ай бұрын

    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

  • @nishantkumar-lw6ce
    @nishantkumar-lw6ce Жыл бұрын

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

  • @rijaluddddin
    @rijaluddddin Жыл бұрын

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

  • @mrspongetv4236
    @mrspongetv42362 жыл бұрын

    Hi sir. Can you help me? What i wanted in my ghant chart is that when i add a holiday, all activities will adjust even if the other activities did not fall onto the holiday date.. can it be possible?? Love the video by the way.

  • @shobanamasilamani7654
    @shobanamasilamani7654 Жыл бұрын

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

  • @olodium6755
    @olodium675510 күн бұрын

    could be hourly?

  • @shantilalparmar4723
    @shantilalparmar47235 күн бұрын

    please send me same tamplate for my use