I say: Trend over time? You say: Line graph! I know, that’s how it goes, right? We are so used to seeing trends over time visualized as line graphs that even my 3rd grader can interpret them with ease. But sometimes it helps to have other options that better fit your…
data visualization
The Most Important Question in Data Visualization
What’s your point? Seriously, that’s the most important question to ask when creating a data visualization. And its the first thing I ask a client who sends me data for redesign. What’s your point? The answers drive nearly everything about visualizing that data. Here’s how that conversation often goes: Client:…
Visualize Branching Questions with Nested Area Graphs
This, my friends, is a nested area graph. I got this idea from the smart people at Innovation Network. And it is super amazing at visualizing the sequence of survey questions that branch. The kind where it says “if you said Yes, proceed to question 32” and stuff…
Data-Driven Decisions in a Fortune 500
More and more, organizations are on board with the idea of becoming “data-driven.” Collecting data on key indicators is a big step ahead from where many organizations used to be. But being able to interpret that data and share it with others in an intelligent way is equally as important…
How a Dashboard Changes the Conversation
Presenting data effectively changes the kinds of conversations that can happen inside organizations. Better presentations shape an improved culture of decision-making. Let me tell you about a recent example of this. Late 2012 I got a call from an evaluation officer who was working at the Walton Family…
Numbers, Guts, & Culture: How Data Visualization Changes the Conversation
Numbers have power, if you have the courage to use them powerfully. Take these two stories from opposite ends of the 20th Century. The first story is about a man in a steel mill. The second is about the crash of a giant. Charles Schwab had a mill manager whose people weren’t…
Directly Labeling in Excel
It’s time to ditch the legend. You know – the legend, the key, the thing to the right of the graph that tells the reader what each piece of your graph means. We don’t need it. Legends are actually hard for many people to work with because they put a…
When It’s OK to NOT Start Your Axis at Zero
UPDATE: This post was written in 2014 and my thinking has evolved since then. Here’s the newest post on how to handle all of your axes. You can also join us at the Evergreen Data Visualization Academy where we banter back and forth about these ideas and apply…
Declutter Dataviz with Small Multiples
Are you making graphs that look like this crap? I won’t make you raise your hand. But let’s just agree not to do this, yeah? It’s SUPER hard to compare the tops of a bunch of bars. Two side by side bars per region ain’t so bad but beyond…
The Easiest Way to Make Bullet Charts in Excel
There are lots of ways to make bullet charts, some easier than others, some better suited for specific visualization contexts. Hell, there are plug-ins you can purchase that make it a snap. Except when my plug-in broke and I had to remake about a…