14 easy steps to create a gantt chart with Excel in 3 minutes

14 easy steps to create a Gantt chart with Excel in 3 minutes, just follow the steps shown in the photos and you can download the sample excel template.

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 300x185 14 easy steps to create a gantt chart with Excel in 3 minutes

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

Create a Gantt Chart with Excel Step No.2 300x211 14 easy steps to create a gantt chart with Excel in 3 minutes

Step No.2

 

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

Create a Gantt Chart with Excel Step No.3 300x181 14 easy steps to create a gantt chart with Excel in 3 minutes

Step no. 3

 

 

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

 

Create a Gantt Chart with Excel Step No.4 300x168 14 easy steps to create a gantt chart with Excel in 3 minutes

Step No.4

 

 

 

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

Create a Gantt Chart with Excel Step No.5 300x154 14 easy steps to create a gantt chart with Excel in 3 minutes

Step No.5

 

 

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

Create a Gantt Chart with Excel Step No.6 300x131 14 easy steps to create a gantt chart with Excel in 3 minutes

Step No.6

 

 

Step no. 7: edit the horizontal axis values .

Create a Gantt Chart with Excel Step No.7 300x167 14 easy steps to create a gantt chart with Excel in 3 minutes

Step No.7

 

 

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

 

Create a Gantt Chart with Excel Step No.8 300x129 14 easy steps to create a gantt chart with Excel in 3 minutes

Step No.8

 

 

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

 

Create a Gantt Chart with Excel Step No.9 300x165 14 easy steps to create a gantt chart with Excel in 3 minutes

Step No.9

 

 

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

Create a Gantt Chart with Excel Step No.10 300x212 14 easy steps to create a gantt chart with Excel in 3 minutes

Step No.10

 

 

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

 

Create a Gantt Chart with Excel Step No.11 267x300 14 easy steps to create a gantt chart with Excel in 3 minutes

Step No.11

 

 

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

 

Create a Gantt Chart with Excel Step No.12 300x178 14 easy steps to create a gantt chart with Excel in 3 minutes

Step no. 12

 

 

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

Create a Gantt Chart with Excel Step No.13 272x300 14 easy steps to create a gantt chart with Excel in 3 minutes

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 300x176 14 easy steps to create a gantt chart with Excel in 3 minutes

Create a Gantt Chart with Excel-Step No.14

 

 

Download the Gantt excel template:

xlsx 14 easy steps to create a gantt chart with Excel in 3 minutes
Title : Creat Gantt Chart in Excel
Caption : Creat Gantt Chart in Excel
File name : Creat-Gantt-Chart-in-Excel.xlsx
Size : 15 kB

 

Project Management Professional Templates 200+

BOX001 m 14 easy steps to create a gantt chart with Excel in 3 minutes

 

share small 14 easy steps to create a gantt chart with Excel in 3 minutes

Related Posts