Need help with the Gantt Chart in the AIRT add-in?

You can create an AIRT MAGIC Excel Gantt chart in any open workbook. Just click on the ‘Airt’ menu option then select ‘Gantt’ in the chart section.

The AIRT MAGIC Gantt chart dialog box prompts you to select where to input the Gantt chart. A new sheet is inserted in your workbook in front of the selected sheet.

Next select the start year, end year, start month and end month for the gantt chart.

Demo data is included in the Excel gantt chart that is created. Input your own data for your project schedule applying the following method.

Project Phases

The phase of the project is required for all lines in the Gantt chart. Leave the ‘task’ blank in the first row for each phase (this will be a summary of the phase timeline).

The rest of the rows should have task names.

Relative Dates for Dependencies

You then have options with the details in the yellow Excel cells. You can just type start and end dates for each task if you wish. OR if the start of your task is dependent on the completion of another task, you can model this critical path by referencing the preceding task in the column F ‘Start’ field.

Make sure you enter the task name correctly followed by the offset for the new task using the format “ +1” or “ -7” for example. For example cell F13 text “Task 7 +1” refers to the task in row 12. Please note: you can only refer to tasks within the same phase of the project.

Rather than input a fixed end date for a task you can instead input the length of the task in days in the ‘Duration’ field (Excel column H).

Refer to the demo data for examples of how to do this.

Adding or Deleting Rows

If you need to input extra rows simply insert a number of entire rows above the bottom row of the Gantt chart. Then copy one of the existing entire rows and paste over the inserted range (this will ensure that all the Excel formats and formulas are maintained for the new rows).

When you have entered all your date just collapse the groups by clicking the “ – “ in the heading.