SOLVED

How can I plot all this data?

%3CLINGO-SUB%20id%3D%22lingo-sub-3218438%22%20slang%3D%22en-US%22%3EHow%20can%20I%20plot%20all%20this%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3218438%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20was%20a%20science%20experiment%20to%20measure%20water%20temperature%20using%20different%20insulators%20with%20a%20class%20of%2010%20year%20olds.%20Here%20is%20the%20data%20table.%20I%20can't%20seem%20to%20plot%20this%20with%20time%20on%20x%20axis%20and%20temperature%20on%20y%20axis%20with%20each%20material%20shown%20as%20a%20line%20-%20I'm%20presuming%20it%20would%20need%20to%20be%20a%20scatter%20graph%20on%20Excel%3F%20Any%20help%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-02-27%20at%2016.27.06.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351532i4E6EBF756D17343D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-02-27%20at%2016.27.06.png%22%20alt%3D%22Screenshot%202022-02-27%20at%2016.27.06.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3218438%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3218472%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20plot%20all%20this%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3218472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1319090%22%20target%3D%22_blank%22%3E%40robin_1965%3C%2FA%3E%26nbsp%3BPerhaps%20like%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202022-02-27%20at%2017.39.11.png%22%20style%3D%22width%3A%20495px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F351539iB2407DB544BF185B%2Fimage-dimensions%2F495x240%3Fv%3Dv2%22%20width%3D%22495%22%20height%3D%22240%22%20role%3D%22button%22%20title%3D%22Screenshot%202022-02-27%20at%2017.39.11.png%22%20alt%3D%22Screenshot%202022-02-27%20at%2017.39.11.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3218540%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20plot%20all%20this%20data%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3218540%22%20slang%3D%22en-US%22%3EYes%20-%20exactly!%20How%20did%20you%20do%20that%20-%20I%20can%20see%20you%20have%20formatted%20the%20time%20differently.%20Did%20you%20use%20the%20format%20cells%20option%20to%20do%20this%3F%20If%20you%20did%20it%20as%20a%20scatter%20graph%2C%20how%20did%20you%20get%20it%20to%20draw%20the%20connecting%20lines.%20How%20you%20have%20it%20is%20perfect!%3C%2FLINGO-BODY%3E
New 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)
Solution

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