Evergreen Data Visualization Academy

The Data Visualization Academy is only open for enrollment twice a year. Come get select access to my best data visualization tutorials and advice. Four years ago today, I took the leap from salaried employee to independent consultant. Since then, I’ve worked with scores of organizations to help them use…

Read More

Make It A Game

I spend a lot of time talking about really serious data with incredibly focused people. I love them and I love my job. But sometimes I need to balance that out with some Lucky Charms. So while eating my bowlful of magically delicious sugar bombs the other day and looking at…

Read More

My New Favorite Graph Type: Overlapping Bars

Why have I fallen in love with this graph type? I think its because its such a great way to visualize the comparison between two things, when one is inherently a part of the other. In recent client projects, I’ve used these to show actual v. budgeted amounts. Or individual…

Read More

Book Club with Alberto, Andy, and Jorge

So far this year we’ve seen a ton of great books on data visualization published! What an awesome time! I got together with Alberto Cairo, Jorge Camoes, and Andy Kirk to talk about our books and the writing process in general. Not sure which of the latest…

Read More

How Middle School Math Pays Off

Dear Mrs. George’s students, Awhile ago I met your teacher at a wedding reception. Her bestie married my father. As one does when engaging in small talk, she asked me what I do for a living. Me: I teach people how to present data. Ever seen a really terrible PowerPoint?…

Read More

Design of an Award Winning Report

So long as we are going to write reports, we might as well make them heavy on the visuals and do everything in our power to make the report easy to navigate, especially in a mobile reading culture. There are lots of ways to do this but one of my…

Read More

Automatically Updating Graphs in Word or PowerPoint

I have so much money in the bank I’m going to give away my number one reporting time saving secret (HAHAHAHAH not at all! I’m giving it away because I love you and I want to make your life easier). This is how you link Excel to your other reporting…

Read More

How Dataviz Can Unintentionally Perpetuate Inequality Part 2

Last time Vidhya and I posted on this topic, we addressed how the use of color to visualize individuals can do more harm than good. This time Vidhya joins me again to talk about poverty and opportunity. Organizations in the Minneapolis-St. Paul metropolitan area community identified and started tracking indicators…

Read More

Guest Post: Best Practices for Control, Run, and Pareto Charts

Nicole contacted me with an email subject line: Thank you for the Data Viz Checklist! and she said she’d been using the checklist to overhaul some of her organization’s data visualizations. I’ve invited her here to showcase her before and afters. I’m Nicole Huggett and I recently transitioned…

Read More

Make A Lollipop Graph in Excel

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…

Read More