Archive for Tutorials

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 →

How to Find Your Custom Color Codes with Paint

How to Find Your Custom Color Codes with Paint

Lots of my workshop participants are government employees who don’t have or can’t find style guides and/or they’re not allowed to download eyedropper tools to locate color codes. Microsoft Paint to the rescue!   Hi! I am Matt Feldmann with Goshen Education Consulting in Southwestern Illinois…

Continue reading →

How to Find Your Custom Color Codes with an Eyedropper

How to Find Your Custom Color Codes with an Eyedropper

You know you’re supposed to customize your color palette to match your organization’s branding. You know you can find your color codes in your existing style guide. But what if you don’t have a style guide? Or can’t find it because it’s buried within your…

Continue reading →

How to Flip Your Bar Charts

How to Flip Your Bar Charts

“Ann, I read your latest post, and I accidentally made a horizontal bar chart when it should’ve been a vertical bar chart! Am I going to have to delete my graph and start from scratch?”   No way. Don’t delete a thing. That would be a huge…

Continue reading →

Page 1 of 4 1 2 3 4