Project Management Guide

 lindsay sherwin logo

          OverviewScoping a ProjectOn Project ManagementGuidance Helpnotes

Guidance Helpnotes
bullet Scoping a Project
bullet Drawing Planning Charts
Stages Diagram (Word)
Gantt Charts (Word)
Gantt Charts (Excel)
Milestone Plans (Word)
Microsoft Project
Word Drawing Tools
Template WORD Gantt 1
Template WORD Gantt 2
Template EXCEL Gantt
bullet Estimating Guidelines
bullet Implementation Planning
bullet Managing Contractors
bullet Project Communications
bullet Communications Strategy
bullet Communicating Change
bullet Success Checklist
bullet Project Leadership Tips
bullet Project Leadership Article

      Print Button 

© Copyright 2007
Lindsay Sherwin

Click here to access the Lindsay Sherwin Homepage and further toolkits.

Using EXCEL to make a GANTT chart

Generally, I find EXCEL less useful for such charts than WORD is. It really has few advantages over using a Table and Drawing Tools in WORD, however I do know that some prefer it. Below is one layout people have found useful, particularly for the initial thinking.

Activities

May

June

July

August

Sept

Oct

Nov

Dec
Decide on TQM Kick-Start

X

 

 

 

 

 

 

 
Steering group Chosen

X

X

 

 

 

 

 

 
Start Staff Climate Survey

 

 

 

 

 

 

 

 
Steering group Trained

 

 

 

 

 

 

 

 
Start Customer Surveys

 

 

 

 

 

 

 

 
Visits to other companies

 

 

 

 

 

 

 

 
Staff Climate Survey Complete

 

 

 

 

 

 

 

 
Train  Other Managers

 

 

 

 

 

 

 

 
Complete Awareness Training

 

 

 

 

 

 

 

 
Facilitators Trained

 

 

 

 

 

 

 

 
10 QATs formed & working

 

 

 

 

 

 

 

 

You can either simply place an "X" in a cell or shade the cell in as shown above.

Templates for this are Template Excel Gantt