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.
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
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.
The bars are created using conditional formatting. To change bar colour, click on any cell in the bar chart window. Then on the home menu, click conditional formatting, manage rules. Select the rule you would like to change. Ensure that you set the text and the background to the same colour, so that you do not see the numbers that are driving your gantt chart bars.
Printing issues can be found with older mono printers and printer drivers. If Excel is not printing what you see on the screen, then this is an issue with your printer driver not adequately rendering the conditional formatting used to create the bars.
Some options and work-arounds if you are experiencing this issue:
Print to another printer
Update your printer driver
Copy the portion of your gantt chart you wish to print and paste it as an image in either Word or Powerpoint
Use the new save as PDF functionality in Excel 2007 or later. Then print the PDF.
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.
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.
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.
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.
Yes! The logo can be simply deleted from the template. Just click on it, then press delete!
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.
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.