How to Create a Waffle Chart in Excel

How to Create a Waffle Chart

Ever wonder how to create a pie chart in a form of squares instead of circles? This customized chart is called Waffle Chart. Who knows, you may consider using this chart in the future when you get to know about this. Please watch the video to learn how to create this from scratch.

Waffle Chart
Square charts, also called Waffle Charts, are a form of pie charts that use squares instead of circles to represent percentages. Similar to basic circular pie charts, square pie charts take each percentage out of a total 100%. They are usually 10x10 grids, where each cell represents 1%. Despite the name, circles, pictograms (such as of people), and other shapes may be used instead of squares. The benefit to these is that it is easier to depict smaller percentages that would be hard to see on traditional pie charts. (Source: Wikipedia)

Download Practice File:

*********************
What you will learn in this video tutorial?

FORMULA
* Sum
* Vlookup
* Rand()

FORMATTING
* Conditional formatting
* Conditional formatting (Stop If True)
* Format painter
* Percentage
* Chart

KEYBOARD SHORTCUTS
* F4 (Enter $ sign in formula)
* Ctrl + R (Fill right)
* Ctrl + Arrow right (Move to the next worksheet)

Others
* Drop down list

It’s what you learn after you know it all that counts.
- John Wooden

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:

YouTube Playlist:

See you there!

Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert
Microsoft Innovative Educator

"To EXCEL in the workplace, one must know how to use excel!"
- Romeo

Tagalog Excel | Filipino | Pinoy Excel | Excel Tutorial | Excel Tagalog Tutorial

#excel #microsoftexcel #excelbyromeocostillas

[HomeEconanay]

ang galing galing naman po...very informative..sir salamat po sa pagpasyal sa akin :)

[MyAudioBookCompilation]

Thank you po sa information. Mayroon pa akong hindi alam sa ganitong pamamaraan. I po promote ko ang channel na to sa mga studyante ko. 👍

[bisdakokz]

full package done po idol romeo. sana mabisita nyo din po ang amin.