Me and Gantt chart!

For one of my university’s projects I needed to plan a schedule. A lecturer of mine suggested the Gantt chart as a good instrument. To be frank I already had no idea about what exactly is and how does a Gantt chart work! So I surfed the internet and found lots of practical information about the Gantt chart and how to take it into account for project planning. Now I’m going to share them with you, maybe you either find it a useful and practical tool.

A Gantt chart is a type of bar chart that illustrates a project schedule. Gantt charts illustrate the start and finish dates of the terminal elements and summary elements of a project [*]. This graphical representation shows duration of tasks against the progression of time.


In the following example there are seven tasks, labeled A through G. Some tasks can be done concurrently (A and B) while others cannot be done until their predecessor task is complete (C cannot begin until A is complete). Additionally, each task has three time estimates: the optimistic time estimate (O), the most likely or normal time estimate (M), and the pessimistic time estimate (P). The expected time (TE) is computed using the formula (O + 4M + P) ÷ 6.

Once this step is complete, one can draw a Gantt chart or a network diagram.



It is a common instrument for project planning and keeping track of the condition of individual tasks within a project. This type of chart was invented in 1910 by a mechanical engineer named Henry Gantt, and there are now a great many software tools that use Gantt charts in project planning. Excel is a popular tool for creating Gantt charts, but for more advanced project management activities, you may need a tool such as Microsoft Project or a project management add-in for Excel (download link / tutorial video).

There are lots of helpful videos on; you just need to do a quick search.

Making a Gantt chart in Excel 2007

25 thoughts on “Me and Gantt chart!

  1. Till yesterday i was with office 2003, just installed office 2007 and came across this wonderful Gantt chart in Excel 2007 article..have downloaded the video! Expecting many more from you!!


  2. Kareem Gegenheimer says:

    Excellent blog. I was checking constantly this blog and I am quite impressed! Extremely useful info specially the last part. I care for such information a lot. I was looking for this particular information for a very long time. Thank you and good luck.


  3. This is really interesting take on the concept. I never thought of it that way. I came across this site recently which I think it will be a great use of new ideas and informations. Thanks a lot.


  4. Latrice says:

    Its not my first time to pay a quick visit this website,
    i am visiting this web page dailly and obtain fastidious data from here everyday.
    regards Propolis


  5. I have to thank you for the efforts you’ve put in writing this site.

    I really hope to view the same high-grade content by you later on as well.

    In fact, your creative writing abilities has inspired me to get
    my own, personal site now 😉


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s