Forum Discussion
Solved
How can I plot all this data?
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!
robin_1965 Perhaps like this?
3 Replies
robin_1965 Perhaps like this?
- 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!
- 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!
