Last post Nov 03, 2017 04:23 PM by march11
Nov 09, 2012 10:57 AM|JudasJones|LINK
Originally posted in getting started. Just realised that was the wrong place.
The issue I am having is as follows.
I am trying to generate a chart that would demonstrate utilisation of a given time period. Essentially this would be a stacked bar chart with 4 times (each a series). I read the data from a database in the following table structure:
ID Time1 Time2 Time3 Time4
1 08:34 08:48 08:52 09:32
2 09:32 09:52 09:59 10:55
I can bring the data through and plot the points ok. The problem is that the graph starts at 00:00 and plots 8:34 as 8 hours and 34 mintutes. What I would need is that series0 would start 08:34 and finish 08:48, then series 2 would start 08:48 and finish
08:52 and so on.
The outcome would look similiar to a gannt chart.
If I plot the duration i.e. time1 would be time2-time1=minutes, how would I start this at 8:34?
Any advice would be greatly received
Nov 03, 2017 04:23 PM|march11|LINK
Not the exact answer you are looking for but I found this very helpful in the past...