For anyone who would like to take the time to build their own excel based templates please see the below links and blogs.

In our view, all of these approaches are time consuming and allow for significantly less flexibility than the Chart Gantt solution.  However please explore these options if you are curious and have some time to kill.

  1. Building charts Using the Chart Function within MS Excel
  2. This approach whilst it does produce a clumsy result will draw gantt charts.  This approach does not allow for dependencies to be used at any stage. 

    http://office.microsoft.com/en-au/excel/HA010346051033.aspx

  3. Here is another way of establishing gantt charts in excel that bears no relationship to the types of projects I traditionally manage.  With Chart Gantt we have tried to build only the core functionality required rather than bells and whistles that complicate the application and reduce the breadth of its utility.

http://chandoo.org/wp/2009/06/16/gantt-charts-project-management/