INTRODUCTION. CLIMATES OF THE WORLD. How to make a climate graph with excel

Follow this steps:

1) put these headings:  Rainfall, Temp,  in , B3, C3:
2) put the months in A4-A15, average rainfall in B4-B15, and average temps in C4-C15
3) select the data from A3 to C15
4) Select 2 Line Graph (gráfico de líneas)
5) Click on the rainfall line, then press the right mouse button, change type of graph: choose columns
6)Once you are on the red line, press the right mouse button, choose data format ("formato serie datos"). Go to axis ("eje"), choose secondary  axis
7) The primary axis has to double the value of the secondary axis. So click on the rainfall axis (right button), select  scale and then data: write maximum value (400), minimum value (0), the biggest figure- unidad mayor (20). Do the same with the temperature axis, but with different values: maximum value (200), minimun value (0), the biggest figure (10)
8) To put the title, click on a blank top area (right button), select legend format ("formato de leyenda") and legend options, click on superior. Finally write the title.

DATA: SRI LANKA


Year average: 27º C and 2341 mm

You should have something like this:

INTRODUCTION. CLIMATES OF THE WORLD

STARTER ACTIVITY

1- Look at these pictures and try to describe how is the climate there.



1)



2)





3)








4)






2-Why are the climates so different in the world?

3-Which are the results ?

4- Try to classify the climates of the world in three groups.


After watching this power point presentation, fill the table bellow

World climates

View more presentations from mariasorey.