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
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










