• Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • Windows
  • Mac
  • iOS
  • Android
  • Office
Home » Excel » How to Create Gantt Chart in Excel

How to Create Gantt Chart in Excel

By: Waseem Patwegar

Developed by Henry L. Gantt in 1917, Gantt charts are widely used to plan, coordinate and track the progress of activities required to complete a project. You will find below the steps to Create Gantt Chart in Excel.

Create Gantt Chart in Excel

Create Gantt Chart Using Excel

In simple terms, Gantt chart can be defined as a visual representation of activities or tasks scheduled over a period of time.

In a typical Gantt Chart, the Horizontal axis (X-Axis) represents the time to complete the project, while the Vertical axis (Y-Axis) represents the activities or tasks required to complete the project.

Depending on reporting requirements, the time span on the X-Axis is broken down into Days, Weeks or Months.

Microsoft Excel does not offer a ready to use option or a template for Creating Gantt Charts. However, it is easy to Create Gantt Chart in Excel by modifying a Stacked bar Chart.

Steps to Create Gantt Chart in Excel

Follow the steps below to first insert a blank Stacked Bar Chart, add the required data to this chart and modify the resulting bar chart into a Gantt Chart Format.

1. The First step is to get your Data organized in an Excel worksheet.

Data For Gantt Chart

As you can see in above image, list of Activities, Start Dates and the Number of days required to complete individual activities have been listed in separate columns.

2. Now, click on the Insert tab, click on the Bar Chart icon (2) in ‘Charts’ section and select Stacked bar (3) option in the drop-down menu. This will insert a blank Stacked Bar Chart in your worksheet.

Insert Stacked Bar Chart in Excel

3. Next, click on Chart Design tab and click on Select Data option located in the ‘Data’ section.

Select Data Option in Excel Chart Design Tab

Note: If you do not see Chart Design tab, click on the empty Stacked bar chart in your worksheet.

4. In Select Data Source dialogue box that appears, click on the Add option.

Add Option in Select in Excel Charts Data Source Dialogue Box

5. In Edit Series dialogue box, type Start Date (1) as Series Name, select Data range containing the Start Dates (2) as Series values and click on OK.

Enter Start Dates For Gantt Chart in Excel

6. Click again on the Add option in select Data Source dialogue box.

Add Option in Excel Charts Select Data Source Dialogue Box

7. This time, type Duration (1) as the Series Name, select the data range containing Durations (2) and click on the OK button.

Add Activity Durations to Gantt Chart in Excel

8. In ‘Select Data Source’ dialogue box, click on the Edit option located in the right-pane (Axis Labels).

Edit Option in Excel Charts Select Data Source Dialogue Box

9. In Axis Label dialogue box, select the Data range containing the Activity Names (1) and click on OK.

Add Activity Names to Gantt Chart in Excel

10. Click on OK to close the ‘Select Data Source’ dialogue box and you will end up with Stacked Bar Chart with activities in the reverse order.

Stacked Bar Chart With Activities in Reverse Order

11. To correct the order, right-click on the Vertical Axis and select Format Axis option in the drop-down menu.

Format Vertical Axis of Stacked Bar Chart

12. In Format Axis box that appears, scroll down to ‘Axis Position’ section and select Categories in reverse order option.

Set Categories in Reverse Order Option in Excel Bar Charts

13. Now, right-click on the Horizontal Axis and select Format Axis option in the drop-down.

Format Horizontal Axis Option in Excel Bar Charts

14. In Format Axis box, enter the Minimum Value as 01 May (Start Date of Project). After this, scroll down to the ‘Labels’ section and select High as the Label Position.

Set Minimum Value and Label Position For Stacked Bar Chart in Excel

15. Finally, select the Blue bars in the Chart and remove the Colour Fill and Border (if present).

Remove Colour Fill From Stacked Bar Chart

16. Your Gantt Chart is now ready.

Gantt Chart Created Using Microsoft Excel

You can change the Title and Format the Gantt Chart as required for your presentation or sending it for review.

Related
  • How to Create Waterfall Chart in Excel
  • How to Use VLOOKUP Function in Excel

You May Also Like
    • Prevent Outlook From Adding Calendar Events
      How to Prevent Outlook From Adding Calendar Events
      • Show Developer Tab in Excel Ribbon Menu
        Add or Show Developer Tab in Excel Ribbon Menu
        • Set Out of Office Message in Microsoft Teams
          How to Set Out of Office Message in Microsoft Teams

Primary Sidebar

Twitter
Facebook



Popular Now

  • How to Reduce Cellular Data Usage on iPhone
  • How to Backup Registry in Windows 11/10
  • How to Check Computer Specs in Windows 10
  • How to Remove Bloatware From Windows 10 PC
  • How to Create Local Account in Windows 11



Gadget Guide

  • Mac vs PC Comparison: Should You Buy Mac or PC
  • Chromebook vs Windows Laptop
  • Kindle E-Reader Comparison | Which Kindle to Buy
  • iPad vs iPad Pro Comparison
  • Advantages of Chromebooks

About | Privacy Policy | Disclosure | Terms | Contact
© Copyright 2022 @Techbout.com · All Rights Reserved