excel charts plot time on x & y

[hzhm]

Hi I need to plot the following data to display start and end of each item - start on x - end on y
Start Finish
0:01:02 0:01:18
0:12:01 0:13:00
0:22:28 0:23:02
0:33:01 0:34:02
0:44:04 0:44:25
0:54:28 0:55:26
1:07:23 1:08:08
1:18:22 1:19:20
1:29:01 1:29:25
How can I achieve this. See file attached.
thanks

 

[Hui]

Do you mean like the attached?

 

[hzhm]

Do you mean like the attached?
View attachment 8658

Yes great. I think the answer to the next question is impossible due to the minute durations, but is it possible to change the x & Y values to show the start stop clearer? eg the gap between the major axis is too big.
thanks

 

[Hui]

The starting gaps are too small compared to the range of the data

You could read:
http://chandoo.org/wp/2010/08/20/charts-with-small-and-large-values/
or
https://sites.google.com/site/e90e50fx/home/broken-line-panel-charts