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…
The SEQUENCE Function (Microsoft 365 Only)