Gantt Excel – Documentation: Customizing the Gantt Chart Timeline Colors

The Gantt Excel timeline includes Gantt bars and other colored shapes representing…

  1. Estimated Duration bar color
  2. Task Percentage Complete overlay bar color
  3. Baseline Duration bar color (turned off by default)
  4. Actual Duration bar color (turned off by default)
  5. Dependency Connector color
  6. Today(s) date Indicator color
  7. Task Border color

Default Colors

Default colors can be changed across the sheet by clicking on the Settings button in the Gantt tab.
You can double-click the default colors to any color of your choice and click the Update button.

The timeline will instantly update the default colors of all tasks with the newly selected colors.

Changing Colors of Individual Bars and Milestones

You can also change the color of each individual bar or milestone marker

  1. To do this, click on the Settings button in the Gantt tab within the excel ribbon and select the Columns tab.
  2. Un-hide the columns “Bar Color” & “% Color” and close the settings popup.
  3. Two new columns will show up in the timeline. Double click each cell to change the color of the gantt/ percentage bar.

Columns Settings

Note: You can also multi-select the cells, Use the “Fill” option in the Home tab of Excel and then right-click in the grid and select Redraw Timeline. This will update all the Gantt bars instantly.