Gantt Chart Example

Gantt Chart in Excel is used to visually represent the plans and schedules of a project. It is a project management tool that shows how the project is performing in different time intervals.

Though Gantt chart is not an inbuilt chart by default, we can create Gantt charts with ease in simple steps.

For example, consider the below data.

For the given data, we can create Gantt chart in Excel as shown in the below image.

In this article, let us learn how to create Gantt chart in Excel with the following examples.

The following Gantt chart examples outline the most common Gantt charts in Excel. It is impossible to provide a complete set of examples that address every variation in every situation since there are thousands of such charts. Instead, each Excel example of the Gantt chart offers a step-by-step methodology for creating such a chart, relevant reasons, and additional comments.

Though MS Excel does not have a Gantt as a chart type, we can create it with the help of the Excel "Insert column chart" or "Bar chart" in the "Insert" menu of the "Chart" section. It is very simple for any task-related or time-bound project to track and monitor daily. In addition, it provides many feathers that make it easy to digest the chart.

Example #1: How To Create A Gantt Chart In Excel

Summary of Example 1

A user wants to create a Gantt chart for the course completion of their student. As a result, they can easily understand and track the status of course completion day-by-day by updating the table data. Therefore, it will reflect the same in the Gantt chart.

If a user wants to make a Gantt chart more attractive, they can choose different bar colors, gridlines in Excel, labels, and more to do in the chart with the help of the "Format Chart Area" menu. But, of course, it will be more attractive to the reviewer, whoever will see the chart.

Example #2: How To Create And Customize The Gantt Chart In Excel

Some projects are going on in some different locations in India, and project details have some entries like "Project Name," "Project Duration (in Months)," and "Completed Status (in Months)."

For example, a user wants to create a Gantt chart of the project completion from the project details table.

Step 1: We must first open the MS Excel and go to Sheet2, where the user keeps the project's data.

Step 2: As the user wants to create a Gantt chart of the project completion, select the table data, cells A2 to C8.

Step 3: Now, click on the "Insert" - click on the "Insert Column or Bar Chart" of the chart toolbar, then select the "Stacked Bar" chart.

Step 4: Change the color from the chart menu as per requirement.

Step 5: Now, provide the chart title as ‘Project Completion Gantt Chart.’

Step 6: Now select the chart - click on the blue strip of the chart - right click on the chart - one pop up will be open. Select "Format Data Series" - One side menu bar will be available.

Step 7: Go to "Fill" and "Line" menu - select "No fill" under the "Fill" options.

Step 8: There are many options available to change the chart color, "Fill," "3D Format," "Chart Property," and the size of the chart.

Step 9: Click on the worksheet and save it.

Summary of Example 2

A user wants to create a Gantt chart for project completion of the different projects. As a result, they can easily be understood and track the status of project completion day-by-day by just updating the table data. It will reflect the same in the Gantt chart.

If a user wants to make a Gantt chart more attractive, they can choose different bar colors and add new gridlines, labels, and more to work in the chart with the help of the "Format Chart Area" menu. Consequently, it will be more attractive to the reviewer, the people who will see the chart.

Example #3

For example, consider the below table showing different phases of a project.

Let us learn how to create Gantt chart in Excel.

First, we need to find the duration using the formula = End Date-Start Date.

Then, click on "Insert"- "Insert Column" or "Bar chart" of the chart toolbar. Then, we must select the "2-D Bar" under "Stacked Bar" - the basic chart will appear on the worksheet.

Change the color from the "Chart" menu as per requirement.

Now, select the chart - click on the blue strip of the chart - right click on the chart > one pop up will be open.

Go to the "Fill" drop-down from the menu pop up - select "No Fill."

As soon as the chart is inserted, it will look like the one below.

Likewise, we can create Gantt Chart in Excel.

• When a project is going on, and the resource manager or supervisor wants to track the team's work progress, he can plot a Gantt chart of his resources in the project. Then, through the project, the supervisor can follow the work progress and ensure the smooth workflow of the team.
• If a team leader knows the team's work progress by the Gantt chart, he can plan for the future task by seeing the chart.

• The "Legend" of the Excel chart is not more important than the Gantt chart. It does not have much information as we delete other parts of the data.
• If a user is making any change in the table data, the chart will change automatically to the changes made in the table data.
• MS Excel does not have a Gantt as a chart type, but we can create it with the help of the "Inset Column or Bar Chart" stacked bar chart. So, it does have inbuilt capabilities to develop also.
• If users do not want a chart title, they can remove it by clicking on the chart title and deleting it.
• There is no MS support for the Gantt chart. A user needs to change as per their requirement.
• A user can customize his Gantt chart by choosing different bar colors and adding new gridlines, labels, and more to do in the chart with the help of the "Format Chart Area" menu.