Progress Gantt chart with events

Excel 2016
Gantt chart is a pervasive project management tool intended to reveal task management problems. Besides creating tasks on the Gantt chart, you can enrich it with additional information like project milestones, presentation dates, and similar events.

If you need to create a simple Gantt chart, see Creating a Gantt chart or Gantt chart with progress.

In this tip, we will show how to add events to your Gantt chart:

The Gantt Chart with events in Excel 365

To add the events in the existing Gantt chart, do the following:

Add a new data

   1.   Add the events into your spreadsheet and select this data range.

For example, the cells $B$11:$C$14:

Data Chart in Excel 365

Add the new data series to the chart

   2.   Do one of the following:

  • Select the chart, then on the Chart Design tab, in the Data group, choose Select Data:
    Select Data in Excel 365
  • Right-click on the chart area and choose Select Data... in the popup menu:
    Select Data in popup menu Excel 365

In the Select Data Source dialog box, click the Add button, then in the Edit Series dialog box:

  • Optionally, in the Series name field, type the data series name,
  • In the Series values box, type the constant values for each point in the new data series with events.

    These constants will determine the vertical position of events. For example, they can be placed:

    • in a horizontal line, = {1,1,1,1},
    • in a curved line, = {1,2,3,4}:
Select Data Source in Excel 365

Change the data series chart type

   3.   Right-click on any data series and choose Change Series Chart Type... in the popup menu:

Change Series Chart Type in Excel 365

In the Change Chart Type dialog box, for the new data series, choose the Scatter type (the Secondary Axis checkbox is selected automatically):

Change Chart Type in Excel 365

Correct the new data series

   4.   Right-click on the chart area and choose Select Data... in the popup menu. In the Select Data Source dialog box, select the new data series and click the Edit button.

In the Edit Series dialog box, in the Series X values box, type or select the cells with events ($C$11:$C$14):

New Data Series in Excel 365

After closing the dialog boxes, Excel rebuilds the chart:

Gantt chart in Excel 365

Hide the secondary vertical axis

   5.   Right-click on the secondary vertical axis and select Format Axis... in the popup menu (or double-click the axis):

Format Axis popup in Excel 365

On the Format Axis pane, on the Axis Options tab, in the Labels section, from the Label Position list, choose None:

Hide axis in Format Axis pane in Excel 365

Customize the new data series

   6.   Right-click on the new data series and choose Format Data Series... in the popup menu:

Format data series in popup menu Excel 365

On the Format Data Series pane, on the Series Options tab, in the Fill & Line group:

  • Under Marker, in the Marker Options section, select the Built-in option, then:
    • From the Type dropdown list, select a marker type that you want. For example, insert a picture:
      Fill Marker with picture in Excel 365
    • In the Size field, type or select the appropriate size for the marker.

You can then make any other adjustments to get the expected look.

See also this tip in French: Comment créer un diagramme de Gantt avec des événements.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.