BoostExcel main content

Custom Column and Label - Gantt Chart Maker for Excel

Our Gantt Chart generator allows you to add custom columns to the task list and use the new columns as 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 to 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 that 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" buttons to change the column location; use the "Hide" and "Unhide" buttons to make the column hidden or visible.
  7. Once 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 with the 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 "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 keep the changes, save the Excel file.