Making Graphs Using Microsoft Excel

Example: Making a graph comparing the bouncing of different types of balls.

Set up your data table in the cells provided by Microsoft Excel.
list the trial numbers in the first column (along the left side)
list your treatments as column headings (along the top)
enter your data in the appropriate cells (See Data Table Below)

Average your data for each treatment.
click on the cell at the end of the first column of data (not the trial numbers)
type in =AVERAGE(
click on the first cell in the column and continue to hold the left mouse button, drag the mouse to the end of the column and let go of the mouse button (all of the data in the column should be highlighted)
now type )
press the ENTER key
repeat steps a. through e. for the rest of the columns

Now highlight all of the averages that you just created by left clicking on the first cell with an average and dragging to the last cell with an average and let go of the left mouse button.

Click on INSERT at the top and then on CHART in the drop-down menu

Click on COLUMN in the new window that opens.

Then click on SERIES at the top of that window.

Click on the button in the NAME field then type the one thing that you are comparing (in the example it is “Average Height of Bounce”) and press ENTER.

Click on the button in the X-AXIS LABLES field. Then highlight the headings at the top of your columns with data and press ENTER.

Click on NEXT at the bottom of the window.

Click on TITLES at the top of the window.

Click on CHART TITLE and type in a name for your chart.

Click on CATEGORY X-AXIS and give the axis a label that matches your treatments. (Tennis Ball Brands)

Click on CATEGORY Y-AXIS and give the axis a label that matches your measurements. (Height of Bounce in cm)

Click on NEXT.

Click in the circle before AS NEW SHEET and then click finish.

Trials


Basketball (bounce cm)
Soccer Ball (bounce cm)
Football (bounce cm)
Golf Ball (bounce cm)
1 20 15 5 25
2 23 16 6 26
3 24 15 10 23
4 25 14 12 24
5 24 12 4 28
6 23 13 2 29
7 26 14 12 23
8 25 15 5 30
9 24 16 13 21
10 25 12 6 26
11 24 13 16 25
12 23 14 12 24
13 21 18 4 26
14 22 17 5 28
15 23 12 6 23
16 23 13 7 29
17 25 15 9 27
18 24 16 8 21
19 26 18 12 23
20 23 14 8 25

Follow the directions from the MAKING GRAPHS USING MICROSOFT EXCEL worksheet to make a graph of the data in the table above.

 


Go Back