Make Waffle Charts in Excel... the EASY way | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Check out the blog post★

★ About this video ★
Waffle charts are like square pie charts. However, rather than slices of a pie, values are represented by the number of colored squares. They are commonly found on dashboards and newspaper articles because they are easy to read at a glance.

In this video, we look at how to make waffle charts in Excel using the easiest method possible.

0:00 Introduction
0:29 Waffle Charts in Excel
5:52 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel

[robalan]

This is amazing! Thank you for sharing this technique!

[ExcelWithChris]

Tank you! Best ever. Always wanted to create these for my dashboards.

[MichaelBrown-lwkz]

Excellent instruction. Simple and to the point.

[kenmcmillan]

Outstanding Mark! Thank you for this tutorial!!

[ElleBiba]

A little tip:
Instead of changing the font color to the background color: Set the number format to Custom and type: ;;; (three semicolons)
That's it!

[leonardobergua]

I wanted to make a planning/calendar from a list of dates and events and I didn't know how to do it. You've given me an idea of how to get started. Thanks ! ⬆⬆