The Waffle Chart isn’t a real type in Excel, but it’s a visualization tool you’ve seen in a lot of places. You can use Conditional Formatting to color-code different cells in a grid pattern, and it automatically updates when you change the inputs.
To download the spreadsheet we’re working on here, click to get it from Google Drive.
Techniques used in this video include:
- Using SUMIFS to compile the results
- Using Drop-Downs to change the inputs dynamically
- Using Conditional Formatting to color-code cells based on values