How can I plot all this data?

Copper Contributor

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!


Screenshot 2022-02-27 at 16.27.06.png

3 Replies
best response confirmed by Hans Vogelaar (MVP)

@robin_1965 Perhaps like this?

Screenshot 2022-02-27 at 17.39.11.png

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!
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!