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