How to Create a Gantt Chart with Progress Tracking using Excel Charts

Easily add values of certain cells meeting certain cirteria.
Català - Castellano - Deutsch
I will show you on this video how I create Gantt Charts that allow to show project progress using simple Excel Stacked Bars Charts. I think it is easier to see it on the video but I will also explain the steps.
As you can see on the video. I am using an auxiliary table that has the needed data obtained from the main table to obtain the desired graphic. The data used is this. First the start date of each task. By doing this we can have each task to show at the start date. The trick to do this is to use this data but then select on the graphic to not fill the bars.
If you just want to show a gantt chart without progress you can simply use the Task duration information as the second set of data. But As I use this type of charts on monthly reports that need to show project progress, then the trick is to divide the Task between done days and pending days. This is done using three columns. One colum is the task duration that will give us the task size, the other the progress done and the other is the pending part of the task. In reality the task duration is not used as data but it works as a calculating numbers that at the end turn out to produce the total spread of the Progress done and pending.
Finally, I use the Progress real column were I manually enter the estimatd progress of each task but I turn it also invisible by not using fill and show the labels of this set of data.
With all this as you can see the Gantt Chart updated if I change any date on the start date column, If I cahnge any duration or if I change the progres done.
Hope you like it. please subscribe to the channel!

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...