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.
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.