Chandoo

Learn how to create professional, advanced Excel charts in this masterclass by Chandoo.

Download Blank data file - https://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