Building a Person Infographic [VIDEO]

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

Download the spreadsheet.

Leave a Reply

Your email address will not be published. Required fields are marked *