Gantt Chart in Excel

Excel does not have a Gantt chart among the built-in chart types, but you can easily create one from a stacked bar chart. The picture below shows our initial data for building a Gantt chart.

Here’s what you need to do to create a Gantt chart:

1. On the Advanced tab Insert (Insert) click Insert bar chart (Bar) and select subtype Ruled Stacked (Stacked Bar).
2. Right-click on an empty construction area and in the context menu click Select data (Select Data).
3. Press Add (Add) and add two rows of data: “Start Date” and “Duration».
4. In the Horizontal axis labels (categories) (Horizontal (Category) Axis Labels) click Change (Edit) and select the range A4: A11.
5. Press OK.
6. Click on the legend on the right side of the chart and press the key Delete.
7. The stages of the project (Foundation, Walls, and so on) are in reverse order. To fix this, right-click on the task names in the diagram, in the context menu, click Axis Format (Format Axis) and check the box Reverse order of categories (Categories in reverse order).
8. Press Close (Close).
9. Right-click on any red rectangle of the chart, in the context menu select Data series format (Format Data Series) > Fill (Fill) > No fill (No fill).
10. Press Close (Close).
11. Dates and times in Excel are stored as numbers, starting from January 1, 1900. Those. date June 1, 2012 corresponds to the date 41061, and July 13, 2012 – the number 41103.Right click on the dates on the chart, in the context menu click Axis Format (Format Axis) and set the values:
    • Minimum (Minimum) equal 41061;
    • Maximum (Maximum) equal to: 41103 + the duration of the last task, i.e. 41103 + 2 = 41105;
    • for parameter Major divisions (Major units) enter a value 7.

    

12. Press Close (Close).

Result: Gantt chart built in Excel.

Please note that tasksPlumbing” and “Electric» can be performed at the same time.