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