|Click to embiggen. Share via twitter | facebook
With the data above we can create a map of Wales depicting which council areas returned which political party. By doing so you get the following result.
|EU map of Wales by council area - Share via twitter | facebook
From here we can do some other interesting things, namely divide the parties into pro-EU and anti-EU and see how that looks as a map. Of course I should preface this as saying it's non scientific but it'll be interesting. I have divided the parties as follows.
Pro-EU. Plaid, Labour, Lib Dem, Green.
Anti-EU. All the others.
|In this unscientific poll the majority of Wales is pro-EU. Share via twitter | facebook
|Full tables of pro-EU party votes vs anti-EU party votes. Share via twitter | facebook
I shall update the page as and when I create new sexy charts, maps or whatever else I can think of.
Share via twitter | facebook
*Simple process is adding a max and min functions for each column and then using a conditional format to make the cell that equals the max turn green and the cell that equals the min turn red.