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...