It should be fast and easy for an input user to use.ĥ. It should be as automated as possible to remove risk of input or transposition errors.Ĥ. It must be simple for other users to interpret.ģ. It must be an accurate representation of your plan.Ģ. To further de-construct the formula’s on the main planning page, consider purchasing a Chartgantt template.Īn effective gantt chart has the following key features:ġ. This workbook is designed as a self-guided tour, no further support will be provided by Chartgantt. All other features are able to be created. Due to limitations on earlier versions of excel, the status field will not be able to be used by 97-2003 users. The workbook has been developed for Excel 2007 or later users. Alternatively, you may wish to add specific features that are unique to your template requirements. You may decide to omit features that are included in Chartgantt Basic, particularly if you are only planning to create one or two small projects with your template. This guide will assist you to develop your own version of Chartgantt Basic.ĭepending on your level of proficiency with excel, the construction of your gantt chart would be expected to take between 4 and 12 hours.
This workbook is designed to be used in conjunction with Chartgantt Free, which will act to guide your development efforts. The workbook will provide the advantage that you will understand the exact construction of your gantt chart, its capabilities and limitations. It has been developed for Excel users that are familiar with complex formula and sheet construction. Users may use this workbook to build their own Gantt Chart in excel, or they may use it to better understand the construction of the Chartgantt products. It is expected that many users will just use elements of this workbook to construct their own gantt chart. USING THIS WORKBOOK TO CREATE AN EXCEL GANTT CHART TEMPLATE
It acts as a simple and effective way of visualising your project and communicating the tasks and timelines to others. The graphical nature of a Gantt Chart has enabled it to become the standard across language barriers.Īn effective Gantt Chart lets you see immediately what should have been achieved at any point in time. A Gantt Chart is a standard way of visualising time that is widely accepted across the world.