New sparklines in Google Spreadsheets are AWESOME

Pete Tong's International Music Summit last week gave me the perfect excuse to use one of my favourite visualisations. Here we use EMI's consumer insight to look at how passionate 17 countries are about dance music.

To get a good picture of what's happening you need to think about not just what percent of people are passionate, but also what that means in terms of the number of people who are passionate. So I like to chart them both and then join them with lines.

This allows you to pretty quickly draw out some fascinating observations. For example: just look at how low the passion is for dance music in the US and yet it's such a big country that it has by far the most people passionate about dance music.

Whereas the UK scores pretty high on both metrics. I called it the 'biggest developed market'.

My full report is here and EMI have made all of this data available by country by demographic group by genre. Take the data and have fun with it! Please share what you come up with!

View comments

Info Clarity

View comments