Challenging Date & Time graph request

[pamaga]

Hello all,
I seem to remember an old thread on this subject, but I have searched this forum for a solution and I came up blank. Here's the query - again...

A sheet contains data for one month, for one employee, as follows.
ColA: Dates from the first to the last of the month
ColB: Arrival time
ColC: Lunch pause start
ColD: Lunch pause end
ColE: Departure time

A graph of the above data is required, as follows.

Days of the month along the X-axis (bottom);
time (7am-9pm) along the Y-axis (side). For
each day, a colour bar (say, blue) should go from the the value in colB to C; the lunch break (colD - colC) should be in a different colour (say, green); finally, another colour bar (again in, say, blue) from time colD to colE.

I've run out of ideas - do YOU have a briliant way of solving this?

Thanks for your input.

 

[jdavis9]

I have an example of what you might try.
if you will give me an email address I'll forward it to you.

 

[winrz]

I have a Gantt chart that I have been working on - you might be able to use some of the ideas on how the bars extend from two given dates or times.. send me your email and i will forward it on

 

[pamaga]

winrz,
I sent you a Private Message with my email.

jdavis9,
I sent you an email.

Thanks guys.