Excel graph with date, time and date in separate columns

The_blue

The_blue

The_blue

Soldato
Joined
25 Oct 2002
Posts
4,198
Location
Derbyshire
I've got a tonne of data like this:-

Code: 
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?
 
Seems to be working okay on this end doing an x-y scatter. The problem with doing a line graph is it won't chart one property against another like you want to do in this case, assuming "I want to make a line graph woth date+ time on one side and the smaller numbers on the other" means that you want one axis for the numbers and another axis (the 'y' axis conventionally) for the time.
 
Is this what your after...

In your 'Source Data', set the 'Values' (biege area) to your little numbers and the 'Category (X) axis lables' (green area) to your date and time.

I'm now looking at a line graph with your little number on the y axis and date & time (sorted correctly) on the x.
 
You must log in or register to reply here.
Back
Top Bottom