That Blue Square Thing

Kite Diagrams in Excel

Dunwich boardwalkKite diagrams can be used to present data. A common usage is to deal with vegetation cover - perhaps on a beach profile.

They can be done using Excel - but it's as tricky as heck! I was asked to try to develop something by someone doing some Advanced Higher Geography work up near Aberdeen in 2013. After several goes at it I actually ended up with something useful.

I'm going to put the sheet up here to show that it can be done as much as anything else. Adapting it might be hideously tricky - I developed the sheets to deal with a set number of vegetation types with a set number of survey points on specific beaches. But, with some persistence, I imagine it might be doable.

It will produce kite diagrams like this one:

Kite diagram

As usual, a diagram like this allows you to add photos and useful annotations in textboxes. That sounds like advanced ICT data presentation to me...

The Resources:

Download and use. Let me know if there are problems with these...

MS Excel iconKite Diagram Spreadsheet

zip file iconZipped version - this might overcome any download problems. The folder will need unzipping on a Windows system (right click > extract all). The spreadsheet and the instructions are included in one download. School networks can sometimes dislike zip files - you may need to talk to your system admin (and give them chocolates, cake or beer!)

You might also be interested in the Beach Profile Spreadsheet which is much simpler and easy to use than this one!

Technical Notes:

The spreadsheet is an Excel 2011 version. It should work in previous versions of Excel without a problem - but please let me know if it doesn't!

There are technical notes on the sheet itself. Note that adding or removing the number of vegetation types might be really quite tricky (changing them is easy!). This is a starting point and I'm not sure that it's ever going to be easy to develop a simple plug and play version of this sheet.

There are various other kite diagram sheets around the internets. None of them seem overly easy to use! I'm happy to think about working on a custom version of the sheet for you if you need it - but you'll need to ask me about that.

If you do manage to use it successfully (or run into major issues with it) I'd be keen to know about it.