Tag archive for Microsoft Excel - page 2

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 →

How to Enter Your Custom Color Codes in Excel

How to Enter Your Custom Color Codes in Excel

If you want to look polished, then you have no other choice but to customize your visualization’s color palette. Don’t worry–customizing your colors is an easy low-hanging-fruit edit. Locate your style guide, scroll down to the color section, and decode the jargon. If you don’t…

Continue reading →

Pie Chart Makeover: Revenue and Expenses

Pie Chart Makeover: Revenue and Expenses

A couple weeks ago I was in Birmingham with the Alabama Power Company’s grantees. We spent two days learning data visualization principles and producing makeovers of their graphs. Before One of the grantees was presenting their revenue and expenses data like this, in two pie…

Continue reading →

Pie Chart Makeover: Quarterly Breakouts by Gender

Pie Chart Makeover: Quarterly Breakouts by Gender

A few weeks ago I was in Indianapolis with the juvenile detention alternatives initiative. This group wanted to graph: how many youth went to juvenile detention centers, by gender, and by quarter. Brainstorming There are a dozen ways to graph each dataset. For this data,…

Continue reading →

How to Sort Your Bar Charts

How to Sort Your Bar Charts

“Ann, my bar chart is upside down! Help!” You read my prior post about using horizontal bar charts for nominal variables like favorite fruits. My toddler is eating two! bananas a day so bananas are the winner in this fictional fruit contest. Our original table…

Continue reading →

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