Make Waffle Charts in Excel... the EASY way | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ Check out the blog post★
exceloffthegrid.com/waffle-ch...
★ About this video ★
Waffle charts are like square pie charts. However, rather than slices of a pie, values are represented by the number of colored squares. They are commonly found on dashboards and newspaper articles because they are easy to read at a glance.
In this video, we look at how to make waffle charts in Excel using the easiest method possible.
0:00 Introduction
0:29 Waffle Charts in Excel
5:52 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel
Пікірлер: 19
Excellent instruction. Simple and to the point.
Thank you Mark!
@ExcelOffTheGrid
Жыл бұрын
My pleasure!
Thanks, Mark!
@ExcelOffTheGrid
Ай бұрын
My pleasure!
Great tutorial.
@ExcelOffTheGrid
Жыл бұрын
Thank you! Cheers! 😁
Brilliant👌
@ExcelOffTheGrid
Жыл бұрын
Thanks James. I'm glad you like it.
This is amazing! Thank you for sharing this technique!
@ExcelOffTheGrid
Жыл бұрын
Glad you like it!
Tank you! Best ever. Always wanted to create these for my dashboards.
@ExcelOffTheGrid
Жыл бұрын
Thanks Chris, that is very kind of you. 😁
Outstanding Mark! Thank you for this tutorial!!
@ExcelOffTheGrid
Жыл бұрын
My pleasure! 😀
A little tip: Instead of changing the font color to the background color: Set the number format to Custom and type: ;;; (three semicolons) That's it!
@ExcelOffTheGrid
Жыл бұрын
Yes, that’s a reasonable alternative. Out of curiosity, what do you think the benefit of that is over using conditional formatting?
I wanted to make a planning/calendar from a list of dates and events and I didn't know how to do it. You've given me an idea of how to get started. Thanks ! ⬆⬆
@ExcelOffTheGrid
Жыл бұрын
Yes, you can definitely use a similar approach for that. Good idea.