Waffle charts have almost similar use cases to Donut charts. They are used to show how items contribute to a whole. They are best used when comparing only a few categories.
Waffle charts
Getting ready
In this recipe, we will create a Waffle chart using a text table as the foundation.
How to do it...
To follow along, open the Waffle chart packaged workbook. In this example, we are looking at word counts for each Lord of the Rings character by race:
- Use the Waffle frame Excel sheet:
- This Excel sheet is 100 rows representing each percentage point. Because we want to create...