Gantt chart with progress

Excel 365 2016 2013 2007
Gantt chart is a horizontal bar chart that is often used in project management applications.
The Gantt Chart with progress in Excel 2010

In the classic Gantt chart (see Creating a Gantt chart), horizontal axis represents the total time span of the project, and each bar represents a project task. The viewer can quickly see the duration of each task and identify overlapping tasks. To create the Gantt chart with progress, follow these steps:

   1.   Select the data range, for example A2:B10; E4:F10:

Data Chart

   2.   On the Insert tab, in the Charts group, select the Bar button and choose Stacked Bar to create a chart:

Stacked Bar Chart in Excel 2010

   3.   Remove the Legend and do one of the following:

  • On the Design tab, in the Data group, choose Select Data:
    Data in Excel 2010
  • Right-click in the chart area and choose Select Data... in the popup menu:
    popup in Excel 2010

In the Select Data Source dialog box:

  • Correct data in Horizontal (Category) Axis Labels. Notice that Excel incorrectly uses the first two columns as the Horizontal (Category) Axis Labels.
  • In the Legend Entries (Series) group, add a new data series. Then set the chart's series to the following:
    • Series 1: $B$4:$B$10
    • Series 2: $E$4:$E$10
    • Series 3: $F$4:$F$10
    • Horizontal (Category) Axis Labels: $A$4:$A$10
Select Data Source in Excel 2010

   4.   Customize vertical and horizontal axes (for more details see Creating a Gantt chart).

   5.   Right-click in the every of data series and choose Format Data Series... in the popup menu:

Data Series popup in Excel 2010

To make the first data series invisible, in the Format Data Series dialog box:

  • On the Fill tab, set Fill to No fill
  • On the Border Color tab, set Border Color to No line

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

To add the label to your chart, do the following:

  1. Add new data series with data range D4:D10
  2. Right-click in the new data series and choose Add Data Labels in the popup:
    popup to add data labels in Excel 2010
  3. Right-click in the new data series labels and choose Format Data Labels... in the popup menu
  4. In the Format Data Labels dialog box:
    • On the Label Options tab:
      • In the Label Contains group, select Value
      • In the Label Position group, select Inside Base
    • On the Number tab, in the Category list, select Custom, enter format that you want in the Format Code field and press Add:
      Format Data Labels in Excel 2010

      For more details see Conditional formatting of chart axes.

  5. Make the new data series invisible.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more