Gantt Chart using MS Excel

Tags

, , , , , , , , ,

MS Excel can be used as an alternative to track small projects in the absence of either MS Project or Primavera. This is an effective method of project management for small and medium size projects for whom it becomes installing advanced software a costlier affair.

Let us understand how to create Gantt Chart in MS Excel for a small construction project.


Consider the below activities of constructing a one floor residential building (without considering any holidays).

143

To draw the Gantt Chart, follow the below procedure.

Select the range B2:D17 and go INSERT > BAR > STACKED BAR as shown below.

144

We can see that the tasks are in reverse order. Right click the tasks on the chart, click Format Axis and check ‘Categories in reverse order’ and click CLOSE.

145

Right click on the Blue Bars > Format Data Series > Fill > No Fill > Close

146

The final Gantt Chart is obtained as below.

147