BoostExcel main content

Gantt Chart Maker allows you to add custom column to the task list and use the new column as the labels on the chart. This, combined with Excel's powerful support for formulas, enables you to display very special text on the Gantt chart.

This tutorial shows you how to add a new column "Task and Duration" to the task list. The result is included in the "Wood.xlsx" template.

  1. First, open the Excel Gantt sheet for which you want to add the new task column.
  2. Click "Task List Columns" on the "Gantt Chart" ribbon tab.
  3. Click and select the column before which you want to add the new column.
  4. Click "Insert". Enter the column heading of the new column. In this case, it is "Task and Duration". Note the column heading (name) must be unique, i.e., it cannot conflict with any existing columns.

    Create custom column using the task list window

  5. The new column is added to the heading list. The Excel sheet is also updated to include the new column.
  6. This is an optional step: Use the "Move Up" and "Move Down" button to change the column location; use the "Hide" and "Unhide" buttons to make the column hidden or visible.
  7. One done, click the "Close" button to return to the Excel Gantt sheet.
  8. Click and select the first cell of the task and duration column.
  9. Enter the following formula. It means to combine the task name cell and duration cell.

    =CONCAT(E8," (",M8,")")

    Create formula for the custom column

  10. Now click the "Refresh" command on the ribbon. It fills the formula into all the following cells.
  11. To display the new custom on the chart, first click "Project Options" on the ribbon.
  12. Choose "Task and Duration" for the "Show this column data as labels on the chart".

    Use the custom column on the Gantt chart

  13. Click "OK". The Gantt chart is updated automatically to use the new label.
  14. To persist the changes, save the Excel file.