Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Gantt Chart
4
Gantt Chart
By Akram, Sarah, Tarah
What Is It?
How To Create a Gantt Chart
Gantt Chart is a chart in which a series of horizontal lines shows the amount of work done or production completed in certain periods of time in relation to the amount planned for those periods - Google
Step By Step to Create a Gantt Chart
How It Is Used?
3
1
Format Your Gantt Chart
Create a Task Table
A Gantt chart can be used to produce a measurable timescale for a project, when each activity begins and ends, how long each activity is scheduled to last, where activities overlap with other activities, and by how much, and the start and end date of the whole project.
2
Build a Bar Chart
4
1
2
3
5
Click in the empty Series name: form field first, then click on the table cell that reads Start Date.
Select Insert, and then click on the Bar chart icon. When the drop-down menu appears, choose the flat Stacked Bar Chart.
Under Legend Entries (Series), click Add. This will take you to the Edit Series window.
Click on the icon at the end of the Series values field. The icon is a small spreadsheet with a red arrow (the lower icon). This will open the Edit Series window.
Add Start Date data by positioning your mouse over the empty Excel chart and right click. Then, left click on Select Data. The Select Data Source window will appear.
6
7
8
9
Click in the empty Series name: form field first, then click on the table cell that reads Duration.
Click on the first Start Date and drag your mouse down to the last Start Date. After the right dates are highlighted, click on the icon at the end of the Edit Series form. The window will close and the previous window will reopen. Select OK. Your start dates are now in the Gantt chart.
Next, add the Durations column using the same procedure you used to add the start dates.
Under Legend Entries (Series), click on Add.
Click on the icon at the end of the Series values field. The icon is a small spreadsheet with a red arrow. This will open the Edit Series window. Click on the first Duration and drag your mouse down to the last Duration. After the durations are highlighted, click on the icon at the end of the Edit Series form. The window will close and the previous window will reopen. Select OK. Your durations are now in your Gantt chart.
10
11
12
Change the dates on the left side of the chart into a list of tasks.
Click on any bar in the chart, then right click, then open Select Data.
Under Horizontal (Category) Axis Labels, click on edit
Using your mouse, highlight the names of your tasks. Be careful not to include the name of the column itself, Task.
Click on OK.
Click OK again.