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

10 Change the X axis scale

 

Format the axis in Excel imageStep 1

Since there are no temperatures above -6, the Y axis should be formatted so the maximum is -6.

Double click on the Y axis. On the Format Axis dialog box change the Maximum to -6.

The completed graph should look like the one below.

Resulting graph

Stop and think

Question 1. Look at the completed graph. Can a trend be seen with the temperatures from 1984 to 2009? 

Roll-over for Answer:
From 1997 to 2009 the temperatures below 20 meters have increased.

Question 2. What would you expect to see in the line for temperatures in 2010? 

Roll-over for Answer:
Since the temperatures have been steadily increasing for over a decade, an increase in temperature in 2010 would be expected.

Question 3. What can you infer about the temperatures near the surface over this period of time? 

Roll-over for Answer:
Since the temperatures at a lower depth have been rising, it would be reasonable to infer that surface temperatures in this region have also increased.

Go to last activity