That Blue Square Thing

Hydrographs

Pigs in the snow Having sorted out creating climate graphs in Excel, drawing flood hydrographs seemed the logical next step. The theory's the same: two data sets on two axes on the same graph so this wasn't a long job.

The bigger problem seems to be finding data to draw a reasonably accurate and reliable hydrograph from. If anyone can help out with better data please let me know.

Hydrographs in Excel 2007/2010/2011

The instructions will talk you through producing a hydrograph 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 iconHydrograph Drawing Instructions

MS Excel iconBoscastle data sheet

The datasheet is one that seems to have been passed around a number of places. I can't work out where the original data came from - my gut feeling is that it's been simplified a touch. If it's your work please get in touch and I'll add whatever credits you want.

As usual feedback is useful.

If you have problems downloading the spreadsheet please let me know. There have been difficulties experienced downloading similar sheets from this site and I'm keen to try and find a solution.

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

Hydrograph for Boscastle

More on Boscastle

The 2004 Boscastle flash flood event is a pretty reasonable GCSE or A Level flash flood case study. There are loads of places on the web where information can be found, from the obvious Wikipedia articleExternal link icon (rather in need of references) to contemporary BBC news articlesExternal link icon.

The Met Office Case Study pageExternal link icon is well worth a look, especially for a GCSE case study.