Hi,

I think this is a trivial problem, but I can't seem to get it to work.

I am trying to make a chart of a schedule for an event to see who has signed up for what time slots. The event goes from 8am to noon. People have signed up to volunteer some amount of time in that range.

For example, Person A can volunteer from 8:15am-9:00am.

I would like the graph to have the time range (8-noon) on the X-axis and their name on the Y-axis. The amount of time they are volunteering (45minutes) would then span the X-axis.

This is one of those things that take 2 seconds to draw by hand but I haven't figured out how to do it in Excel. I've tried bar and line graphs and the closest I've gotten is having the 8-noon appear on the X-axis, but then it only puts a point at 0.45 on the Y-axis (or draws a line from 0.45 at 8am and goes down to 0 at 9am). I set the X-axis to be Time, the Y-axis set to number.

Any help would be appreciated.

Thanks.