Gantt Chart Example

Gantt Chart Examples in Excel

The following  Gantt Chart examples provide an outline of 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. Each excel example of Gantt Chart provides a step by step methodology to create such a chart along with relevant reasons and additional comments as needed.

Though MS Excel does not have a Gantt as a chart type, however, we can create with the help of the ‘Excel Insert column chartExcel Insert Column ChartColumn chart is used to represent data in vertical columns. The height of the column represents the value for the specific data series in a chart, the column chart represents the comparison in the form of column from left to right.read more or Bar chart’ in the insert menu of the chart section. It is very simple to use for any task related or time-bound project to track and monition day by day. It provides many feathers that make it easy to digest the chart.

Gantt Chart Example

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Gantt Chart Example (wallstreetmojo.com)

Example #1: How to Create a Gantt Chart in Excel

There is a company called ‘ABC Classes, Bangalore, ’ which has Student details like First Name, Course Duration (in Days), and Course Completed (Days).

For example, A user wants to create an Excel Gantt chart of course completion from the Student details table.

  1. Open the MS Excel, go to sheet1 where Student details are kept by the company.


    Examples Gantt Chart 1

  2. As the user wants to create a Gantt chart of the Student course completion, so select the table data. Which is cell A1 to C13.


    Examples Gantt Chart 1-1

  3. Go to the menu bar of the Excel and click on the insert > click on the ‘Insert Column or Bar chart’ of the chart toolbar. Then Select the 2-D Bar under Stacked Bar > basic chart will appear on the worksheet.


    Examples Gantt Chart 1-2

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


    Examples Gantt Chart 1-3

  5. Now provide the chart Title as ‘Course Completion Gantt Chart.’


    Examples Gantt Chart 1-4

  6. Now select the chart > click on the Blue strip of the chart > right click on the chart > one pop up will be open.


    Examples Gantt Chart 1-5

  7. Go to the Fill drop-down from menu pop up > select No fill.


    Examples Gantt Chart 1-6

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


    Examples Gantt Chart 1-7

  9. Click on the worksheet and save it.


    Examples Gantt Chart 1-8

Summary of Example 1: As the user wants creates a Gantt chart for course completion of there student, as a result, they can easily understand and track the status of course completion day by day by just updating the table data. The same will be reflected in the Gantt chart.

If a user wants to make a Gantt chart more attractive, he can do by choosing different bar colors, Gridlines in ExcelGridlines In ExcelGridlines are little lines made of dots to divide cells from each other in a worksheet. The gridlines have slight faint invisibility; you can find it in the page layout tab. This option has a checkbox; for activating the gridlines, you can tick on it and untick if you wish to deactivate gridlines.read more, labels, and more to do in the chart with the help of format chart Area menu. It will more attractive to the reviewer are the people who will see the chart.

Example #2: How to create and customize the Gantt chart in Excel

There is some project going on in some different locations of India, which project details have some entry 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: Open the MS Excel, go to sheet2, where the user kept data of the project.

Chart 2

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

Chart 2-1

Step 3: Click on the insert > click on the ‘Inset column or Bar chart’ of the chart toolbar then select the Stacked Bar chart.

Chart 2-2

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

Chart 2-3

Step 6: Now, provide the chart Title as ‘Project Completion Gantt Chart.’

Chart 2-4

Step 7: 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 open.

Examples Gantt Chart 2-5

Step 8: Go to Fill & Line menu > select No fill under the Fill options.

Chart 2-6

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

Step 10: Click on the worksheet and save it.

Chart 2-7

Summary of Example 2: As the 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. The same will be reflected in the Gantt chart.

If a user wants to make a Gantt chart more attractive, he can do by choosing different bar colors, adding new gridlines, labels, and more to do in the chart with the help of the format chart Area menu. It will more attractive to the reviewer are the people who will see the chart.

When to Use a Gantt Chart

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

Things to Remember

You can download this Gantt Chart Example Template here – Gantt Chart Example Template

Recommended Articles

This has been a guide to Gantt Chart Example. Here we discuss How to create and customize the Gantt chart in Excel and downloadable Gantt Chart example template. You may also look at these useful functions in excel –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *