Tag archive for stacked bar

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 →

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 →

Dataviz Challenge #5: Can You Make a Diverging Stacked Bar Chart?

Dataviz Challenge #5: Can You Make a Diverging Stacked Bar Chart?

Last week I shared strategies for improving any chart’s colors. One of the examples was a diverging stacked bar chart: I love stacked bar charts because they’re pretty versatile, and because they’re a great chart for lots of evaluation and survey data. In my example,…

Continue reading →