Help with Science Fair Graphs/Charts

[MomNeedingHelp]

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

[Steve=True]

Hello Momneedinghelp.

Welcome to the forums.

I have rearranged your data and plotted it in one column chart. Take a look and let me know what you think.

It creates groups for the Horizontal Axis.

ScienceFairGraph.xlsx

Let me know if you have any questions.

Thanks.

Steve=True

[MomNeedingHelp]

OMG!!! I am in awe! You did it FOR me??? Silly me, I am so emotional over it. I have sat in front of the pc, searching and searching and searching. I actually found your website today, from here, and was going to try and copy some of the things on your website.

I just can't express enough appreciation. I have been an at home mom for 15 years, now going back to middle school for the 3rd time with my kids, 4th time for me in total.

Thank you, thank you, thank you.

Now, how do I learn to do stuff like that so I can teach my kids?

You are the best!!!!

Did I say Thank you? Thank you!!!!

[Steve=True]

Well mom,

You are very welcome.

Do you and me get a ribbon too for your help?

Glad to help.

Thanks for the great comments.

Please let me know the results of the science fair

Steve=True