How can I make a Gantt chart in Excel?

Question

I'm trying to produce a chart similar to a Gantt chart which effectively shows 1 line of information for all tasks, by teams within a project.

This link includes:

An linked image showing what I'm looking to achieve.
A worksheet that allows me to generate the image using some software called Tableau. However, ideally I want to be able to do something similar with excel 2010 as Tableau server costs a bomb.

Any suggestions would be greatly appreciated.

Tons of examples found via Google - did you try any of them? — Tim Williams, Aug 14 '12 at 20:29
I looked through google but didn't find anything of use... I'm not a good googler though... — Faraday, Aug 14 '12 at 20:34
You don't have to be very good - try "gantt chart excel" :) Here's one result worth checking: http://peltiertech.com/Excel/Charts/GanttChart.html — Doug Glancy, Aug 14 '12 at 21:06

score 4 · Answer 1 · answered Aug 14 '12 at 21:01

The new databars/sparklines features provide nice ways to do Gantt Charts and resource histograms, here’s a sample:

enter image description here

One way to achieve this is first set up your table, called A say, then to create the databars, set the min and max formulas equal to defined names Min:=MIN(A[Start])-A[@Start] and Max:=MAX(A[End])-A[@Start]+1.

You can copy down individually with the format painter to propagate. After create a separate range for the resources and add a column sparkline to a cell as shown.

How can I make a Gantt chart in Excel?

1 Answers1