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

6 Create a line graph with multiple variables by date

 

Step 1

Chart Wizard iconClick on the Chart Wizard from the toolbar.

 

 

Chart Wizard step 1 of 4Step 2

Select the Line chart and the Line chart sub type.  Click Next.

 


 

Chart Wizard step 2 of 4Step 3

Click Next on Step 2 of 4.

 



""Step 4

Under the Title tab enter the following:

Chart Title: Near Surface Temperature at 300m
Categories (X) axis: Date
Value (Y) axis: Temperature ( C )


 

StopDon’t click Next. If you do, click on Back.

Chart Wizard step 3 of 4Step 5

Click on the Gridlines tab.
Under the Category (X) axis click on the Major gridlines.

Click Next.



Chart Wizard stp 4 of 4Step 6

Click Finish on the Step 4 of 4.

 

The graph should look similar to the one below.

Near Surface Temperature example chart