Lesson 4: Graphing Albedo and Temperature Data
  • Exit Lesson

Contents

1 Overview
2 Open Excel
3 Scatter Plot Graph
4 Manipulate Markers
5 Select Variables
6 Line Graph
7 Move Axis
8 Select Columns
9 Move Axis
Resources

3 Create and label a scatter plot graph

 

Step 1

Chart WizardClick on the Chart Wizard from the toolbar.

 

Step 2

Chart Wizard Step 1 of 4Select XY (scatter) as the Chart type and Scatter as the sub type.  Click Next.

 

 

 

 


Chart Wizard Step 2 of 4Step 3

Click Next on Chart Wizard STEP 2 of 4.

 

 

 



Chart Wizard Step 3 of 4Step 4

On Chart Wizard Step 3 of 4, give your chart a title and label the X and Y axis. Please see the following for suggestions:

Chart Title:  Albedo Before and After a Forest Fire
Value (X) axis: Date
Value (Y) axis:  Albedo (%)

Click Next Chart Wizard Step 3 of 4.

 


 

Chart Wizard Step 4 of 4Step 5

Click Finish on Chart Wizard Step 4 of 4 Chart Location

 

 


Step 6

The completed chart should look like the one below.


Completed sample graph