Data visualisation and storytelling

Create

How to make “bar chart race” visualizations without coding

Animated bar charts are taking social media by storm. You can now make one in seconds by uploading a spreadsheet to Flourish.

It all started with a tweet1. To be precise, this one from Matt Navarra, a British digital media consultant who used to be the director of social media at The Next Web.

As Navarra’s tweet bounced around Twitter, racking up thousands of likes and retweets and hundreds of replies, the driver of its virality seemed to be an overwhelming enthusiasm for the visualisation he had included. In the words of one of Navarra’s repliers, “This is mesmerising & strangely soporific!”

So yes, you can now make these mesmerising and strangely soporific bar chart races yourself, in Flourish, just by uploading a spreadsheet. Here’s an example:

Make a bar chart race »

Cool features!

We had such a great response to the bar chart race template that we’ve added a whole bunch of extra features. You can:

  • Let the user filter by category just by clicking on the legend
  • Add circular or rectangular images positioned at either end of the bar
  • Show the labels on the bars or to the left
  • Show a totaliser to show the total across all rows in the data sheet
  • Fix the height of a bar and have the embedded graphic change size to accommodate them
  • Lock the axis if you want to focus the viewer’s eye on the absolute changes
  • Sort the bars to show the lowest values instead of the highest
  • Choose what happens when there are blank cells in the data

How we got here

After Navarra’s tweet went viral, these bar chart race visualisations began popping up more and more. Football data was particularly popular.

Then earlier this week, John Burn-Murdoch, a data visualisation journalist at the Financial Times in London, fanned the flames, tweeting out his own code for making one of these bar chart races.

After Burn-Murdoch’s tweet there was no stopping them – suddenly bar chart races were everywhere.

The thing is, these bar chart races are cool – they really are. But while copying Burn-Murdoch’s code and tinkering with it to make something new is easy and fun for developers and journalists who know JavaScript, it’s a bit baffling for the non-coding majority who want to make one of their own.

Enter Flourish!

After a couple of days of watching our Twitter timelines fill up with hand-coded bar chart races, we thought, Hey, this can’t be that hard! Also, “bar chart race”, doesn’t that sound a lot like “horserace”?. So we quickly added a Flourish template for this in-vogue visualisation style. Check it out and let us know what other templates you’d like to see.

Make your own bar chart race now »

1. Although the brand example was the first viral bar chart race, it surely wasn’t the first visualisation in this style. Flourish’s creators, Kiln, made a bar chart race of sorts for the British Council about six years ago. It’s still live here. But that seems unlikely to have been the first too! Does anyone know of an earlier example? Tell us on Twitter if so!