Excel Help on Scatter Graph

[timmins]

Hi,

Putting together a record of my jogs in an attempt it'll keep me wanting to go out and get some fresh air.

Initially had a simple line plot of my average speed so see how I progress, but now I figure longer routes I'll have to go slower, so I want a different line for each route. I've basically shown this in the file so far (found here) but I want a graph which updates as I enter in my times.

I figure it should kinda of be straight forward, I just can't put my finger on it.

Any help much appreciated,

Tom

 

[timmins]

Sorry to bump but been trying all this afternoon, not got much further. I'm hardly an excel expert too, but I guess I need to change to a proper dynamic chart using the offset function? But at the moment I still think that wouldn't work because of my layout.

I basically just want to enter date, time, and route, and it all to update. Wishing too much for a novice?