Chart choosing is part art and part science. During workshops, I cover my chart choosing thought process in more detail. For now, let me save you hours of time with this not-so-secret secret: Start with a bar chart.
Then, fine-tine your bar chart. Try your numbers as a regular bar chart and as a stacked bar chart. There are subtle differences between the two options and it’s worth discussing the pros and cons of each approach with your coworkers before publishing your work.
Option A: A regular bar chart
A bar chart should be your go-to chart. No, not a donut, a radar, or a spaghetti line graph. Those are tempting options, I know! Stick with the basics. Don’t distract your viewers with elaborate graphs. Let them look past the graph and think about what the numbers actually mean.
Option B: A stacked bar chart
Light gray shading reminds your viewers that the blue section is only part of the story. No, I didn’t label the gray section. Yes, that was on purpose. Keep the focus on what matters–the blue.
Five years ago, when I was an in-house data person for a large nonprofit in DC, the regular-versus-stacked-bar-chart conversation went like this.
Me: “Hello there, High Up Manager. I’ve got drafts of that important slideshow for the Board to share with you.”
High Up Manager: “Why thank you for being so prepared. I always appreciate a number-cruncher who takes time to look at the numbers in a lot of different ways.”
“My pleasure. Here’s the first visualization: A bar chart showing the number of youth in our programs that graduated from high school on time. Tell me what you think.”
“Wow! We’re doing great! Especially the Category A youth! I wasn’t sure if we were on track! We won’t have to change our programmatic approach at all because everything is going swimmingly!”
“Okay. Now here’s the second visualization: Another bar chart, but this time, the number of youth that didn’t graduate on time is shaded in light gray. Your thoughts?”
“Hmm. Does that gray section show the students who didn’t graduate on time? That’s a pretty big proportion of the graph! I had a feeling that there were changes to make. This is a good reminder that there’s still room for improvement. This is the version we need to show the Board at next month’s meeting. But first, let me run down the hall and share the numbers with our program staff so we can start acting on the data.”
Verbatim? Of course not. The gist of what you should be discussing with your teammates? Absolutely. There are a dozen correct ways to visualize every dataset, and the regular vs. stacked conversation should be part of your drafting process.