Use of Microsoft Excel for simple calculations and creating charts - climatic graphs

Open the link below for the excel sheet: https://spreadsheets.google.com/spreadsheet/ccc?key=0AtUR3aEsvgerdENtUmE5S0N5ZGNueGozb1lqcUVTY0E&hl=en_US

Data on Singapore's temperature from:
http://www.worldclimate.com/cgi-bin/data.pl?ref=N01E103+1102+48694W

Data on Singapore's rainfall from:
http://www.worldclimate.com/cgi-bin/data.pl?ref=N01E103+2100+48694W

Calculating Temperature range:

Calculating average temperature:

Calculate total rainfall

Creating a temperature graph with Chart Wizard:

Creating a rainfall graph with Chart Wizard

You can also create a climatic graph by inserting combo chart using Microsoft excel.









It is also simple and useful especially when you have two sets of data for the Y axis. As shown below - air temperature and relative humidity.