Gantt Chart Builder (Access) 3.0.2

Gantt Chart Builder (Access) 3.0.2 provides a system to build professional quality Gantt charts without the need for Microsoft Project or similar products.

Charts can be constructed with either Microsoft Excel or Access. This version is the Access version. Quite often, your data is present in a database and the production of such charts has been extremely difficult without expensive addons.

Excel charts can be constructed and then exported in either image or spreadsheet format. This allows all the features and flexibility offered by Microsoft Excel to be used with your constructed Gantt chart. Full control is available on the colour of each individual line item. That is to say, if you like, each and every bar can be a different colour. Therefore, significant items can be highlighted to your audience. Resolution available is from yearly down to hourly.

Major Functions:

1. Building the chart itself. This option will allow you to select the desired date bands illustrated below.
2. Clear the chart,
3. Access to the Builder Toolbox. This provides options to automatically populate roll-up tasks and also to automatically mark milestones based on the dates provided.
4. Configure the chart presentation options. See below for a sample view of this control.
5. Print & Print Preview the constructed chart,
6. Copy the selected chart as an image format. This allows the chart to be pasted into almost any other toolset.
7. Export the chart into another external workbook. This creates a sheet that is independent of the GBS toolset.

Major Features:

1. System Pre-requisites: The Gantt Chart Builder System (GBS) is based on Microsoft® Excel®. GBS is fully compatible with Microsoft® Excel® 97, 2000, XP, 2003, and 2007 version of Excel®.
2. Building a Chart: Below is a sample of the data required by the Gantt chart builder;
3. The only mandatory data is the start and finish dates identified in columns “F” and “G”, all other information is entirely optional. The above data gives the Gantt chart illustrated at the top of this page.
4. Operation of the Gantt builder is simple, with two toolbars providing access to all the GBS functionality. The functions available are as follows:
5. Building the chart itself. This option will allow you to select the desired date bands illustrated below.
6. Clear the chart,
7. Access to the Builder Toolbox. This provides options to automatically populate roll-up tasks and also to automatically mark milestones based on the dates provided.
8. Configure the chart presentation options. See below for a sample view of this control.
9. Print & Print Preview the constructed chart,
10. Copy the selected chart as an image format. This allows the chart to be pasted into almost any other toolset.
11. Export the chart into another external workbook. This creates a sheet that is independent of the GBS toolset.
12. Chart Date Ranges: The Gantt chart can be constructed with a number of pre-specified date bands, these are yearly, quarterly, monthly and weekly. Illustration of these controls are below:
13. Configuration Dialog: Many attributes of the charts themselves are fully configurable, as illustrated below:
14. Access Based Version: Charts such as that depicted above can be constructed from data present within Microsoft® Access® tables.
15. The Gantt Chart Builder System provides a system to build professional quality Gantt charts without the need for Microsoft® Project or similar products. Charts via Access Reports such as that depicted here can be constructed from data already available in a Microsoft® Access® database, and allows all the features and flexibility offered by Microsoft® Access®.
16. Full control is available on the colour of each individual line item. That is to say, if you like, each and every bar can be a different colour. Therefore, significant items can be highlighted to your report's audience.

Enhancements: Added the ability to display resource profiles + bug fixes.

Requirements: Microsoft Access 97/2000/XP/2003/2007

WareSeeker Editor