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:

Please share this video with others that may find it useful:

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

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:

Overview: (0:00)
Set Up Project Table: (0:23)
Create Gantt Chart: (1:32)

[frankcardonasanchez]

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

[abderrahmaneazibi]

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

[poetraabadi]

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

[BlackRose_]

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

[bvasavi]

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

[enzovitaloni]

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

[virginiabotte]

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

[debieeo]

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

[edgarindainyapadi]

Absolutely wonderful. It was easy to follow!

[sharontyr]

Very clear and precise tutorial, thank you.

[gigupp]

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

[nawarajkhadka]

wonderful! you're a saviour man!!

[santoshshinde]

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

[annacolognese]

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

[sandeeptalwar]

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

[pawanrai]

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

[olabisiakinyele]

This video is excellent! Thank you for sharing!!

[deepaksingh-vtqt]

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

[monchlogoc]

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

[raphaeluzor]

Excellent tutorial! Thanks for sharing!