Using Excel to Graph & Analyze Data: Part I


1.        Start the Microsoft Excel program.

2.        Open up a new worksheet. 

3.        Enter "Diameter" into cell A1 and "Circumference" into cell B1.


In this graph, the diameter is the independent variable and is graphed on the horizontal (x) axis.  The circumference is the dependent variable and is graphed on the vertical (y) axis.


4.        Enter your data for diameter into column A. (Don't include units)

5.        Enter your data for circumference into column B. (Don't include units)

6.        Click on the Chart Wizard Button on the top toolbar.

   A.  Chart Type

      Under the Standard Types tab, choose XY(Scatter).

      Choose the top subtype (the one with no lines)

      Click on Next

   B.  Data Range

      Click on the chart icon at the right end of the highlighted row.

      Click and drag on the cells (in the spreadsheet) that contain your data and column headings.

      Click on the Chart Icon in the small Chart Wizard Step 2 of 4 box.

      Click on Next.

   C.  Chart Options

      Label your x-axis and y-axis appropriately.  Don't forget to include units!

      Title your graph appropriately.

   D.  Chart Location

      Chooseas object in your data sheet.

      Click on Finish.

   E.  Graphing the Best-Fit Straight Line

      Select the graph by clicking on it (you'll see small black squares on its borders).

      SelectChart from the top menu bar.

      ChooseAdd Trendline . . .

i.                     Choose Type

ii.                    Select the Linear option

iii.                 Choose Options

iv.                  Click on the boxes to display the equation and the R2 value.

F.             Print out your graph and data on one page; don't forget to put your name on it before you turn it in.