Sorry to be a PEST! I ask for help after I can't figure out how to do it, and the data looks really messed up. I cant figure out how to do a third line on a chart, or if it should be something different.
I can't figure out how to graph this correctly (using excel)
Ok, this gist of the data is this. (A four column, three row Word table)-- I tried to cut and paste this data for all to see and it didn't work
First Column is Trial
Second Column is Time of Interval
Third Column is Frozen Ice Cubes (corresponds with number)
Fourth column is Unfrozen Ice Cubes (corresponds with number)
(Thats the headings)
Row 1 would be 1st Trial, 15 minutes Frozen 2-5, 10-13, Unfrozen 1, 6,7, 8, 9, 14
Row 2 is 2nd trial, 18 minutes Frozen 1-6, 10-14, Unfrozen 7, 8, 9
Row 3 is 3rd trial, 19 minutes, Frozen all , Unfrozen NONE.
I attempted a line chart, and it got all goofy. I couldn't account for the third trial. Perhaps I set it up in Excel wrong.
Or would it be better to do three separate charts for each trial? If I go that route, since the unfrozen one are not sequential, what would be the best graph to show that?
I can't figure out how to graph this correctly (using excel)
Ok, this gist of the data is this. (A four column, three row Word table)-- I tried to cut and paste this data for all to see and it didn't work
First Column is Trial
Second Column is Time of Interval
Third Column is Frozen Ice Cubes (corresponds with number)
Fourth column is Unfrozen Ice Cubes (corresponds with number)
(Thats the headings)
Row 1 would be 1st Trial, 15 minutes Frozen 2-5, 10-13, Unfrozen 1, 6,7, 8, 9, 14
Row 2 is 2nd trial, 18 minutes Frozen 1-6, 10-14, Unfrozen 7, 8, 9
Row 3 is 3rd trial, 19 minutes, Frozen all , Unfrozen NONE.
I attempted a line chart, and it got all goofy. I couldn't account for the third trial. Perhaps I set it up in Excel wrong.
Or would it be better to do three separate charts for each trial? If I go that route, since the unfrozen one are not sequential, what would be the best graph to show that?
