Blog

How to create Gantt Chart

How to create Gantt Chart

                      

                                     Gantt chart is the visualization of details of Project Management, but in Microsoft Excel not offering the Gantt chart but we are creating the stacked bar chart.

 

Step-1

Create the Table with Task which we need to complete with the starting date and ending date

 

 

 

 

Step-2

Calculate the days between the starting date and ending date.

 

 

 

Step-3

On the Insert tab, click Bar and select Stacked Bar.

 

 

 

 

 

Step-4

Click Add and add the two Series (Start Date and Duration),Click under the horizontal category and the select the Task range. Right click the tasks on the chart, click Format Axis and check 'Categories in reverse order'.

 

 

 

 

 

 

 

 

Step-5

Dates and times are stored as numbers in Excel and count the number of days since January 0, 1900. 1-Nov-2016 is the same as 42675. 29-Nov-2016 is the same as 42710.

Right click the dates on the chart, click Format Axis and set the Minimum to 42675, Maximum to 42710

 

 

Step-6

 

 Right, click the blue bars, click Format Data Series, Fill, No fill.

Now the Gantt Chart is finished and we can easily analyze the project with starting date and duration for the activity

 

 

 

 

 

 

 

Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.