stacked bar chart showing start/end time

[wlevinson14]

Does anybody know how to do the following:

Each input record represents an operation scheduled for tomorrow - each record contains following fields.

Operating Room Number,
Operation Case Number,
Scheduled Start time of Operation,
Scheduled End time of operation.

Sample data would look like this:

OR Room , Case, Start Time, End Time

1, A, 7:30 AM, 10:30 AM
1, D, 11:00 AM,1:00 PM
1, G, 1:30 PM, 5:00PM
2, Z, 8:00 AM, 10:00AM
2, X, 11:00 AM, 2:30 PM

Chart should show time of day on y axis, and operating room on x axis.
Each operating room on x axis should have a stacked bar representing the start/end time of each operation.
example or first column follows (ignore the dots)

07:00....... _
07:30.......|.|
08:00.......|.|
08:30.......|.|
09:00.......|.|
09:30.......|A|
010:00.....|_|
10:30......._
11:00......|.|
11:30......|.|
12:00......|D|
12:30......|_|
01:00...... _
01:30......|.|
02:00......|.|
02:30......|.|
03:00......|.|
03:30......|.|
04:00......|G|
04:30......|_|
05:00
..............OR1........OR2

 

[SkipVought]

hi,

You need to plot START and the DURATION, (END - START)

The Value axis will need a MIN value of something in the neighborhood of the MINIMUM START.

The FIRST bar series (START) will be EMPTY

The SECOND bar series (DURATION) will be FILLED, representing the START to END time for that OR/Case.

The HORIZONTAL Value Axis will be your TIMES

The VERTICAL Category Axis will be your OR/Case values.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[wlevinson14]

Thanks for the quick response -
I still can't get it to work - need clarification.

I set the chart type to "stacked bar chart"
For the data tab would you select "on change of" or "for each record"?
When I select "on change of" and the room# it forces you to use a summary for the start time and duratioin in the "show value" box.

Also, where do I set the MIN value and how do I get the y axis to display a date instead of a number?

 

[SkipVought]

Your posted data will only plot like a waterfall, using "for each record"
[tt]
1 A |||||
1 D |||
1 G ||||||||||||
[/tt]
If you want ONE set of bars, rather than 3, in this case, your chart source data will need to drastically change and will be difficult to plot multiple ORs on the same chart...
[tt]
source data
OR Start A End A Dur A Start D End D Dur D Start G End G Dur G
[/tt]
plot
[tt]
1 ||||| ||| ||||||||||||
[/tt]




Skip,

_{Just traded in my old subtlety...
for a NUANCE!}