That Blue Square Thing

Climate & Climate Graphs

Pigs in the snow Following on from my weather forecasting pages, I managed to get Noel JenkinsExternal link icon to vaguely inspire me again, although in this case it seems to have been a blog post from 2007 that did the trick. Nothing like delayed inspiration then...

I'm starting with some Climate Graph drawing skills, but this might go off in a few other directions at some point.

Climate Graphs in Excel 2007/2010/2011

The instructions show you how to draw a climate graph in Excel 2007 - with some pointers for Excel 2011 for Macs (and probably for 2010 for Windows?). Use the spreadsheet provided as a starter so that you know how to do it!

pdf iconClimate Graph Drawing Instructions

MS Excel iconBarcelona climate data

If you want a smooth line rather than a jagged line for your temperature data, then see the note at the bottom of page 3 of the PDF

These should work fine, although, as ever, feedback is useful.

I've also worked up a tweaked set of instructions to apply this basic method to flood hydrographs.

Here's an example of the sort of thing you can produce.

Climate graph for Barcelona