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

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: createCreate Gantt Chart and cash flow using excel with sample file. Read more ... » a table contains your activity name, start date, duration and finish date.

&nbspRequirement Management Plan Template. Read more ... »;


 

Step no. 2:from theHeads Up WHAT'S THE FIRST WORD YOU SEE?. Read more ... » excel bar choose insert tape, then bar then choose stacked bar

Step No.2

Step No.2

 


Step no. 3: right click in the chartCreate Gantt Chart and cash flow using excel with sample file. Read more ... » area and choose select data.

Step no. 3

Step no. 3

 

 


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

 

Step No.4

Step No.4

 

 

 


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

Step No.5

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.6

 

 


Step no. 7: edit the horizontal axis values .

Step No.7

Step No.7

 

 


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

 

Step No.8

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.9

 

 


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

Step No.10

Step No.10

 

 


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

 

Step No.11

Step No.11

 

 


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

 

Step no. 12

Step no. 12

 

 


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

Step no. 13

Step no. 13

 


Step no. 14: now you have a ganttCreate Gantt Chart and cash flow using excel with sample file. Read more ... » 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

Create a Gantt Chart with Excel-Step No.14

 


 

Download the Gantt excel templateProgress planned vs actual progress excel template. Read more ... »:

 

  • Share on Social Networks

Comment (1)

  • Hasan Jlelaty Reply

    thank you

    Jan 16, 2013 at 2:23 pm

Leave a comment

Your email address will not be published.

Password Reset
Please enter your e-mail address. You will receive a new password via e-mail.