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 a frame of 100 squares in a 10 x 10 frame, we have columns called Rows, Columns, and Percentage. Each row and column has a value of 1 through 10, repeating. This creates a 10 row x 10 column square. The first 20 are displayed in the following screenshot:
- Add Columns to the Columns shelf and Rows to the Rows shelf. Because we want these values to ...
