The simplest way to show many types of data is through a column or bar chart, ordered greatest to least. These will work just fine, most of the time. When do they fall short? Well, when the values are all high, such as in the 80-90% range (out of 100%). Then…
Excel
State of the Union 2016 Slideshow
Dudes, the State of the Union is my Superbowl. I look forward to this event like some people anticipate the Oscars. This is my deal. Why? Because the enhanced version of the SOTU features a data-based slideshow, a perfect study in how graphics can help underscore a point. And, as…
No More Red Yellow Green
Listen we absolutely must stop using the stoplight color system in our data visualizations and dashboards. You know what I’m talking about. It’s stuff like this: and this It’s the worst thing ever. For several reasons. Here’s they are: The red-yellow-green color coding system isn’t…
508 Compliance & Data Visualization
508 Compliance became A Thing to Deal With in 2000 and 15 years later people still have questions about how it works. I get questions about how to be 508 compliant in nearly every workshop. 508 compliance essentially means that people who produce things on the web for any federal…
Three Ways to Show Down is Good
Humans in the western culture tend to see things that trend upward as positive and lines that trend downward as bad. But what if bad is good? And not like my college boyfriend. But in the sense that a decrease is a good thing. Let’s use the example of weight…
Make a Slopegraph in Excel
Slopegraphs are a newer graph type with powerhouse capabilities. They rely on Excel’s line graphing feature but they don’t necessarily have to show change over time. Slopegraphs play into our ability to judge slope fairly well. For this reason, they are perfect for highlighting the story of how just one…
President Obama’s Data Visualization
I realize it’s completely taboo to write about current events six months after they’ve happen but I DON’T CARE. One of my favorite events of the year is watching the enhanced version of the State of the Union. Not the regular view – the enhanced view. One side of the…
When I Don’t Mind Radar Graphs
Most of the time, I think radar graph are deployed wrong. They are designed to show percentages along several categories – like a bar graph could – but the axis are distributed around a central point, such that the percentages link together and create a shape. Choosing a radar graph,…
Visualizing Tiny Trends Over Time
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…
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:…