How to Make Dumbbell Dot Plots in Excel

How to Make Dumbbell Dot Plots in Excel

Data visualization is so cool because it helps you see things that would otherwise take a looooooot of effort. Here’s an example. Some very sweet clients in Maricopa County, Arizona (that’s the greater Phoenix area, friends) had a habit of presenting super important...
Data Nerd Thank You Cards

Data Nerd Thank You Cards

In years past, I designed for you cards to help you celebrate Valentine’s Day and the winter holidays like the data nerd you really are. But truth be told, my favorite holiday is Thanksgiving. I love the food, the focus on family, and the deep expressions of...
Anyone Can Do Graphic Design, Even You

Anyone Can Do Graphic Design, Even You

This is the kind of post you either love or hate. You hate it if you are a graphic designer. When graphic designers are in my workshops, they usually spend the first part nodding their heads in passionate agreement because I’m educating their research team on things...
Don’t Visualize

Don’t Visualize

Here’s the deal: People primarily look at pictures. That’s why we visualize data – to get people to look at it. But if we waste the short amount of attention people are willing to extend to us by showing them visuals that don’t convey a point, we quickly teach them to...
Evergreen Collections

Evergreen Collections

The end of August marks an important moment for me because it is when I quit my salaried job to work on data visualization and design full time. 5 years! It remains one of my best decisions. So, I like to celebrate it with you. Last year, I launched the Evergreen Data...
Visualizing Not Applicable or Missing Data

Visualizing Not Applicable or Missing Data

Yes, I know the jig is up. All of my examples in books and workshops are pretty tidy, as if every response options was addressed by every single respondent. The truth is that life and data collection are messy. How can we show that different questions have different...
Color Psychology

Color Psychology

As I usually do in my workshops, I talked to a group in Warsaw, Poland about how we should use color intentionally in our data visualization and that, in fact, the color choice itself can help us tell our story. I prepared a little activity around this issue, in which...
Easy, Simple One Page Handout

Easy, Simple One Page Handout

Few things are more tragic than excellent non-profits doing great work to help struggling families but can’t tell their story effectively. In this blog post, I’m going to step you through the redesign of a one page handout I created for my clients at the...
Interactive Heat Maps

Interactive Heat Maps

Hello friends, this is Jenny Lyons here. I’m back for another discussion of qualitative data visualization. I have something fun and exciting to show you today: interactive heat maps. One of the most common ways to analyze qualitative data is through thematic coding....
The 1-3-25 Reporting Model

The 1-3-25 Reporting Model

It’s time to talk about how a highly visual, well-formatted recommendations page doesn’t have much impact when it is buried on page 104. This is how we make reporting less cumbersome, particularly in a digital reporting era. Of course your reporting will probably...