GANTT Chart in Excel - Download and use

Do you know the GANTT chart helps us to do follow up for the events scheduled in the plan.

In excel the we can create the GANTT chart.  Click below to down load the GANTT  chart which would help to build a chart for your project.

GANTT chart - Down load the excel file


GANTT chart - Download excel file to work

When a project is under way, Gantt Charts help you to monitor whether the project is on  schedule. If it is not, it allows you to pinpoint the remedial action necessary to put it back on schedule. 


Sequential and parallel activities:
An essential concept behind project planning is that some activities are dependent on other activities being completed first. As a shallow example, it is not a good idea to start building a bridge before you have designed it! 
  
These dependent activities need to be completed in a sequence, with each stage being moreor-less completed before the next activity can begin. We can call dependent activities 'sequential' or 'linear'. 
  
Other activities are not dependent on completion of any other tasks. These may be done at any time before or after a particular stage is reached. These are nondependent or 'parallel' tasks. 


To draw up a Gantt diagram (Gant diagram), follow these steps: 

1. List all activities in the plan

2. Head up graph paper with the days or weeks through to task completion
3. Plot the tasks onto the graph paper
4. Schedule Activities
5. Presenting the Analysis

Down load the excel sheet and fill up the activities and dates in the respective columns.  The excel will plot the gantt chart for you. 

Please give your comments on this.


Key points:

Gantt charts are useful tools for planning and scheduling projects. They allow you to assess how long a project should take, determine the resources needed, and lay out the order in which tasks need to be carried out. They are useful in managing the dependencies between tasks. 
  
When a project is under way, Gantt charts are useful for monitoring its progress. You can immediately see what should have been achieved at a point in time, and can therefore take remedial action to bring the project back on course. This can be essential for the successful and profitable implementation of the project.