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
Absolutely wonderful. It was easy to follow!
Excellent description to save your life, when you don't have Microsoft Project. Super Excel management. You are a SENSEI.
In my opinion it's far more interesting. Many thanks for sharing.
This was very helpful and easy to follow. Thank you!
Very clear and precise tutorial, thank you.
Straight and to the point, easy to follow. Thank you
@theexcelhub
Жыл бұрын
Thank you very much!
Excellent tutorial! Thanks for sharing!
This is extremely helpful and what I exactly need. Appreciate your help!
Thank you so much. You have solved my 8 hours of research on how to achieve whatever you have showed.
Thanks a million! Very useful and easy to follow
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
Excellent video, easy to follow. Thank you
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!
Extremely Useful - Thank You
thank you so much! I have done my first Gannt chart following your instructions
Excellent, a lot easier than the method I was shown in class.
wonderful! you're a saviour man!!
Very good tutorial. Thanks!
Your tutorials are sooooooo good! Thank you so much
@theexcelhub
2 жыл бұрын
I'm glad, thanks for watching!
What a detailed and clear narration. I think this is the simplest. Thanks a lot.
@theexcelhub
7 ай бұрын
Thank you very much!
Thank you! Your video is so helping. Clear explaination 👍🏼
@theexcelhub
2 жыл бұрын
Thank you for watching Afaf!
Thank you very much for your information. It helps us alot for our projects. ❤
WOW!! Amazing tutorial.
This video is excellent! Thank you for sharing!!
It's very useful n easy
Thank you! Very detailed indeed.
Great video. Thank you!
Wonderful narration and great to listen to and understand. Your pace was perfect and extremely clear and concise in your delivery. 💯
thank you! That was very clear and helpful!
@theexcelhub
2 жыл бұрын
Thanks for watching!
Thank You So Much! This was truly truly helping hand!
@theexcelhub
Жыл бұрын
Glad to hear, thanks for watching!
Great Video, explained in detail and in simplest way. Thanks for your inputs through this video.
Sir! I really appreciate for this video. It was really helpful and easy to follow to prepare an activity tracker!.
This was really helpful; so good to keep track of KRAs at workplace.
you are a champion, thank you very much for this enlightenment. Very useful to me
Thank you so much. This was very helpful! Excellent explanation.
@theexcelhub
2 жыл бұрын
Glad it helped!
great tutorial!!
Thank you a lot. Now I feel like a genius because I've succeeded in doing a Gantt Chart.
I absolutely enjoyed this
Thank you for the help
I wish I could like this a million times. Thank you so much 💞
@theexcelhub
2 жыл бұрын
Thank you Debiee that means a lot!
Thank you very much. This is truly helpful. Thank you for sharing your knowledge.
@theexcelhub
Жыл бұрын
Thanks for the feedback!
Thanks for sharing, well done
Very useful. Thank you so much
What a video....extremely informative and useful. Thanks a lot for this video.
Very helpful.Thanks
Hey bro you dropped this 👑
thanks
Great video, thanks for sharing
Good it is very clear.
Just perfect
@theexcelhub
Жыл бұрын
Thank you!
Very helpful and very easy to understand. Thanks
@theexcelhub
Жыл бұрын
Glad it helped!
Thanks a lot for this video.. Kudos...
Beautiful.
Very well explained Sir 🙂
Thank you!
@theexcelhub
2 жыл бұрын
Thanks for watching!
Amazing. Well presented.
@theexcelhub
Жыл бұрын
Thank you very much!
perfect!
Really good and simple as me a beginner. Much Thanks!
@theexcelhub
7 ай бұрын
Thanks for watching!
thanks...
That was beautiful
Awesome!!!
@theexcelhub
Жыл бұрын
Thanks!
Thank you
This is very nice and useful.
@theexcelhub
2 жыл бұрын
Thanks for watching!
Great!
Excellent
Very helpful excel lesson, very simple tutorial
@theexcelhub
Жыл бұрын
Glad to hear, thanks for watching!
Great and so useful
@theexcelhub
2 жыл бұрын
Glad it helped!
Wow, I just found this video, very useful and share thanks for your share🤩
Thanks
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!
Excellent work, after watching this video, I cracked in 15 minutes what I couldn't in 24 hours. Thank you.
@theexcelhub
7 ай бұрын
Great to hear, thanks!
Excellente
Dammmmm still useful thanks buddy
nice
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
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?
Very essential literacy
Great video, how can we exclude weekend in the progress bar?
How u can calculate the percentage of progress??
Please if you can make vedio on material stock also in projects
How do you set up the % progress, what formula do you use?
What excel version have you used for this tutorial?
You 👏👌
👏👏👏👏
Is it possible to change the horizontal axis to show only the months?
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
Жыл бұрын
Check included data
Really helpful. Please describe if task complete, i want to add another date. Is it possible to show same horizontal wise
Please do the same tutorial but using a phone
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.
How did you populate the progress column is there a formula behind it?
related to the duration, if i have start date 1 july until 1 july. how to calculate the duration ?
I HAVE A QUESTION WHEN I SELECT THE DATA THE GRAPH MOVES LIKE DHSJJD
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
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
How do we convert the duration to hours spent instead of days?
What mouse do you use? the sound is so soft...
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.
How to create gannt chart for frequently repeated actions like monthly weekly and yearly
could be hourly?
please send me same tamplate for my use