That Blue Square Thing

Climate & Climate Graphs

Now updated for Excel 2016

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

The instructions show you how to draw a climate graph in Excel. There are two sets of instructions, depending on which version of Excel you have. Use the spreadsheet provided as a starter so that you know how to do it!

pdf iconClimate Graph Drawing Instructions - Excel 2016

pdf iconClimate Graph Drawing Instructions - Excel 2007, 2010 and 2011 (Mac version)

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