Easy Excel Waffle Charts..Better than Pies and Doughnuts!

Excel Waffle Charts are a popular way to visually display parts to a whole. You can think of them as an alternative to pie and doughnut charts. In this video I show you a couple of ways to create waffle charts using conditional formatting.
🔻 DOWNLOAD EXCEL FILE HERE: www.myonlinetraininghub.com/e...
🎓 LEARN MORE in my Excel courses: www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟‍♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 Introduction
0:38 Relative Waffle Charts
1:46 Non-dynamic Array Method
3:30 Conditional Formatting
6:04 Absolute Waffle Charts
7:47 Conditional Formatting
9:10 Non-dynamic Array Method
9:59 Waffle Charts with Symbols
13:14 Precise Waffle Charts

[@nsanch0181]

Beautiful chart. Thank you for showing that and the conditional formatting.

[@MyOnlineTrainingHub]

Glad you liked it!

[@martinpaulbannister1745]

Another beautiful presentation. Ur video clips are always clear and to the point. Another chart type to learn for my dashboards. Thank u from sunny Wigan 😎

[@MyOnlineTrainingHub]

Thanks so much, Martin!

[@Luciano_mp]

Very nice, beautiful. Thank you Mynda!👏

[@MyOnlineTrainingHub]

Thank you! 😊

[@jamessawyer8565]

Wow, great tutorial, thank you! High quality as always

[@MyOnlineTrainingHub]

Glad you liked it, James!

[@santchev1326]

Hey Myanda, you’re genius. Thank a lot for that trick really helpful 😁

[@MyOnlineTrainingHub]

Glad it was helpful!

[@darrylmorgan]

Hi Mynda!Really Clever And Helpful Tutorial...Thank You :)

[@MyOnlineTrainingHub]

Thanks, Darryl!

[@Heavieth]

Wonderful as usual. Thank you!

[@MyOnlineTrainingHub]

Cheers, George!

[@arunrai2909]

I simply loved this... Thanks a lot!

[@MyOnlineTrainingHub]

Glad you enjoyed it, Arun!

[@victor-mihailpopescu1027]

Great lesson!

[@MyOnlineTrainingHub]

Glad you liked it!

[@KLINT_Com-Net]

I think this just might come in handy, thanks for sharing.

[@MyOnlineTrainingHub]

Great to hear!

[@arupbiswas6094]

Hi Mynda, This is Arup from India. Always getting new things in excel from you, thanks.

[@MyOnlineTrainingHub]

Glad to hear that!

[@paulsingleton6071]

Hi Mynda, really useful and clever tutorial which is clearly explained. Thank you. With regard to your source data you could consider copy and "paste as linked picture".

[@MyOnlineTrainingHub]

Thanks, Paul! Yes, absolutely use Linked Pictures if you prefer. I find they sometimes look a bit blurry, so I usually prefer to put my workings on another sheet.

[@SyedMuzammilMahasanShahi]

Beautiful work. Thanks for the share.

[@MyOnlineTrainingHub]

Thank you, Syed!

[@radwanfakeir]

We always learn new techniques .Thank you

[@MyOnlineTrainingHub]

Great to hear, Radwan :-)

[@vikramraghuwanshi9455]

Excelent explanations .

[@MyOnlineTrainingHub]

Glad you liked it, Vikram!

[@IvanCortinas_ES]

Excellent tutorial Mynda! It is a very little used type of graphic, but I think it is very illustrative.

[@MyOnlineTrainingHub]

Glad you think so, Ivan!

[@COURSSTATSCHAMBERY]

Nicely done Clear & clever :-) Thks

[@MyOnlineTrainingHub]

Thanks, Joseph!

[@mohammadqumrulhassan4897]

No doubt it's excellent effort. Sure I need pretty long practice to make such by following you.

[@MyOnlineTrainingHub]

Thank you!

[@bocobox]

great work. looking forward to your next video with percentage.

[@MyOnlineTrainingHub]

Coming soon!

[@brighnquisitive6217]

Well done, adding to my arsenal

[@MyOnlineTrainingHub]

Great to hear :-)

[@chrism9037]

Very cool Mynda!

[@MyOnlineTrainingHub]

Cheers, Chris!

[@kissxk]

very clever as always. the groovy background music was something new ;-)

[@MyOnlineTrainingHub]

:-D keeping it fresh, Calvin!

[@VladimirKozomara]

Great work Mynda

[@MyOnlineTrainingHub]

Thank you!

[@markclifton9524]

Very good - how on earth do you know all these things!!😁

[@MyOnlineTrainingHub]

:-D Thanks, Mark!

[@undhaddipak]

wow Mem Excellent video ,thanks for video

[@MyOnlineTrainingHub]

Thanks, Dipak!

[@peterbartholomew7409]

An easily overlooked strategy would be number formatting. That can change both the colour and the symbol; I let democrats code to 1, republicans to 2 and other seats 0. The prettiest results might be the scatter chart though. I enjoyed your solutions though and the array functions have the advantage of being dynamic.

[@MyOnlineTrainingHub]

Nice tip, Peter! Thanks for sharing.

[@grahamparker7729]

Yum, pies 🥧 I’m hungry

[@MyOnlineTrainingHub]

:-D me too!

[@paru2050]

I like the fast nature of the video expecting the viewer to man-up and be better...

[@MyOnlineTrainingHub]

Great to hear :-)

[@karonroberts5888]

Great stuff, although the chart is dynamic, the same information written in the text box isn’t - is there of making it dynamic, or just relie on the orignal source?

[@MyOnlineTrainingHub]

Thanks, Karon! You can link the text box to a cell that contains a dynamic label, but you can't colour code it like I did with this example.

Is there anything you can't do in Excel? Everytime I watch your videos my doubts grow stronger :-) BTW, thank you for your tip on fixing conditional format rules. Now they work fine and pasting as values have become my personal matra, too!

[@MyOnlineTrainingHub]

So pleased to hear you find my videos helpful, Jacek :-)

[@merk226]

I made one just 2 days back :)

[@MyOnlineTrainingHub]

Next week I'll show you how to build a waffle chart using a stacked bar chart! Hopefully you'll find it useful.

[@assiamaouchie2560]

Hey, could you please make a tutorial about Prezi

[@MyOnlineTrainingHub]

I'm not familiar with Prezi, sorry.

[@2_Bike_is_Life]

It's 3:20 in the morning, and I am watching Excel videos. What is wrong with me. Great visualization idea!

[@MyOnlineTrainingHub]

Glad you enjoyed my video :-)

[@patrickschardt7724]

Nothing. I do that all the time watching videos from Mynda, Leila, Jon, Bill, Mike, Alan, and some others

[@joanhauff6541]

Why does the formula in cell B7 of the SEQUENCE Alternative Sheet =COLUMNS($A1:A$10)+10*(ROWS($A1:$A$10)-1) evaluate to 91 instead of 99?

[@MyOnlineTrainingHub]

Hi Joan, the numbering is from left to right, bottom to top. The top left cell is 91 and the top right cell is 100. It's supposed to be this way.

[@jeremyjohnson9577]

I ate waffles while watching ;)

[@MyOnlineTrainingHub]

Yum!

[@ricos1497]

Could you not just copy the dot symbol into format cells for positive values, and then use the same conditional formatting for both absolute charts? Still very cool, nevertheless.

[@MyOnlineTrainingHub]

Yes, great idea, Rico!