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.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

⏲ 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

[martinpaulbannister]

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 😎

[paulsingleton]

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".

[nsanch]

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

[Luciano_mp]

Very nice, beautiful. Thank you Mynda!👏

[radwanfakeir]

We always learn new techniques .Thank you

[santchev]

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

[mohammadqumrulhassan]

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

[arupbiswas]

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

[IvanCortinas_ES]

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

[KLINT_Com-Net]

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

[darrylmorgan]

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

[bocobox]

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

[COURSSTATSCHAMBERY]

Nicely done Clear & clever :-) Thks

[jamessawyer]

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

[peterbartholomew]

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.

[kissxk]

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

[markclifton]

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

[undhaddipak]

wow Mem Excellent video, thanks for video

[karonroberts]

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?

[assiamaouchie]

Hey, could you please make a tutorial about Prezi