Watch the complete on Youtube
Elevate Your Data Visualization Game!

Are your Excel dashboards in need of a fresh look? Move beyond basic bar and pie charts—learn how to create a dynamic Waffle Chart in Excel! This eye-catching chart is perfect for showing percentages, progress tracking, or survey responses in a simple, visual format.

What is a Waffle Chart?

A Waffle Chart displays data as a 10x10 grid (or other sized grid), where each small square (cell) represents 1% of your total, making progress and comparisons instantly clear for your audience.

Step-by-Step Guide: Creating a Waffle Chart in Excel

1. Set Up a 10x10 Grid

• In Excel, create a 10x10 grid—each row and column contains 10 cells.

• Use the SEQUENCE function in Office 365:

   

  =SEQUENCE(10,10)

  This generates numbers from 1 to 100 instantly.

2. Prepare Your Data

• Suppose you want to display a percentage (say 75%).

• Use a Scroll Bar (Developer Tab) for interactivity.

  • Minimum = 0, Maximum = 100.

  • Link it to a cell for dynamic updates.

3. Transform Number Sequence (Optional)

• By default, SEQUENCE fills numbers in ascending order.

• To reverse order, adjust formula logic (e.g., subtract from 101).

4. Apply Conditional Formatting

• Select your 10x10 grid.

• Go to Home > Conditional Formatting > Icon Sets.

• Choose Three Traffic Lights (or similar icons).

• Edit Rule:

  • Green icon = values less than or equal to your linked percentage cell.

  • No icon = values above percentage.

5. Customize Your Chart

• Hide the numbers, show icons only.

• Resize cells into squares for a true Waffle look.

• Match the colors with your dashboard theme.

Expert Tips

1 Flexible Sizing: Try 5x20 or other layouts for a unique look.
2 Best For: Social media dashboards, KPI tracking, survey results.
3 Compatibility: SEQUENCE requires Office 365/Excel 2019+. Older Excel? Use manual numbering.

Final Touch

Once ready, move the scroll bar to see your Waffle Chart update instantly—a powerful way to show data at a glance. This chart isn’t just more engaging; it makes complex numbers visually simple.

Ready to transform your reports? Create your first Waffle Chart in Excel and impress your audience today!