MS Excel help plotting line graphs

[MicKPM]

Hi all,

I've been up since 1am playing with Jonny's 182 fixing its cooling problem and I think I've managed it but after data logging it I'd like to see the raw data expressed as two lines on a single graph. Now I had assumed this *would* be simple enough task to perform in Excel but apparently it is beyond me so HEEEEELP!!!!!

Data:

Time (Seconds)
Engine Speed (RPM)
Coolant Temp (Deg C)

I'd like to see engine speed/coolant temp plotted against time

Is anyone able to do this for me? File link to raw data in XLS below:

https://www.dropbox.com/s/mf1kateo353bvcx/Data log - MJ55LNF.xls

Mick

 

[ThomasBrentnall]

I've tried. But no avail. Doesn't seem to like the values, I can do it with less/more simple data.

Edit: Is this the sort of thing you're after? (Obviously with your own data)

 

[MicKPM]

That's what I'm after yes but I also found Excel just not wanting to display it right.

Just give me X/Y control MS. I could do it myself on paper but I dont have a day. Plus it's only 3000 sets of data

 

[MicKPM]

Done so huge thanks to Trickstargee who pointed out I was being stupid by not converting the cell data to actual numbers.

Mick

 

[ThomasBrentnall]

Done so huge thanks to Trickstargee who pointed out I was being stupid by not converting the cell data to actual numbers.

Mick

I tried doing that, but it still wasn't happy for me. Well done though!