Description
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