🧇 Interactive Waffle Charts -- Excel Charting Skills
HTML-код
- Опубликовано: 7 авг 2024
- In this Excel tutorial, we are going to learn how to create interactive waffle charts to compare the amount of tickets sold for a concert by month and ticket type.
We will use a combination of Excel design elements, formulas, conditional formatting and data validation to achieve this.
DOWNLOAD THE WORKBOOK ⬇️
docs.google.com/spreadsheets/...
*******************************
Chapters:
00:00 - Introduction
00:25 - What are Waffle Charts?
02:18 - Set up the Dashboard
05:46 - Create the Waffle Grid
10:27 - Set up the Calculations Worksheet
15:59 - Create the Data Validation Dropdown List
16:37 - Convert Values to Percentages
19:40 - Link to the Data Validation Dropdown List
20:16 - Create the Filter
22:24 - Create Running Totals
23:22 - Add Conditional Formatting Rules
29:56 - Create Dynamic Chart Labels
********************************
🔗LINKS to related videos
📊Create a DYNAMIC Chart Title
• 📊Create a Dynamic Bar ...
🎯Add a DYNAMIC Target Line to an Excel Chart
• ➕Add a Dynamic Target ...
🥩Highlight the MIN and MAX Values in a Chart
• 📈Highlight the MIN and...
************************************************
🤝Let's CONNECT on social:
➡️TikTok: / cellmates_
➡️Instagram: / cellmatestr. .
➡️LinkedIn: / deborahas. .
➡️Twitter: / cellmates_
➡️Facebook: / cellmates
Excellent video Deb! Very through description of all the steps.
Thank you! 🎉
I like this Channel ♥ more than great really Amazing
Brilliant Tutorial! Thanks! 🌼
You’re welcome!
Great video and love the detailed explanations!
The only thing missing from this video is a side of syrup for the waffles. ha ha.
Haha I know right? I’m feeling hungry now 😂
In the US state of Pennsylvania, Shrove Tuesday means people eat fastnachts which are like donuts without holes.
Thanks a lot. But, maybe, pivot tables could be useful? Just a question.🙂