Many users start building their excel gantt charts using conditional formatting as shown on a range of videos on youtube etc.

One of the key issues with this approach is that they tend to use the gantt chart as both an input and a reporting engine.  Ie.  The user inputs tasks, resources and dates, and the system just outputs a project plan or gantt chart.

There are three primary reports that should be a key function of any gantt chart, whether created in excel or a proprietary planning package....
Continue reading ...