Hi,

I would like to create a chart that has:


X-Axis: Time (Midnight to 23:59)
Y-Axis: Days of the month e.g. 1 Apr 2006, 2 Apr 2006 ... 30 Apr 2006.


The plotted data should represent the duration of telephone calls as
horizontal bars or
lines whose left hand edge represents the time a call was initiated and

the bar ends when the call was terminated.


Note that more than one call can be made in the same day.


To complicate matters there should be two series: one for official
calls, one for private calls.


Can anyone advise me on the chart type I should use and the SQL source?



The source data have fields such as:


Date: 3 Apr 2006
Call_Start_Time: 13:36
Call_Duration: 356 (s)
Call_Purpose: Official | Private


Many thanks in advance,


Andy