This is where MS Excel has some very substantial advantages in preparing gantt charts. The major, and over-riding advantage is flexibility. With excel you can decide what you want to calculate and how you want to calculate it. If you want to convert 368 minutes into one day, then you can do this quite simply. If you want to view resources, or not view them you can either hide or delete the resource column.
Due to the flexibility of excel many project managers start their planning in excel, attempt to transfer their plan out in to project or some other planning tool. Then when they are trying to manage the project, they bring the data back into excel again for manipulation.
Therefore the question must be, that if you could create the graphical capabilities of a gantt chart in excel rather than a customises project planning solution, then surely you could streamline the process.
Rather than exporting data in and out of tools, just stay in the one tool that gives you the flexibility to do exactly what you want, in the way that you want to do it. To this end we have developed the Chartgantt.com gantt chart template. This provides all the graphical capabilities you may expect from a fully featured gantt charting software solution, but with the added flexibility of excel. Our customers find that this approach can save them days of frustration, and reduce the room for error in the planning process.
Make your planning process sing, use a gantt chart template for excel rather than fussing about with a dedicated project planning solutoin
About the Author
Marcus Tarrant is an accomplished management consultant, who has managed both small and very large projects and programmes. He is the developer of the chartgantt excel gantt chart templates, and believes that more can be done in excel than people know is possible.