Archive for Choose the Right Chart

How to Make a Waffle Chart in Excel

How to Make a Waffle Chart in Excel

Waffle charts display part-to-whole patterns. They’re kind of like square versions of pie charts. I introduced them in an earlier post about visualizing survey results. Look familiar?   Here’s how to make waffle charts within good ol’ Excel. The first few steps are a little…

Continue reading →

Transforming a Table: Four Charts and Four Different Stories

Transforming a Table: Four Charts and Four Different Stories

A few weeks ago I gave the keynote speech at the Alabama Power Foundation’s Elevate conference for several hundred of their grantees and partners. What a day! As part of the most-practical-keynote-you’ve-ever-heard emphasis, we included makeovers from the grantees’ real projects. In case it’s useful…

Continue reading →

Visualizing Survey Results: Check-All-That-Apply Questions

Visualizing Survey Results: Check-All-That-Apply Questions

Most of the surveys I’ve designed, analyzed, and even taken have included a check-all-that-apply question. Today’s post includes three ideas for visualizing those survey questions and a bunch of transparency about my own mistakes along the way.   The Survey Questions Last month I spoke with Harvard University graduate…

Continue reading →

Visualizing Survey Results: Crowded Agree-Disagree Scales

Visualizing Survey Results: Crowded Agree-Disagree Scales

There’s more than one way to visualize those agree-disagree survey scales. Today, let’s look at seven of your choices.   Survey results Last month I spoke to Harvard University graduate students about visualizing survey results. I made up some fake numbers to accompany their real survey questions….

Continue reading →

Visualizing Survey Results: Assessing Knowledge Before and After a Program

Visualizing Survey Results: Assessing Knowledge Before and After a Program

A couple weeks ago I spoke to Harvard University graduate students about visualizing survey results. This not at all to very survey scale is quite common in my research circles so I’m sharing our ideas with all of you, too.   Before Here are some of the…

Continue reading →

Page 1 of 9 1 2 3 4 5 ... Last →