A Waffle Chart is an easy-to-understand, easy-to-read visual that displays values as a percentage of a whole in a grid of squares. Think of it as a square pie chart! Not only is a Waffle Chart easier to read, it looks impressive too!

In Excel, Waffle Charts don’t exist as a chart type but using Conditional Formatting and a couple of other tricks, you can easily create one. So if you’re looking for an easy-to-understand, easy-to-read visual to represent your data and impress your audience, this is a must-watch video. Links to the video and individual sections below…

What is a Waffle Chart?

The SEQUENCE Function (Microsoft 365 Only)

Formula to Generate Sequential Numbers (Non M365 Method)

Apply Conditional Formatting

Hide the Numbers

Apply Borders