How to Add New Rows ?

METHOD 1: USING THE RIBBON MENU From the ribbon menu, click on « Add Tasks » then pick the desired option: Add below: a new task will be added below the selected row Add above: a new task will be added above the selected row After the last row: a new task will be added after the last row of the task group Customized menu: an advanced …

How to Change the Starting date of the Gantt Chart ?

To change the start date of the gant chart, use the ribbon menu: Or the left menu: You may consider to just click on « Auto »: the macro will automatically look for the earliest date in your planning and set it as a starting date. From time to time, you can click on this icon to reflect the latest updates you make to your …

How to Input the Start Date of a Task ?

MANUAL INPUT You can manually input any date as a starting date of task. Select the appropiate cell and type the starting date. If there is already another date or another formula inside this cell, you can safely overwrite it. Once you update the starting date, the gantt chart will reflect automatically this new input. USING THE MENUS: You can …

How to Input a Duration ?

Inputting a duration is quite straight forward: just select the appropriate cell and input the desired number of days. The gantt chart will be updated automatically. The Gantt Chart will also consider which working days you selected: Monday to Friday or Monday to Sunday. The end date is automatically calculated via a formula which uses: The Starting date The Duration …

How to Update the Progress Status of a Task ?

From the drop down list, select the progress status of any sub-task. You can also manually input any value you would like by selecting the cell and entering the desired percentage. This information will be used to check if a task is on-track or in delay: If the task is behind the red line (a line which reflects your specified …

How to Assign a Responsible Person ?

For any task, you can choose from a drop down list the name of the responsible person. If the name of the responsible person is not in this list, you can over-write manually any name you would like to. The drop-down list is based on the informations about project members. This list can be accessed by a click on « Tools » …

How to re-number the tasks ?

When you add a new set of tasks, the Gantt Chart Maker use the previous task number and increment it: If the previous task number is not numerical, then the new series is numbered with 1: To update the numbering (e.g: after a while the tasks are not numbered correctly, you would like to use your own numbering system), you can …

How to Modify the « Baseline » Date ?

The purpose of the Baseline is to highlight in the gantt chart a specified date that serve as a reference for the complete planning. This date is not necessary the actual today’s date: if your presentation is in 2 weeks, you may consider to already set the baseline to a future date and see how the chart will look like. The baseline is …

How to Force the Gantt Chart to Refresh the View ?

With some computers, it is possible that the Gantt Chart does not refresh properly or frequently enough: Although you update a starting date, a duration or a status, the Gantt Chart does not reflect these updates Although you add a flag, the flag does not appear etc We added a special feature to force Microsoft Excel to refresh all the …

How to Change the Language ?

From the ribbon menu, click on « Languages » and then select your language. Currently, six languages are available: English, French, Spanish, German, Dutch and Portuguese. Did you find a solution to your question ? Link to the contact form Back to the top of the page