Gantt Chart in Excel with example

Gantt Chart in Excel with example

Gantt Chart

A Gantt chart is a type of bar chart that illustrates a project schedule, named after its inventor, Henry Gantt, who designed such a chart around the years 1910–1915. Modern Gantt charts also show the dependency relationships between activities and current schedule status.

The main purpose of Gantt chart is to represent timeline of any project. Which can include task, start date, due date, effort time etc. In this article we will create a Gantt chart by using following data:

Step 1: On the Insert tab, click Bar and select Stacked Bar. It will result in default chart as shown below:

Step 2: Right click on Chart Area and select Select Data as shown below:

Step 3: The default series are plotted looks like:

Step 4: Click on Edit button under Legend Entries (Series) and select Start Date and say OK

Step 5: Click on Edit button under Horizontal (Category) Axis Labels and change series as shown below and say OK:

Step 6: Now Add new series to plot Effor in Hrs column as shown below:

Step 7: Right Click on the vertical axis ->Format Axis->Axis Option. Click the check box “Categories in reverse order” as shown below .This will reverse the chart.

Step 8: Right click on the Blue Bars>>Format Data Series, under Fill click “No fill” Under Border click “No line” as shown below:

Note: In Above chart if you notice the dates till 8-Jul we did not made any plan hence we can minimize the Gap by manipulating Axis as shown below:

The date value can be converted into Numbers using “=Value()” function which will help manipulating Axis bounds Min and Max values.

Step 9: you can adjust the gap by using Axis gap option as shown below to format chart more readable. Select the series and right click Format Data Series:

Post adjusting the Axis and Gap Width the chart should look like as below:

Please leave your comments or queries under comment section also please do subscribe to out blogs to keep your self upto date.

Leave a Reply

Your email address will not be published. Required fields are marked *