Gantt chart in Excel, how to create, how to draw Gantt chart in Excel

You are the manager often have to manage projects with many jobs, so you want to use the Gantt chart in Excel to better manage projects. If you do not know how to draw Gantt chart in Excel, please refer to the following article.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 1

The following article TipsMake.vn will guide you how to draw Gantt charts in Excel, please follow along.

Gantt chart in Excel?

Gantt chart (English is Gantt chart ) is a form of showing the most classical project progress, invented by Henry Gantt in 1910. Although this chart is long time ago but due to its simple nature, it is easy to understand. Currently Gantt charts are still widely used in project management, even improved in modern project management software.

How to draw a Gantt chart in Excel

To draw a Gantt chart your data needs a start date, an end date, and a time period to complete each job.

Suppose you have a data table to draw a Gantt chart like this:

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 2

Based on the above data table, you can start drawing Gantt chart in Excel with the following steps:

Step 1: Create a stacked bar chart based on 'Start date'

Select the range from C4 to C10 ( Start date column ), then select the Insert tab , in the Charts you select the column chart and select the stacked bar chart as shown below.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 3

So you've drawn the bar chart.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 4

Step 2: Add data in the Time Completion column to the stacked bar chart.

1. On the chart, right click and select Select Data.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 5

2. Select Select Data Source window appears , click Add to open Edit Series.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 6

3. Appear to Edit Series, you need to enter a name or choose a name in the Series name section (for example, enter Interval or select the title box in the Time to complete table ). Next in the Series values section, select the symbol as shown below.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 7

4. Click and hold and select the data area in Completed Time column (E5: E10).

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 8

5. Next to return to the previous interface you press Enter , then click OK -> OK to close Edit Series and Select Data Source.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 9

So you will see the chart adds a new section as follows:

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 10

Step 3: Add a job description

1. Open the Select Data Source window again by right-clicking the chart and selecting Select Data.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 11

2. The Select Data Source window appears, click Edit in the Horizontal section .

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 12

3. On the dialog box Axis Labels you click the data in the column Work done (B5: B10). Then click OK -> OK to close the Axis Labels and Select Data Source dialog boxes .

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 13

You will see the job done on the chart.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 14

Step 4: Hide the green column to make a Gantt chart.

1. On the chart, left click on any blue bar so all blue bars are selected, right click and choose Format Data Series.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 15

2. Now the Format Data Series section appears on the right, in the Fill & Line section select No fill and No line as shown below.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 16

So your chart is as follows:

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 17

Step 5: Remove the space before.

The part you just hidden still leaves a space, you can remove this space by:

1. On the data sheet, right-click the first cell in the Start Date -> Format Cells.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 18

2. In the Number tab of Format Cells, select the General format, see how to store the date you choose in Excel in the Sample section .

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 19

3. Next, on the chart, right click on the date, and choose Format Axis (or double click on the date).

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 20

4. In the Format Axis section on the right, at the Axis Options section enter the numbers in the Sample section that you saw above into the Minumum box . So you will see the whitespace has been removed.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 21

Step 6: Clear the space between horizontal bars.

1. On the chart, click on any orange bar to select all orange bars, right-click on it and select Format Data Series.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 22

2. The Format Data Series section on the right appears, in the Series Options you set in the Series Overlap you to 100%, your Gap Width to 0%. So you'll see the space between the horizontal bars will be gone.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 23

You can shrink the height of the chart to make the Gantt chart more beautiful as shown below.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 24

Step 7: Reorder the data in accordance with the Work done

You also see on the chart, the work order has been reversed, so you need to rearrange the data in the right order, the right steps to do by:

1. Right-click on the Tasks section and select Format Axis or double-click on the Tasks section on the chart.

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 25

2. The Format Axis section appears on the right side of Excel. Check the box in the box before the Categories in reverse order box and close Format Axis .

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 26

You will get the Gantt chart as follows:

Gantt chart in Excel, how to create, how to draw Gantt chart in Excel Picture 27

Above is how to draw Gantt charts in Excel, hope through this article you will better understand Gantt charts and know how to draw Gantt charts in Excel. Good luck!