How can I plot all this data?

[robin_1965]

This was a science experiment to measure water temperature using different insulators with a class of 10 year olds. Here is the data table. I can't seem to plot this with time on x axis and temperature on y axis with each material shown as a line - I'm presuming it would need to be a scatter graph on Excel? Any help appreciated!

[#2 · Accepted solution]

@robin_1965 Perhaps like this?

[#3]

Yes - exactly! How did you do that - I can see you have formatted the time differently. Did you use the format cells option to do this? If you did it as a scatter graph, how did you get it to draw the connecting lines. How you have it is perfect!

[#4]

Oh, I've just noticed that you've attached a file for me to download - fantastic - many thanks. I can see the custom format in the time cells. This has been such a help - thanks so much!