Make waffle charts! (Excel & PowerPoint)

Tune into our upcoming free, open-to-everyone live event on June 20th at 11AM ET. Please spread the word to colleagues and friends interested in joining! Register here: ti.to/storytellingwithdata/ex...
Do you want to learn how to create waffle charts (also known as matrix charts or square area charts)? This video tutorial goes step-by-step through the process and creates versions in both Excel and PowerPoint.
As waffle charts aren't part of the standard set of graphing options in Excel a little creativity is required. In this video, the following techniques are covered:
- creating a waffle chart in Excel by adjusting the width and height of rows and columns and formatting appropriately.
- adding a formatted table to a PowerPoint slide, resizing and formatting to achieve the waffle chart look.
- Copying and pasting the slides and making small changes to each version of the waffle chart to build up the story as you walk your audience through it
A waffle chart is a square display. They often consist of a 10x10 grid containing 100 individual squares. The squares are then coloured based on the data that's being visualised. The chart gets its food-based name from its resemblance to a tasty waffle. (Sometimes this type of chart is referred to as a “unit chart,” although that term applies more appropriately to a broader category of visualisations, which tend to use discrete icons, rather than squares, to represent the values.)
JUMP TO THE SECTION THAT INTERESTS YOU
00:00 Intro
00:42 Making the waffle chart in Excel
03:14 Making the waffle chart in PowerPoint
04:20 Outro
MENTIONED IN THE VIDEO!
● Our immersive, 8-week online course will build your skills and confidence to make great graphs and slides, weave them into compelling narratives, and communicate in any situation with prowess.
Check out the details, here.
ti.to/storytellingwithdata/co...
BROWSE RELATED RESOURCES
● SWD chart guide: www.storytellingwithdata.com/...
● Excel tutorials playlist | • Excel tutorials
● How to turn data into stories: a mini workshop | kzbin.infoHfx1X9WSGYQ
IMPROVE YOUR DATA VISUALIZATION & STORYTELLING SKILLS
📚 Order Cole’s new book! storytellingwithyou.com
📚 Read the books: www.storytellingwithdata.com/...
🖥 Follow the blog: storytellingwithdata.com/blog
📊 Practice in the SWD community: community.storytellingwithdata...
🎧 Listen to the podcast: storytellingwithdata.com/podcast
🍎 Attend a workshop: storytellingwithdata.com/works...
STAY CONNECTED
👉 LinkedIn: / storytelling-with-data...
👉 Twitter: / storywithdata
👉 Instagram: / storywithdata
💡 Don’t forget to subscribe for new videos! kzbin.info...

[@azwarmzafar]

Absolutely out of the box tips, many thanks.

[@ElSrMuro]

Perfect timing! I was trying to do a graph like this and boom!, a new video explaining how to do it. Many thanks!!!

[@storytellingwithdata]

Fantastic, perfect timing indeed! Thanks for watching :-)

[@spongebobby188]

Keep up the great content... Really helpful! ❤

[@storytellingwithdata]

Happy to hear that! Thank you.

[@sidahmedbensaad1838]

Thanks 👍