I am trying to create a visual vehicle usage chart to better identify wasted time.
To do this, I wish to plot all the vehicles on a chart, vertical axis is the vehicle ID and horizontal axis is time over a 24 hour period staring at 03:00 and finishing at 02:59 the following day.
Against each vehicle ID I want to show the time the vehicle is in use and the time it is not. I figure using bars for the usage and space in between to show the down time.
I also want to label the bars with THREE labels if possible. A start location symbol just inside the left end of the bar, a route ID centred on the bar and an end location symbol just inside the right end of the bar.
However, the labelling is a lesser priority.
Here is an example of my data sets and the final result I am trying to achieve:
Veh. Route Start Start End End
Loc. Time Time Loc.
001 A X 10:00 10:30 Y
001 A Y 10:45 11:15 X
002 A Y 10:15 10:45 X
002 A X 11:00 11:30 Y
003 B X 10:00 10:45 Z
003 B Z 11:00 11:45 X
|
001-+ [X--A--Y] [Y--A--X]
|
002-+ [Y--A--X] [X--A--Y]
|
003-+ [X----B----Z] [Z----B----X]
|
+---+---+---+---+---+---+---+---+---+---
10:00 10:30 11:00 11:30 12:00