Advanced Excel Charts for Dashboards - Free Masterclass for Data Analysts @chandoo_
Advanced Excel Charts for Dashboards - Free Masterclass for Data Analysts  @chandoo_
Uploaded June 2026 | Updated November 2026, 3 hours ago
Learn how to create professional, advanced Excel charts in this masterclass by Chandoo.


Download Blank data file - chandoo.org/wp/wp-content/uploads/2026/06/charting_blank.xlsx

Video topics πŸ•

00:00 – Introduction and Welcome
01:55 – Downloading the Sample Files
03:32 – Overview of the 3 Dashboard Charts to be Built
07:32 – General Philosophy for Business Reporting & Visualization
14:18 – 1️⃣Chart 1: Heat Map Matrix (Average Boxes per Shipment)
15:06 – How to use Emojis in Excel
16:45 – Working with In-Cell Images (Flags)
21:50 – Creating the Pivot Table for the Matrix
27:40 – Applying Conditional Formatting (Color Scales)
29:20 – Highlighting the Maximum Value Dynamically
31:25 – Adding & Formatting the Contextual Bar/Column Charts

44:00 – 2️⃣Chart 2: Annotated Donut Chart (Sales by Country)
45:15 – Setting up Month-over-Month (MoM) Comparisons
47:40 – Building the Donut Chart from Pivot Data
51:15 – Calculating Change Percentages and Arrow Indications
55:00 – Custom Number Formatting for Labels
58:45 – Adding Dynamic Totals in the Center of the Donut
1:03:30 – 3️⃣Chart 3: Dynamic Top N Salespeople Chart
1:04:40 – Setting up the User Input (Top 10, Top 5, etc.)
1:06:55 – Using the Trim Range (Dot) Operator
1:11:15 – Writing the "Top N" Logical Formulas
1:14:10 – Designing Overlapping Bar Charts
1:17:15 – Creating Custom Multi-Metric Labels with Emojis
1:24:20 – Adding a "Proportion of Total" Pie Chart

1:28:40 – Final Thoughts on Stakeholder Engagement
1:30:45 – Q&A: Handling Large Data Variance, Career Advice, and AI in Data Analysis

~

#Excel #dashboards #charts
Advanced Excel Charts for Dashboards - Free Masterclass for Data AnalystsGet the TOP Salaries with this Excel FormulaGet Ready for the MOST IN DEMAND Data Analyst Skills in 2025Power BI is NOT Enough! Here’s What You Must Learn in 2025 πŸš€Date Range Overlap in Excel - Adv. Formula Trick πŸ’‘Excel Bar / Column Graph Tutorial + 5 Advanced Tips πŸ“ŠHow to get Excel & MS Office for FREE (Power BI + SQL too)Effortlessly Split Text in Excel: Master Formulas Today!I dont use PIVOT tables anymore... I use this other thing instead!How to Find the Next Monday in Excel Fast!Make an AMAZING Dashboard with Power BI - End to End Tutorial +FilesHow to Present Data for Executive Audience - FREE Masterclass with Sample Files
Chandoo |

Advanced Excel Charts for Dashboards - Free Masterclass for Data Analysts

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER