Hoping someone can help an overwhelmed mom help her child create graphs for Science Fair - yes, it should be taught in school....

I can do basic charts, but I have 2 test subjects that did 3 trials of 3 sports using a video game substitute and then the real sport. The data we have includes the number of steps taken and the before and after pulse rates. I have absolutely NO CLUE how to do a chart to compare the data. My data is below but it did not copy exactly as it is in the data table.

What I came up with so far is 3 separate column charts showing the increase in pulse rates for each sport, but it would be nice if I could get the data into a single graph with all 3 sports on one. I am totally lost, in over my head.

Many thanks if anyone steps up to help.




Subject A
Wii Sports Real Sports
Pulse Before Pulse After Steps Taken Pulse Before Pulse After Steps Taken
Tennis
Trial 1 80 88 10 80 120 1119
Trial 2 80 84 11 88 128 1242
Trial 3 84 88 10 84 124 1181

Bowling
Trial 1 84 88 5 84 88 246
Trial 2 80 84 6 80 88 263
Trial 3 80 80 7 82 88 255

Baseball
Trial 1 80 84 19 96 112 887
Trial 2 80 88 20 80 96 961
Trial 3 84 88 20 88 104 924




Subject B
Wii Sports Real Sports
Pulse Before Pulse After Steps Taken Pulse Before Pulse After Steps Taken
Tennis
Trial 1 64 96 14 68 72 1028
Trial 2 68 96 46 68 88 2316
Trial 3 72 100 50 64 88 1678

Bowling
Trial 1 76 120 26 60 64 199
Trial 2 68 100 37 62 84 350
Trial 3 72 128 29 66 88 225

Baseball
Trial 1 76 96 22 64 104 825
Trial 2 72 112 26 64 108 1058
Trial 3 72 124 17 68 112 987