This Lovely Data Viz Of Tornado Hot Spots Was Made In Excel

This Lovely Data Viz Of Tornado Hot Spots Was Made In Excel

This geometric data visualisation shows the occurrence of tornadoes across the U.S. since 1950. It’s straightforward, good-looking and… made in Excel.

Created by John Nelson, the map looks like it could have been made something rather more design-focused. But given each of the cells is just a simple square, Excel can, it seems, do the job just fine. Nelson explains:

While pivoting data in Excel, it occurred to me that I could drag the latitude data into the row and the longitude data into the column. The result would be a 1980’s-Nintendo-looking chunky cell map (which, if I make the cells square, happens to be a pseudo-equirectangular projection).

And… it works! In fact, he’s put together a post that walks you through the process of creating such visualisations yourself, adding that “[o]nce you get the hang of it, you can crank these suckers out in about two minutes.” Perhaps not one for data visualisation purists, but neat nonetheless. [John Nelson via Flowing Data]


The Cheapest NBN 50 Plans

It’s the most popular NBN speed in Australia for a reason. Here are the cheapest plans available.

At Gizmodo, we independently select and write about stuff we love and think you'll like too. We have affiliate and advertising partnerships, which means we may collect a share of sales or other compensation from the links on this page. BTW – prices are accurate and items in stock at the time of posting.