Stacked Bar chart excel 2011

Hi

this is probably the simplest way to do a gantt chart in excel - there are many more complex versions. Its limitation is that the value axis is actually time, so unlike a conventional time series chart you can't set the axis label intervals to eg months.

In the attached version the start value is actually series 1 in a stacked column with 3 series, but with series 1's fill and line colour set to none so it's invisible, leaving the completed and finished hours the only visible series. End time is not a series, it's derived by adding the start time, hours completed and hours outstanding.