Project followup with Gantt charts in excel

Gantt charts are great for getting an overview of projects (or even processes with multiple tasks that needs to be executed in order). This type of chart was developed in the 1910s by Henry Gantt and it can be used to show dependencies between activities or where you may have bottlenecks. I can recommend the Wikipedia article about Gantt charts if you would like to know more, since this blog post will focus on how to create Gantt charts in excel.

Usually you create Gantt charts in project management tools like Microsoft Projects or Ganttr.com, but you can of course also create them in excel (hence this blog post 😉 ). To start we need to have some data and here we have five phases (inspired by Project Management Institute, Inc) with start date and also a duration in days for each phase (you could replace the phases with activities instead if you have a small project).

Project data for Gantt chart

Under the insert tab, select stacked bar chart.

Gantt chart type

Under the Design tab in Chart Tools select “Select Data” to select the data we want to use.

gantt_select_data

Add two series (one for “Duration in days” and a second for “Start Date”). Add the phases or the activities as horizontal axis labels. Reverse the order of “Duration in days” and “Start Date” so you have “Start Date” above “Duration in days”.

gantt_data_select_series

Now you should have something that looks like this

gantt_chart1

 

Since the phases are in the wrong order we need to fix that. Right click on the axis with the phases and select “Format Axis”, then check “Categories in reverse order”:

gantt_categories_reverse_order

Now we need to hide the red bars, because we only use them to make the blue bars show up in the right place. Right click on the red bar and select “Format Data Series”, then select “Fill” and check “No fill”:

gantt_hide_red_bars

Remove the legend and format the chart a little bit, and you have your project plan in a Gantt chart 😉

gantt

Here’s the excel file I used in this example if you would like to see how I did this.

Leave a Reply

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