GMN is the Grant Managers' Network. This afternoon, I had the distinct pleasure of speaking at their annual conference in San Antonio.

My topic was storytelling with data, presented in two 90-minute sessions to about 200 super engaged grant managers. The first session was an overview of data visualization best practices. The second was a hands-on workshop focused on applying the lessons covered in the first session to real examples (submitted by participants) to practice employing those freshly learned skills for showing philanthropic impact through storytelling with data.

With this post, I thought I'd recap the lessons I covered today and show them applied to one of the visual makeovers that we focused on during the workshop session.

First, the lessons:

Choose the right type of display: leverage bar charts whenever possible due to ease of interpretation, lines are for continuous data only, avoid pies
Eliminate the clutter: get rid of the stuff that doesn't need to be there, de-emphasize the necessary but non-message impacting stuff
Focus attention where you want it: leverage pre-attentive attributes (color, size, thickness, enclosure, placement on page) to draw your audience's attention to the important parts and create a visual hierarchy of information
Think like a designer: include affordances that make it clear to your audience how they should interact with your visual, make the visual accessible by favoring simple over complex, take the time to make your visual aesthetically pleasing to gain your audience's attention and patience
Tell a story: don't use graphs to show data, use graphs to reinforce your story; make your story explicit with words

Now, let's take a look at these lessons applied to one of the participant-submitted visual. Here's the visual:

There is a lot of information here. Here's a glimpse into my thought process as I look at it and start to figure out how I want to approach turning it into a story:

I'm unsure at first how the data in the graph and two tables are related. The first thing I did was some math to try to better understand how the numbers relate to each other (to learn/verify things, for example Adoptions + Transfers + RTO = Live Release).
Upon closer inspection, it seems the overall story is around positive (live release) and negative (euthanasia) outcomes; I want to make these two sides of the story more immediately visually clear.
There are some unfamiliar things that I want to clarify: the acronym RTO and the fiscal year dates (so I know whether/how to compare Jan to FYTD). A quick email exchange with the submitter later, I learned that the former is "Released to Owner" and the latter is Oct-Sep.
Depending ont he story to be told, there may be too many comparisons. The way it's set up now makes me want to compare Jan figures with fiscal YTD figures, which probably doesn't make sense.
I crave an action title: the top-of-page space is precious because it's the first thing an audience encounters. I should be used to tell the audience what they need to know and orient them to the information that will follow.

After sketching out some things on paper and iterating a few times in Excel, here is my makeover of the visual:

Let's take a brief look at the changes I made, according to the 5 lessons I outlined at the beginning of this post:

Choose the right type of display: This isn't necessarily the right display, but it's one approach. I combined the data into a single visual and made life and death visually opposing (note that death is both red and in the negative direction to reinforce visually that it is a poor outcome).
Eliminate the clutter: I reduced the visual comparisons by focusing on FYTD and eliminating the January comparison. I pushed the axis and axis labels to the background by making them small and grey so they wouldn't compete for attention with the more important parts of my visual.
Focus attention where you want it: I made use of pre-attentive attributes: bold, color, space, and size of text to draw the audience's attention to the important parts.
Think like a designer: In this case, this was mostly about paying attention to detail: making sure things were aligned, leveraging white space, and trying to make the visual as easy to understand as possible.
Tell a story: I added a story in words to make the message clear.

I also did another version with a very slight twist to show how relatively small changes can completely reframe the overall message:

What do you think? If you attended one of the sessions, I welcome feedback on what worked well and what could have been better. (Other comments welcome, too.)

Stay tuned - I'll post about the other makeovers in the coming weeks. If you're a first time visitor to my blog, you can sign up for email updates in the upper left. I'll also point you to a couple popular posts: how to do it in excel and no more excuses for bad simple charts: here's a template. Happy storytelling with data!

To download the spreadsheet with the visual above, click here.