Creating a Gantt chart

Excel 2016
A Gantt chart is a horizontal bar chart often used in project management applications like Microsoft Project. In the Gantt chart, the horizontal axis represents the total time span of the project, and each bar represents a project task: the left edge indicates the beginning moment of the activity, and the right edge indicates the estimated ending moment. The viewer can quickly see the duration of each task and identify overlapping tasks.

Gantt charts are convenient for planning and estimating the project's expected duration. In addition, they allow you to keep track of the activities that can be carried out in parallel to each other:

The Gantt Chart in Excel 365

Although Excel doesn't support Gantt charts per se, creating a simple Gantt chart is fairly easy. The key is getting your data set up properly.

For example, the above Gantt chart is set up to illustrate a schedule for the project, in range B2:D9:

Data of Gantt Chart Excel 365
  • Column B contains task names,
  • Column C contains the corresponding start date for each task,
  • Column D contains the duration of the task, in days.

To create a Gantt chart in Excel, follow the next steps:

Create a bar chart

   1.   Select the data range.

For this example, B2:D9.

   2.   On the Insert tab, in the Charts group, click the Insert Bar or Column Chart button:

Insert Bar or Column Chart in Excel 365

From the Insert Bar or Column Chart dropdown list, select Stacked Bar:

Stacked Bar in Excel 365

Correct the chart data

   3.   Do one of the following:

  • 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:

Select Data Source in Excel 365
  • Under Horizontal (Category) Axis Labels, click the Edit button to correct data for the horizontal axis:

    In the Axis Labels dialog box, change data to the appropriate data range (task names). For example, B3:B9:

    Axis Labels in Excel 365
  • Under Legend Entries (Series) group:
    • Ensure that the existing data series contain the correct data range (task duration) — for example, D3:D9.
    • Create a new data series for the start date by clicking the Add button.

      In the Edit Series dialog box, type or select the appropriate data. For example, C3:C9:

    Axis Labels in Excel 365
  • Reorder data series by clicking the moving buttons:
Select Data Source dialog box in Excel 365
  • The first data series: data range for starting date,
  • The second data series: data range for the duration.

Customize the horizontal axis

   4.   Right-click on the horizontal (Category) axis and select Format Axis... in the popup menu:

Format Axis popup in Excel 365

On the Format Axis pane, in the Axis Options tab:

  • In the Axis Options section, set the Minimum and Maximum values to correspond to the earliest and latest dates in the data. You also may want to set the Major unit to 7 to indicate weeks:
    Format Axis in Excel 365
  • In the Number section, choose the Date format you prefer:
    Format Axis in Excel 365

Customize the vertical axis

   5.   Change the order of tasks on the vertical axis:

   5.1.   Right-click on the vertical (Value) axis and select Format Axis... in the popup menu.

   5.2.   On the Format Axis pane, in the Axis Options group:

  • Under Horizontal axis crosses, select the At maximum category option,
  • Select the Categories in reverse order checkbox:
Format Vertical Axis in Excel 365

Hide the first data series

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

Format data series in popup menu Excel 365

To make the first data series invisible, on the Format Data Series pane, on the Series Options tab, in the Fill & Line group :

  • In the Fill section, select No fill,
  • In the Border section, select No line:
No fill and No line in Format Data Series Excel 365

Apply another chart formatting as desired.

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

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.