Six lessons on showing numbers so people understand them: choosing the right chart, building clean column, line and combo charts, sparklines, dynamic charts and a one-page Excel dashboard. One practice workbook is used throughout.

1. 1Charts Lesson 1: Choosing the Right ChartMatch the chart to the question: comparison, trend, composition, relationship and distribution, with the charts that work and the ones that mislead.
2. 2Charts Lesson 2: Column, Bar and Line Charts Done ProperlyBuild clean column, bar and line charts in Excel: select data, insert, sort, gap width, data labels, axis formatting, removing clutter and…
3. 3Charts Lesson 3: Combo Charts — Actual vs TargetShow actual against target in one chart: column + line combo, secondary axis for percentages, target as a marker line, and highlighting…
4. 4Charts Lesson 4: Sparklines and In-Cell ChartsPut tiny charts inside cells: line, column and win/loss sparklines, high/low markers, data bars and REPT bars — perfect for tables and…
5. 5Charts Lesson 5: Dynamic Charts With Drop-DownsMake one chart that changes with a drop-down: data validation list, INDEX/XLOOKUP helper range, chart on the helper, and dynamic titles linked…
6. 6Charts Lesson 6: Build a One-Page Excel DashboardPut it together: KPI cards, a trend chart, region and product breakdowns, a selector, consistent layout and colours, and print-ready setup for…

Related: dynamic chart with a drop-down, in-cell bar charts, camera tool.