Waffle chart

In this lesson, you learn how to insert a Waffle Chart in Excel. Waffle Chart is a good choice for Power Point presentations.

Prepare data

To start preparing a Waffle Diagram in Excel you need to prepare chart area. I did it for 10 x 10 cells area what is the most used for that type of chart. As you see on the picture below I set grey color for cells background and changed font color to grey.

Prepare Chart Area

Conditional formatting

Next, you need to set conditional formatting for cells inside a chart area. To do it go to ribbon and click Conditional Formatting -> New Rule.

Conditional Formatting New Rule

New Formatting Rule should be set for cells that contain equal to TRUE value. You need to click Format button and set Font color and Fill to the same color. I chose blue.

New Formatting Rule

The formula

Next, click the first cell in your chart area and use this formula: =((ROW($E$13)-ROW())*10+COLUMN()-COLUMN($E13))<$P$5

Drag and drop the cell and set it for every cell in the whole area.

Enter Formula

The chart

The last step is the value. Type some value to the P5 cell to check if the Waffle Chart is working properly.

Waffle Chart Working

In the end you can to format you chart.

Example Waffle Chart

After chart formatting, your waffle graph can become more fancy like this one.

Waffle Chart Three Colors

See also  How to Create Interactive Charts in Excel