Showing posts with label graph. Show all posts
Showing posts with label graph. Show all posts

Saturday, 26 April 2014

Problem solving with spreadsheets: how to turn a list into a running total (and have a laugh at David Moyes' expense)

As a follow up to my post about scraping websites using Import.io where I scraped data about the most successful premier league football teams, I decided to make the data tell a better story than a simple bar chart of total league titles, which looked like this:


Thursday, 6 February 2014

Making an interactive Graph

I wrote a comment piece for our science news blog, Catalyst Science News, with the headline Why we should privatise space. I will link to it when it is published, as it is still to be edited. Part of my argument was that the traditional nation state superpowers were showing a declining interest in space exploration, but I felt I needed some sort of data to illustrate this.

I found some data used by The Guardian Datablog from a few years ago. their sources seemed pretty sound (Office of Management and Budget and richardb.us) so I decided to make a few graphs to go with my article. 
I used Google speadsheets to make the graphs, and I'm sure you'll agree they are less than inspiring: