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]

	time	distance
	3	1
	7	4.5
	15	7.3
	20	10.9
	29	14.1
			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

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>