thanksforthehelp
New Member
- Joined
- May 19, 2017
- Messages
- 1
I am trying to show the multiple jobs happening on given dates with their start and stop times represented by a bar. I wish to have time (00:00-23:00) on the vertical axis with dates along the horizontal axis. Each date would have multiple "jobs" occurring that day with potential for overlap. It would be nice to visually show that overlap of jobs. An example of the data I have is listed here. Any help would be appreciated. In my attempts to do a cluster bar graph it is mapping the start and stop times as two separate data sets and drawing bars from 00:00 to each one.
[TABLE="width: 218"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]03/JAN/2017[/TD]
[TD="align: right"]7:48[/TD]
[TD="align: right"]12:38[/TD]
[/TR]
[TR]
[TD]03/JAN/2017[/TD]
[TD="align: right"]14:18[/TD]
[TD="align: right"]19:04[/TD]
[/TR]
[TR]
[TD]03/JAN/2017[/TD]
[TD="align: right"]7:31[/TD]
[TD="align: right"]14:05[/TD]
[/TR]
[TR]
[TD]03/JAN/2017[/TD]
[TD="align: right"]15:18[/TD]
[TD="align: right"]19:06[/TD]
[/TR]
[TR]
[TD]04/JAN/2017[/TD]
[TD="align: right"]7:58[/TD]
[TD="align: right"]18:33[/TD]
[/TR]
[TR]
[TD]04/JAN/2017[/TD]
[TD="align: right"]15:57[/TD]
[TD="align: right"]19:15[/TD]
[/TR]
[TR]
[TD]05/JAN/2017[/TD]
[TD="align: right"]7:10[/TD]
[TD="align: right"]16:59[/TD]
[/TR]
[TR]
[TD]05/JAN/2017[/TD]
[TD="align: right"]14:39[/TD]
[TD="align: right"]20:56[/TD]
[/TR]
[TR]
[TD]05/JAN/2017[/TD]
[TD="align: right"]7:10[/TD]
[TD="align: right"]13:41[/TD]
[/TR]
[TR]
[TD]06/JAN/2017[/TD]
[TD="align: right"]7:10[/TD]
[TD="align: right"]16:37[/TD]
[/TR]
[TR]
[TD]06/JAN/2017[/TD]
[TD="align: right"]12:25[/TD]
[TD="align: right"]16:38[/TD]
[/TR]
[TR]
[TD]06/JAN/2017[/TD]
[TD="align: right"]7:22[/TD]
[TD="align: right"]10:54[/TD]
[/TR]
[TR]
[TD]06/JAN/2017[/TD]
[TD="align: right"]7:35[/TD]
[TD="align: right"]13:33[/TD]
[/TR]
[TR]
[TD]10/JAN/2017[/TD]
[TD="align: right"]7:17[/TD]
[TD="align: right"]9:37[/TD]
[/TR]
[TR]
[TD]10/JAN/2017[/TD]
[TD="align: right"]6:43[/TD]
[TD="align: right"]21:16[/TD]
[/TR]
[TR]
[TD]10/JAN/2017[/TD]
[TD="align: right"]10:44[/TD]
[TD="align: right"]11:54[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 218"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]03/JAN/2017[/TD]
[TD="align: right"]7:48[/TD]
[TD="align: right"]12:38[/TD]
[/TR]
[TR]
[TD]03/JAN/2017[/TD]
[TD="align: right"]14:18[/TD]
[TD="align: right"]19:04[/TD]
[/TR]
[TR]
[TD]03/JAN/2017[/TD]
[TD="align: right"]7:31[/TD]
[TD="align: right"]14:05[/TD]
[/TR]
[TR]
[TD]03/JAN/2017[/TD]
[TD="align: right"]15:18[/TD]
[TD="align: right"]19:06[/TD]
[/TR]
[TR]
[TD]04/JAN/2017[/TD]
[TD="align: right"]7:58[/TD]
[TD="align: right"]18:33[/TD]
[/TR]
[TR]
[TD]04/JAN/2017[/TD]
[TD="align: right"]15:57[/TD]
[TD="align: right"]19:15[/TD]
[/TR]
[TR]
[TD]05/JAN/2017[/TD]
[TD="align: right"]7:10[/TD]
[TD="align: right"]16:59[/TD]
[/TR]
[TR]
[TD]05/JAN/2017[/TD]
[TD="align: right"]14:39[/TD]
[TD="align: right"]20:56[/TD]
[/TR]
[TR]
[TD]05/JAN/2017[/TD]
[TD="align: right"]7:10[/TD]
[TD="align: right"]13:41[/TD]
[/TR]
[TR]
[TD]06/JAN/2017[/TD]
[TD="align: right"]7:10[/TD]
[TD="align: right"]16:37[/TD]
[/TR]
[TR]
[TD]06/JAN/2017[/TD]
[TD="align: right"]12:25[/TD]
[TD="align: right"]16:38[/TD]
[/TR]
[TR]
[TD]06/JAN/2017[/TD]
[TD="align: right"]7:22[/TD]
[TD="align: right"]10:54[/TD]
[/TR]
[TR]
[TD]06/JAN/2017[/TD]
[TD="align: right"]7:35[/TD]
[TD="align: right"]13:33[/TD]
[/TR]
[TR]
[TD]10/JAN/2017[/TD]
[TD="align: right"]7:17[/TD]
[TD="align: right"]9:37[/TD]
[/TR]
[TR]
[TD]10/JAN/2017[/TD]
[TD="align: right"]6:43[/TD]
[TD="align: right"]21:16[/TD]
[/TR]
[TR]
[TD]10/JAN/2017[/TD]
[TD="align: right"]10:44[/TD]
[TD="align: right"]11:54[/TD]
[/TR]
</tbody>[/TABLE]