Gantt Chart In Excel Format: The Advantages

By Author: Salvatore Andrea
Total Articles: 6261
Comment this article

The Gantt chart is a bar chart that saw the light of the day due to the efforts of Henry Gantt. If there is a need to illustrate a project schedule then the importance of these charts can at no stage be undermined. It does illustrate the start and finish dates of the terminal and summary elements of a project. It is a revolutionary concept and does help in the working process of an organization. There are plenty of ways to create a Gantt chart. However, if there is a desire to achieve perfection one can always create a gantt chart in excel.
The major disadvantage is that excel does not contain an in-built format of a Gantt chart.

However, if there are plans one will have to create it by customizing the stacked bar chart type. The process of creation is very easy. First enter sample data. The next function involves creating a stacked bar chart. Finally one must make sure that the chart looks like a Gantt chart. If the need be one can opt for additional formatting. excel gantt chart is ideal if there is a desire to manage measure or ...
... track the various aspects of a project.

The Gantt chart is used to show current schedule status using percent complete shadings. The vertical today line is also shown there. These are common techniques for representation phases of work. They provide a complete breakdown so that they are understood by audiences all over. However, there are certain limitations. If these are small projects it hardly matters.

However, if there are over 30 activities involved then this chart simply will not work. Larger Gantt charts are not suitable for computer displays. These charts focus on schedule management. Hence, they represent only a part of the triple constraint of time, cost and scope. These are some deficiencies, which must be looked into.