Product Features
Does Chart Gantt work on the Mac OS?
Chart Gantt is a cost effective solution to project planning for Mac users.
Excel 2007 versions of all Chart Gantt Products work perfectly on Mac Excel 2008 or later.
If you are using Mac Office 2004 or earlier, we do not recommend purchasing Chart Gantt Templates. Whilst the core features of the product work, the drop down lists, do not, due to a known compatibility issue with Mac OS Excel 2004.
What are the key differences between the Excel 2003 Versions and Excel 2007?
Excel 2003 has several limitations that impact on the functionality of Chartgantt. In addition to this, our customer base is now focused on 2007 or later and we have now (August 2010) ceased development of Excel 2003 products.
The 2003 versions lack the following functionality:
Upgraded graphical capability, colours and logo
Use of status indicators
Ability to insert columns anywhere
The option to schedule in either days or work days
Can I use the Auto-filter function with Chart gantt?
Yes! Auto filter works as usual with Chart gantt. You can filter your resources, start dates, or any variable you like. Be mindful to delete any blank rows before setting your filter so that it covers the area you are looking to filter.
Are both US and European Date formats supported?
Yes! Date formats are set in your system settings. The same file opened on two computers with different “Region” settings will show different date formats. Both DD/MM/YYYY and MM/DD/YYYY formats are supported.
Do Chart gantt products come in a variety of languages?
We are currently working on a multi-language version of Chart Gantt. This version will support: French, German and Spanish in addition to English. We expect to release the multi-language version in December 2010.
Are the templates fully unlocked?
The planning sheet is fully unlocked. There is a second sheet which performs back-end date calculations – this sheet is locked to ensure sheet integrity and faithful bar display. No customer has had an issue inserting content, new sheets or even changing drop down lists without access this back end sheet.
Can I insert columns and rows?
Yes! Both columns and rows can be inserted into every Chart gantt template. Some templates do have restrictions on where columns can be inserted, and the process for inserting a row. Instructions are provided within each template outlining any restrictions.
Show the Content
Yes! The logo can be simply deleted from the template. Just click on it, then press delete!
Can I create multiple plans in the one workbook and relate these together?
Yes! Simply select the bottom worksheet tab. Right click and select copy. This will create a second and fully operational version of your template in your workbook. You can then create links, between the two sheets as you normally would with an excel workbook. This feature is particularly useful if you are managing multiple projects. Consider also building your own multiple project status report as a new workbook that looks at each sheet an summarises the information for you.
Note: The view (Daily, Weekly and Monthly) and the planning window start date can only be set once in the workbook. This is set by changing these variables in the original “Project Planning” worksheet. The newly created plans will be fully functional for planning purposes. You may consider just using the original “Project Planning” worksheet as a control sheet for the rest of your plans.
I need more rows than the 200 planned rows, can I extend the number of planning rows?
Yes! Chart gantt can be extended to thousands of rows of planning. Ensure that you don’t just copy down beyond the 200th row. You need to insert rows prior to the 200th rather than copying down. The reason for this is that most templates use a Vlookup. This Vlookup has been set to 200 rows to prevent performance issues on slower computers. Merely copying down past the 200th row will not update the Vlookup formula, whereas inserting will.