Excel graph with date, time and date in separate columns

[The_blue]

I've got a tonne of data like this:-

24-May-10	20:32:11	2.2
24-May-10	21:02:11	3
24-May-10	21:32:11	2.8
24-May-10	22:02:11	2.8
24-May-10	22:32:11	3.1
24-May-10	23:02:11	2.5
24-May-10	23:32:11	2.3
25-May-10	00:02:11	1.3
25-May-10	00:32:11	1.1
25-May-10	01:02:11	2.1
25-May-10	01:32:11	1.2

I want to make a line graph woth date+ time on one side and the smaller numbers on the other.

I can combine the date and time easily (=A1+B1) but it dosn't make the graph work

Any ideas?

 

[The_blue]

Thanks! I'll give it a go when i'm back at work



Welcome by the way! I see this is your 1st post!