how to create stacked bar for schedule/utilization

[duckie]

Hi community,

I need help creating the chart that shows how much time of the day a room has been used/been idle. Sort of look like a bar code. How do i create that? I have data of the time the procedure starts and its duration.

[TABLE="width: 202"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]Start time[/TD]
[TD]Exam Duration[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]11:20[/TD]
[TD="align: right"]01:18[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]12:39[/TD]
[TD="align: right"]00:13[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]12:54[/TD]
[TD="align: right"]00:29[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]13:25[/TD]
[TD="align: right"]00:24[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]13:52[/TD]
[TD="align: right"]00:34[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]14:26[/TD]
[TD="align: right"]00:37[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]15:05[/TD]
[TD="align: right"]00:20[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]15:46[/TD]
[TD="align: right"]00:24[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]16:12[/TD]
[TD="align: right"]00:40[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]16:55[/TD]
[TD="align: right"]00:33[/TD]
[/TR]
</tbody>[/TABLE]

When I try to make a stacked bar graph, it comes out in different rows. How do I "collapse" the different rows together so that it's all in one row? (like a bar code)

Thanks so much in advance for your help!

 

[sandy666]

something like this?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]ID[/td][td=bgcolor:#5B9BD5]Start time[/td][td=bgcolor:#5B9BD5]Exam Duration[/td][td][/td][td=bgcolor:#70AD47]ID[/td][td=bgcolor:#70AD47]DurationTot[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

1​

[/td][td=bgcolor:#DDEBF7]

11:20​

[/td][td=bgcolor:#DDEBF7]

01:18​

[/td][td][/td][td=bgcolor:#E2EFDA]

1​

[/td][td=bgcolor:#E2EFDA]

0.05:32:00​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1​

[/td][td]

12:39​

[/td][td]

00:13​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

1​

[/td][td=bgcolor:#DDEBF7]

12:54​

[/td][td=bgcolor:#DDEBF7]

00:29​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1​

[/td][td]

13:25​

[/td][td]

00:24​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

1​

[/td][td=bgcolor:#DDEBF7]

13:52​

[/td][td=bgcolor:#DDEBF7]

00:34​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1​

[/td][td]

14:26​

[/td][td]

00:37​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

1​

[/td][td=bgcolor:#DDEBF7]

15:05​

[/td][td=bgcolor:#DDEBF7]

00:20​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1​

[/td][td]

15:46​

[/td][td]

00:24​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

1​

[/td][td=bgcolor:#DDEBF7]

16:12​

[/td][td=bgcolor:#DDEBF7]

00:40​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]

1​

[/td][td]

16:55​

[/td][td]

00:33​

[/td][td][/td][td][/td][td][/td][/tr]
[/table]

 

[sandy666]

ignore post#2