Lesson 3: Graphing Long Term Soil Temperature Change
  • Exit Lesson

Contents

1 Overview
2 View and Select Data
3 Change Descriptions
4 Scatter Plot Graph
5 Label Axes
6 Display Graph
7 Change Scale
8 Showing Data
9 Adding Years
10 Change Scale
Resources

3 Change descriptions; select non-continuous data

 

Step 1

Place the cursor in cell A1. From the Excel toolbar highlight “Depth (m)” and press Delete. Do the same for cells G1, I1 and K1.

Deadhorse Permafrost Temps spreadsheet image

 

 

Depth

Step 2

Select cells A1 through F1.  Press the command key (Open Apple on a Mac, Control key on a PC) and select cells A22 through F56.  Since only the data below 20 meters is being graphed the command (control key for PC) key can be used to select non-continuous cells.