Gantt chart in Excel (Table of contents)
Gantt Chart in Excel
Gantt Chart in Excel is the most valuable tool or chart type by which we can create a complete project schedule and also we can create schedule any part of project or process with tasks to be performed in that. Basically, Gantt chart shows the duration of each activity and task and when a task or activity will start and to be scheduled to complete and other subsequent tasks after those shown with horizontal bars with start and end dates. This also shows the milestones reached in any project with dates and remaining work.
Below is an Image of Gantt Chart in Excel.
How to Make a Gantt Chart in Excel?
Gantt Chart in Excel is very simple and easy to create. Let understand the working of Gantt Chart in Excel by some Examples.
Steps to Make Gantt Chart in Excel
For a Gantt Chart to illustrate a timespan for the task of the project we need a table for the tasks and time defined. For Example, I need to start a new classroom for teaching. Below are the steps which will follow.
- Search for a place to open a class (Time allotted to me: 5 Days)
- Finalize the deal for the place (Time allotted: 2 Days)
- Purchase Furniture’s (Time Allotted: 2 Days)
After going through all the above three steps then I can start teaching to students. Assume the start date for the first task is today i.e. 30th Nov. Lets make the table in Excel.
The table looks like this,
From the above table, it is clear that I can start teaching from 9th of Dec after completing all the tasks. Now how do we show the above table in the Gantt Chart? Let us name this steps of making Gantt Chart process as “PROCESS” and bifurcate them in different steps:
- Go to Insert Tab.
- In the charts group, Go to Bar Charts and select 3-D stacked bar chart(we can choose either 2-D or 3-D, but 3-D gives better illustration so let us stick with it).
- We see a blank chart and we need to input values in it.
Right click on the chart and select “Select Data”.
- In the legend entries(Legend Entries means a data which is located on the right-hand side of the chart) we can see an add button.
- Click on it and an Edit series pops out.
- In the series name, select the date cell & in series values remove the default value and select the range of date.
- We need to add a new series so, we again go to add button and in series name, we will select “Time allocated” & in series value the range of Time allocated.
- After clicking ok, we are again back to our select data dialog box. In the horizontal axis, label click on an edit button.
- In the axis label range select all the tasks.
- We have all our data so we can select ok in the select data source tab and the chart looks like this,
- There is a problem in the chart, our tasks are not in order and our tasks start from 30-Nov not from 24-Nov. To Fix this click on Tasks and then right click and select “Format Axis”.
- In the right-hand side, a dialog box appears. Click on Categories in reverse order highlighted. This will arrange the tasks in the right order.
- Now the date isn’t the date we wanted. In excel, Date is in number format. In any blank cell type our start date and in the home tab in numbers group, it is by default selected as custom. Select a number and we see the number for our start date. Now right-click on a date in the chart and select format axis.
- In the right-hand side of the dialog box, there is a section of Minimum Bound Values which is the start point of our dataset by default. Change it with the number format of our date we want.
- Now our project has not yet been started but the blue bar shows the completion of the task so to remove that right click on the blue bar and go to format data series.
- In the Fill section select “No Fill”.
- Now we have prepared our first Gantt Chart.
Gantt Chart Examples
Let’s understand more about Gantt Charts in Excel with some examples.
Example #1
A developer needs to automate a program or say make a software for a client. He needs to research first in the needs of software for the client then gather the data after that he analyze it to make the code and test it and then finally it will be ready. The software is to be delivered by 21st of Dec.
Below is the data table for the developer.
Now we follow the “Process of making Gantt charts in Excel”.
- Go to Insert Tab & In the charts group, Go to Bar Charts and select 3-D stacked bar chart(we can choose either 2-D or 3-D.
- In the legend entries(Legend Entries means a data which is located on the right-hand side of the chart) right click on the Chart and we can see a “Select Data” option.
Click on “Select Data” a pop-up menu will appear in that go to Legend Series> Add.
4.8 (6,355 ratings)
View Course
- Click on it and an Edit series pops out.
- In the series, name selects the date cell & in series value remove the default value and select the range of date.
- We need to add a new series so, we again go to add button and in series name, we will select “Time allocated” & in series value the range of Time allocated.
- After clicking ok, we are again back to our select data dialog box. In the horizontal axis, label clicks on the edit button.
- In the axis label range select all the tasks.
- Click on Tasks and then right click and select “Format Axis”.
- In the right-hand side, a dialog box appears. Click on Categories in reverse order highlighted.
- Click on the blue bar and go to format data series.
- In the Fill section select “No Fill”.
- Below is the Gantt Chart for the developer.
Example #2
A boss needs to start a new department for his company. He will first make a flowchart to the initial steps to show his partners then make the guidelines, after that he can hire workers and train them.
Below is the data table for the company’s boss.
Let us follow the same process of making Gantt Charts in Excel:
- Go to Insert Tab & In the charts group, Go to Bar Charts and select 3-D stacked bar chart(we can choose either 2-D or 3-D.
- In the legend entries(Legend Entries means a data which is located on the right-hand side of the chart) we can see an add button. Click on it and an Edit series pops out.
- In the series, name selects the date cell & in series value remove the default value and select the range of date.
- We need to add a new series so, we again go to add button and in series name, we will select “Time allocated” & in series value the range of Time allocated.
- After clicking ok, we are again back to our select data dialog box. In the horizontal axis, label clicks on the edit button and in the axis label range select all the tasks.
- Click on Tasks and then right click and select “Format Axis”. In the right-hand side, a dialog box appears. Click on Categories in reverse order highlighted.
- Click on the blue bar and go to format data series. In the Fill section select “No Fill”.
- Below is the Gantt Chart for the company Boss.
Along with the various uses of the Gantt Chart, there are some Pros and Cons to it. Let’s discuss it one by one,
Pros of Gantt Chart in Excel
- Gantt Chart Gives a clear illustration of project status.
- It helps to plan, coordinate.
- It is highly visible.
Cons of Gantt Chart in Excel
- Gantt Chart does not show task dependencies. If one task is not completed a person cannot assume how is it going to affect the other tasks.
- The size of the bar does not indicate the amount of work, it depicts the time period.
- They need to be constantly updated.
Things to Remember
- Data table needs to be made for a Gantt Chart.
- Tasks need to be in ascending order.
- Start date needs to be the first task start date.
Recommended Articles
This has been a guide to a Gantt Chart in Excel. Here we discuss its uses and how to create Gantt Chart in Excel with excel examples and downloadable excel templates. You may also look at these useful functions in excel –