9 July 2007

Making a Gantt Chart with Excel

Making a gantt chart is a basic technical skill for project managers. It helps you work out who will be doing what and when. It also helps you identify dependencies; for example you need to know your requirements before you design your solutions.

There are plenty of purpose specific tools out there, Microsoft project being the most ubiquitous, but they are also notoriously complex once you start getting into the more advanced features.

I am also a fan of scaling your tools to the project you are on, and of learning the basics of the technique before you defer it to technology. So, in that vein, here is a tutorial I found at Youtube on how to create a project gannt chart in Excel.


  1. Anonymous10:52 am

    This comment has been removed by a blog administrator.

  2. Anonymous6:56 am

    I have been working in a advertisment business for about 4 years and we found a solution that does this. We use it for wireless GPS tracking and bar code reading. We can customize the forms on-the-fly such as wireless inspection forms. Company name is Westlake out of Los Angeles I think. There is a website www.westlakesoftware.com. Their product is call AirMobility.net. They made a custom Extranet for us for our company to use but their main product site is www.airmobility.net. Pretty easy service to setup for us to migrate the information to our back office system. We use the technology and route it to 40 different servers nationally; has worked flawlessly for about three years. I would definitely recommend them.
    Sarah Smith, VP IT