Instructions for Making a Climate Graph Using Microsoft Office Excel
These instructions are intended to enable school students to create a climate graph, climatograph, or temperature and rainfall chart, using Microsoft Office 2007 Excel. I will not claim it is the slickest method but it is simple and it does work. There are other versions of these instructions out there so you can pick and chose as to which one suits you. Click on this link to find the instructions for creating a population pyramid in Microsoft Office Excel. Please feel free to post comments; I will use them to make improvements.
Click on "read more" to find out how to produce this Excel climate graph!
1. Put your climate data into an Excel chart like this one.
2. Highlight the data, including the headers like this:
3. Select “Insert”, (then “Charts”), then “Column” and then the first graph showing under “2-D Column”.
4. You now have a bar or column chart showing temperature and rainfall but there are several things missing or wrong; these need to be corrected.
5. Select “Layout”, “Labels” then “Chart Title”.
6. I would suggest you choose to put the title above the chart; choose “Above Chart”. The graph will now display a heading of “Chart Title”, which can be amended to include your chosen title. To ensure there is a good fit the text size can be altered.
7. Now right click on one of the blue bars and select “Change Series Chart Type” then select the first graph under “Line” and click “OK”.
8. Your chart now has the temperature as a line, although usually this is displayed in red. Right click on the line and select “Format Data Series”, then then “Line Colour”, then “Solid Line” and choose an appropriate colour before clicking “Close”.
9. Now right click on one of the rainfall bars, select “Format Data Series”, then select “Fill”, then”Solid Fill”, then “Colour” and choose an appropriate colour before clicking “Close”.
10. Now we need to create the axis for the temperature because the left hand axis only shows the rainfall scale. Right click on the temperature line, select “Format Data Series”, then select “Secondary Axis” and then “Close”.