How to create a Gantt chart for project management in Excel

For complex projects that involve a lot of work to be done, the Gantt chart is one of the smart choices. Excel does not support creating Gantt charts, but you can create a Gantt chart in Excel . The following article will show you how to create a Gantt chart in Excel.

1. What is a Gantt chart?

The Gantt chart is a graph that is often used to manage projects smartly, which is one of the common ways to present time-based activities (tasks or events). Each activity is denoted by a long bar, with a Start Date, a Time (Duration) and an end date (End Date).

More reference: Instructions for creating charts in Excel 2007 or 2010

2. How to create a Gantt chart in Excel

1. Create a work breakdown table

Each activity in your project has a start date, time, and end date. In the table illustrate a project below the items including the activity names, start date, time and end date.

How to create a Gantt chart for project management in Excel Picture 1

2. Insert bar chart

On the Menu , select Insert , then click the Bar chat icon (bar chart).

A Menu appears, select Stacked Bar Chart ( stacked bar chart).

How to create a Gantt chart for project management in Excel Picture 2

Add start date data (Start Date Data):

1. Right click on the blank chart location. Then click on Select Data . A Select Data Source window appears.

2. Under Legend Entries (Series) , click on Add to open the Edit Series window.

How to create a Gantt chart for project management in Excel Picture 3

3. Click on the first field in the Series name section, then click on the boxes on the start date table.

How to create a Gantt chart for project management in Excel Picture 4

4. Click the icon at the bottom of the Series values field (the red arrow icon is in a table) to open the Edit Series window .

How to create a Gantt chart for project management in Excel Picture 5

5. Click on the first line and drag down the last line in the Start Date section.

After the item is blacked out. Next, click on the red arrow icon in the table at the end of Edit Series . The current window will close and open a previous window. You just need to click OK.

How to create a Gantt chart for project management in Excel Picture 6

So the first day data was created in the Gantt chart

See also: How to keep the cells fixed in Excel?

Add data to the Duration Data:

The steps are similar to adding data to the start date entry.

1. Under Legend Entries (Series) , click Add.

2. Click on the first field in the Series name section, then click on the cells in the time table.

3. Click the icon at the bottom of the Series values field (the red arrow icon is in a table) to open the Edit Series window .

Click on the first time box, drag the mouse down to the last time box in the timeline. After the item is selected, next click on the red arrow icon in the table at the end of Edit Series . The current window will close and open the previous window. You choose OK.

How to create a Gantt chart for project management in Excel Picture 7

Your time data has been added on the Gantt chart.

You can change the date on the left side of the chart

1. Click on any bar on the chart, then right-click, open Select Data.

2. Click Edit under the Horizontal (Category) Axis Labels.

How to create a Gantt chart for project management in Excel Picture 8

3. Black out the names of the jobs in your chart. Note, do not black out the job list field (Task).

How to create a Gantt chart for project management in Excel Picture 9

4. Click OK , then click OK

Your Gannt chart will look similar to the illustration below.

How to create a Gantt chart for project management in Excel Picture 10

3. Gantt chart format

You can customize the created Gantt chart by adding grid lines, labels, or changing the bar color or the way the values ​​or text display with the chart tool.

- Note, the work in your chart is arranged in reverse order. To fix this, simply click to select the task list then right-click, choose Format Axis and select Categories in reverse order, then select Close.

How to create a Gantt chart for project management in Excel Picture 11

- To hide the green color on each bar, right click on the blue bar, choose Format Data Series , then select Fill and select No fill.

Click on Border to select No Line.

- To delete empty spaces at the beginning of the Gantt chart:

  1. Click on the first line in the Start date section in the data table. Hold and drag to the last line to select it, then right-click and choose Format Cells, then choose General . Remember to note the number line you see in the Sample section.

How to create a Gantt chart for project management in Excel Picture 12

  1. On the Gantt chart , select the date on the chart bar and then right-click and choose Format Axis.
  1. In the Minimum section, enter the number you noted in the previous section.
  1. Section Major you should choose the unit of 2.
  1. Then select Close to complete the editing process.

How to create a Gantt chart for project management in Excel Picture 13

- If you want the Gantt chart to look better, you can delete the white spaces between the bars:

  1. Click on the first orange chart bar.
  1. Right-click then select Format Data Series.
  1. Separated 100% and Gap Width settings are 10%.

How to create a Gantt chart for project management in Excel Picture 14

Once completed, your Gantt chart will look like the following illustration:

How to create a Gantt chart for project management in Excel Picture 15

Good luck!

5 ★ | 2 Vote

May be interested

  • How to Create a Multi-Line Chart in ExcelHow to Create a Multi-Line Chart in Excel
    drawing a multi-line chart in excel is very simple! if your spreadsheet has multiple groups of data, you can view the data visually by creating a chart with multiple lines. you can create a new chart or add lines to an existing chart. this article will show you how to create a multi-line chart
  • How to make a thermometer template in ExcelHow to make a thermometer template in Excel
    using a thermometer chart in excel is a good choice for keeping track of financial goals. here are detailed step-by-step instructions on how to make a heat chart in excel.
  • How to create 2 Excel charts on the same imageHow to create 2 Excel charts on the same image
    the combination of 2 charts on the same excel image helps users easily show the data.
  • Steps to create graphs (charts) in ExcelSteps to create graphs (charts) in Excel
    the following article shows you the steps to create a chart (chart) in excel 2013. step 1: select the data to create a chart (for example, here you want to create a sales chart of employees - click employee name column and sales) - insert - select the type of table
  • Create Excel charts that automatically update data with these three simple stepsCreate Excel charts that automatically update data with these three simple steps
    excel charts help shorten the decision-making process, because we can immediately see the results and things to change. however, the difficulty in processing data and charts is that users must constantly return to the chart and update new data. yes, this problem will be gone when you follow these three simple steps to create an excel chart that automatically updates data.
  • How to use pictures as Excel chart columnsHow to use pictures as Excel chart columns
    excel offers a variety of chart types. however, you don't have to use columns; you can use images instead to make your charts more appealing.
  • How to Create a Bar Chart in ExcelHow to Create a Bar Chart in Excel
    wikihow will show you how to present data in microsoft excel more eye-catching and attractive with bar charts.
  • Instructions for inserting, drawing and creating charts in Word 2007Instructions for inserting, drawing and creating charts in Word 2007
    in addition to the fact that we often work and create charts on excel, sometimes you will have to conduct charting in word content.
  • How to Make a Pie Chart in ExcelHow to Make a Pie Chart in Excel
    this wikihow teaches you how to create a visual representation of your data in microsoft excel using a pie chart. open microsoft excel. it resembles a white 'e' on a green background.
  • Steps to reset chart in ExcelSteps to reset chart in Excel
    the following article shows you the steps to reset the chart in excel 2013. after creating the chart, if you do not like the selected chart style, you can do the following to change the chart type the simplest and fastest way: step 1: sign