Your Data Visualization Secret Weapon
You want to know the trick to fixing most scary data visualizations? The answer to horrifying stuff like this?
What does one do when the graph gives you the shivers?
The answer is always going to be: Small Multiples. Break the graph down into multiple tiny graphs, all on the same scale, arranged in a row or a grid. This way, each piece of the data can stand in it’s own spot of sunshine, where we can see it clearly. It’s a quick way to declutter but beyond that it is the primary method to make sense out of the madness. It’s the secret weapon of interpretability and comprehension. Hat tip to Rob Simmons for sharing a small multiples slopegraph recently. Imagine the insanity if this was all clustered into one graph, as would typically be the case.
Small multiples & slopegraphs https://t.co/dEbj65rQAM new #thumbsupviz cc @AnnKEmery @jschwabish @evergreendata pic.twitter.com/FnCIQUtYix — Rob Simmon (@rsimmon) September 6, 2016
Well, it would look like that bowl of spaghetti up above. Yikes! Small multiples bring clarity.
Just thinking about how this data would look crammed into a single graph makes me cry a little.
How Americans spend their day. #dataviz
Hooray small multiples!https://t.co/1csofUUAgy pic.twitter.com/fxKcutq62B
— Randy Olson (@randal_olson) September 9, 2016
So keep small multiples in your backpocket, right next to your boomerang and your ninja star, because it rescues crazy visuals. It is how you swoop in to save the day when your boss is frustrated because she’s tried a few different graph types and they are all overly complicated. It’s how you get a raise, Superhero.
7 Comments
Leave a Reply
What do you use to make each graph align well with each other? I’ve done simple tables in word but wonder if there’s a better solution (e.g. another program than word)
Hold down shift and click on all the charts. Then look for the Align button. Align is your friend.
Regarding the time spent in a day, you can display it in one single graph:
http://www.nytimes.com/interactive/2009/07/31/business/20080801-metrics-graphic.html?hp
I really need to show this to our Strategy and Institutional Effectiveness office. The spaghetti chart is their friend and it’s so painful to look at. They could use this information to make their charts more visually friendly.
This definitely should be the feature in Excel, as Jorge Camoes already pointed out R has it, SAS has it, QlikView , Tableau…, well, I don’t know, but I guess it has it.
If anyone is interested in making small multiples easier in Excel, the Zebra BI add-in is a great option! You get perfect visuals in just a few clicks. p.s. I love your blog, Stephanie!
Thanks! I know Zebra can do it but I am so wary about plug ins. Maybe I shouldn’t be. But they break! I had this happen to me and had to redo hundreds of client charts on my own dime.