Excel Timesheet Chart

[twofive]

I'm having trouble producing a timesheet bar graph in Excel. What I'd like is to have Names along the y axis and Workday(time) along the x. I'm having problems since I'm trying to map Names versus two columns for Start and End time. Please see attachment for raw excel data versus a rendering of the chart I'd like produced from this data. Thanks in advance!

 

[combo]

It would be simpler if you use start time and duration. Next create stacked chart with transparent first series (no border, no interior filling).

combo

 

[ajrimmer]

Have a trawl for how to produce an Excel Gantt Chart (eg here

http://office.microsoft.com/en-us/excel/HA010346051033.aspx

)

OK, you'll be wanting to work in hours, rather than days, but the principles will be similar.

 

[twofive]

Thanks, ajrimmer, the info in that link was what I needed. Also, thanks to combo, who basically stated the same thing