Create a gantt chart with Excel in 3 minutes

FOLLOW THESE SIMPLE 14 STEPS AND DOWNLOAD GANTT CHART TEMPLATE AT THE END OF THIS POST.

Step No. 1: create a table contains your activity name, start date, duration and finish date.

Create a Gantt Chart with Excel-Step No.1

---

Step no. 2:from the excel bar choose insert tape, then bar then choose stacked bar

Step No.2

---

Step no. 3: right click in the chart area and choose select data.

Step no. 3

---

Step no. 4: from the select data window click Add.

Step No.4

---

Step no. 5: Add the start date values into the series values.

Step No.5

---

Step no. 6: Add a new value same we did in step no. 4 for the duration.

Step No.6

---

Step no. 7: edit the horizontal axis values .

Step No.7

---

Step no. 8: add the activities names in the horizontal axis values.

Step No.8

---

Step no. 9: after adding all the data as per steps no. 5,6,7 and 8 just click OK

Step No.9

---

Step no. 10: Right click on the blue bar and choose format data series.

Step No.10

---

Step No. 11: from the fill menu choose no fill

Step No.11

---

Step no. 12: right click on the axis include the activities name and choose format axis

Step no. 12

---

Step no. 13: from axis options check categories in reserve order.

Step no. 13

---

Step no. 14: now you have a gantt chart matching with your data in step no. 1, whenever you change any date or duration the bar chart will be changed automatically.

Create a Gantt Chart with Excel-Step No.14

---

Download the Gantt excel template:

• Title: Creat Gantt Chart in Excel 
  Caption: Creat Gantt Chart in Excel 
  Filename: Creat-Gantt-Chart-in-Excel.xlsx 
  Size: 15 kB