What is a waffle chart?
A waffle chart shows a value as a share of a whole using a grid of squares. This Excel template helps you build and understand one from scratch.
Good to know: it's structured to make customization easier, but it isn't fully drag-and-drop. Expect to adjust layouts, labels, and your data structure to fit.
What's included
- A working waffle chart
- Scatterplot-based construction you can learn from
- Auto-normalization from value + min/max to a percentage
How it works
It uses a scatterplot as the base. Enter your value plus a minimum and maximum, and it normalizes to a percentage and plots the grid.
Who it's for
Anyone showing part-to-whole or percentage-of-target figures.
Excel compatibility
Designed for Microsoft Excel on Windows and Mac — Microsoft 365 or Excel 2021 recommended. Built for Excel, not Google Sheets.