In an earlier video, we built a Waffle Chart in Excel with Conditional Formatting. There are two limitations to this technique: (1) Conditional Formatting is intensive on the processor, because of its constant recalculation, and (2) it only creates a grid of boxes. So, in this tutorial, we use a custom Number Formatting technique, together with a font that has some interesting icons built in (Web Symbols Liga) to create a person infographic grid.
Techniques used for this video include:
- Compiling data with SUMIFS
- Calculating location with ROWS and COLUMNS
- Custom number formatting