i have a series or irregular interval i want to make their histogram but i tried to find a solution
start time end time value
23-Sep-12 09:26 23-Sep-12 19:29 150
28-Sep-12 21:42 29-Sep-12 01:54 150
01-Oct-12 14:40 01-Oct-12 16:08 150
09-Oct-12 05:43 09-Oct-12 14:16 150
19-Oct-12 00:10 21-Oct-12 20:17 150
07-Dec-12 18:48 07-Dec-12 23:25 150

so i think its good to have xy scatter chart but i have a big problem with the x-label
i can't have dd-mm-yy hh:ss format
when a determine a small minor unit
i cannot read the data

i try to display only my data
but also
i can't found a solution

my prob with irregular histogram.xlsx
so i try transfer this data to be like
time value for each serie
9/23/12 9:26 150
9/23/12 19:29 150
28-Sep-12 21:42 150
29-Sep-12 01:54 150
10/1/12 14:40 150
10/1/12 16:08 150
10/9/12 5:43 150
10/9/12 14:16 150
10/19/12 0:10 150
10/21/12 20:17 150


please, can anyone help me its very urgent
any idea to solve my problem
i need to have a chart represent the value during this period