University of Vermont

Kelley (1989)


Excel Graphing Tutorial

    Often the best way to examine data is to graph it.  Graphs are visual diagrams that exhibit a relationship between two sets of numbers or variables.  Geologist Patricia Kelley plotted measurements of internal volume and shell thickness for several genera of bivalves versus the age of the rock layers that contained them. When these graphs were examined, patterns of change in morphology as a function of time appeared.   The following tutorial will help you take the data from Kelley's study, and create several scatter plots (with a best fit line) that allows you to examine changes in internal volume and shell thickness versus age. 

You will need:                                                                                | Home |

  • A computer with the Excel program installed on it.
  • The data sheet from Kelley (1989) (Download Here)
  • Supplemental data, if working from a printout

Steps to graph data using Excel:

Step 1:  Creating a Worksheet

Step 2:  Selecting Data to Graph

Step 3:  Selecting the "Chart" Wizard

Step 4:  Graphing Data

Step 5:  Adding a Trendline

Conclusion:  Analyzing and Interpreting the Graph

Last modified October 06 2008 02:19 PM

Contact UVM © 2018 The University of Vermont - Burlington, VT 05405 - (802) 656-3131