Plot Date and Time on the X-axis

[jjhopkotcha]

Hi there,

I have a load of data that I have pulled off an online data source and it has put the time at data in one cell in the format "22.05.2012 17:18:47". The date and time is to be plotted on the x-axis against tunneling distance achieved on the y-axis. Currently when I attempt to plot the two columns on a scatter chart it simply plots the x-axis as a linear scale (starting at 1, moving up 1 for each data point). I have tried separating out the date and time using the text-to-columns feature which does separate out the date and the time, but this doesn't seem to help me either as I want to be able to plot tunneling distance against date and time, rather than just one of them.

Any help on this matter would be hugely appreciated.

Many Thanks,

John

 

[oldbrewer]

[TABLE="width: 256"]
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]time[/TD]
[TD]distance[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]4.5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]7.3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10.9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]14.1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]when i plot this as a scatter chart it plots ok yes the x axis is labelled 0-5-10-15-20-25 but the points are plotted in the correct positions[/TD]
[/TR]
</tbody>[/TABLE]