How to Create a Waffle Chart in Excel (using charts)

Welcome back to Plot Twist, the series where we turn everyday data into stunning visualizations! In this episode, you'll learn how to create a waffle chart! A waffle chart is similar to a pie or donut chart, but instead of a circle, it's a square grid where each cell corresponds to 1%. Believe it or not, we can create a dynamic waffle chart using a stacked column chart in Excel.

Here's what we'll cover:
• Using dynamic array functions like TEXTSPLIT, WRAPCOLS, etc., to set up the data
• Adding our data to the chart
• Formatting/cleaning the chart
• Creating the waffle grid
• And more!
Get ready to learn everything you need to know about creating this unique waffle chart!

📖RESOURCES
- Download the calendar template and follow along: https://excel-dictionary.com/pages/youtube-workbook

🤓SHOP EXCEL DICTIONARY
NEW AI FOR EXCEL COURSE OUT NOW 👉🏼 https://excel-dictionary.com/collections/courses
- COURSES: https://excel-dictionary.com/collections/courses
-GUIDES: https://excel-dictionary.com/collections/e-books
-MERCH: https://excel-dictionary.com/collections/merch
-TEMPLATES: https://excel-dictionary.com/collections/templates

📩NEWSLETTER
-Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: https://www.excel-dictionary.com/subscribe

📺SUBSCRIBE
-Subscribe to never miss a video: https://www.youtube.com/c/ExcelDictionary

🕰️ TIMESTAMPS
'0:00 - Introduction
'0:31 – Waffle chart overview
'0:53 – How to set up the data
'2:46 – How to create the chart
'3:41 – How to set axis values
'3:58 – How to format the chart
'5:58 – Wrap up

#excel #exceltips #tutorial #ExcelCharts #waffleChart #DataVisualization #PLOTTWIST #ExcelTutorials #CreativeCharts

Видео How to Create a Waffle Chart in Excel (using charts) канала Excel Dictionary