Design Quantitative Charts Like A Top-tier Consultant And Upgrade Every Client Presentation
The Busy Consultant’s Guide to Quantitative Charts is a practical, hands-on reference for consultants and analysts who need to communicate insights clearly, quickly, and credibly through data. It explains why charts matter in consulting problem-solving and how to choose the right visual for the question at hand—rather than defaulting to familiar but often misleading formats. Grounded in the McKinsey-style tradition of clear titles, focused messages, and disciplined design, the guide shows how to turn raw numbers into charts that support decision-making.
Designed for speed and real-world use, the book walks readers through the full range of quantitative chart types—bars, columns, lines, waterfalls, scatters, distributions, and structural charts—explaining when to use each, how to design it well, and what pitfalls to avoid. It emphasizes practical heuristics, reusable patterns, and fast fixes that fit the “busy consultant” constraint. The result is a concise toolkit that helps practitioners move from business question to client-ready chart with confidence, clarity, and impact.
Table of Contents
Chapter 1. Introduction: How to Use This Guide
1.1 Why charts matter in consulting problem-solving
1.2 When to use a chart (and when a table is better)
1.3 The “busy consultant” constraint: speed, clarity, reusability
1.4 Anatomy of a McKinsey-style chart: title, frame, data, message
Chapter 2. What Are Charts For? Core Purposes and Use Cases
2.1 Showing change over time (trends, cycles, seasonality)
2.2 Comparing quantities across categories (cross-section comparisons)
2.3 Showing part-to-whole composition (percentage breakdowns)
2.4 Showing distributions and spread (ranges, skew, outliers)
2.5 Showing relationships and segmentation (correlations, clusters, portfolios)
2.6 Showing contributions and bridges (from A to B via drivers)
Chapter 3. Design Principles for McKinsey Quantitative Charts
3.1 Zelazny’s legacy: simplicity, clarity, and focus on the main message
3.2 Choosing the right chart: a practical decision tree
3.3 Scales, axes, and baselines: avoiding distortion
3.4 Color, labels, and call-outs in the McKinsey style
3.5 Building charts efficiently from Excel to PowerPoint
Chapter 4. Bar Charts (Horizontal)
4.1 When to use bar charts vs other chart types
4.2 Simple bar chart
4.3 Clustered bar chart (comparing multiple series within each category)
4.4 Stacked bar chart (absolute contributions)
4.5 100% stacked bar chart (relative mix at 100%)
4.6 Waterfall bar chart (bridging from one value to another)
4.7 “Bar chart with words” (bars as visual emphasis for qualitative scales)
4.8 Common pitfalls and good practices for bar charts
Chapter 5. Column Charts (Vertical)
5.1 When to use column charts vs bar charts
5.2 Simple column chart
5.3 Clustered column chart / grouped column chart
5.4 Multiple column chart (several series across many periods)
5.5 Stacked column chart
5.6 100% stacked column chart
5.7 Waterfall column chart (P&L bridges, value bridges)
5.8 Vertical dot chart (dot and lollipop variants)
5.9 Population pyramid and pyramid column charts
5.10 Common pitfalls and good practices for column charts
Chapter 6. Line Charts
6.1 When to use line charts (and when not to)
6.2 Simple “data over time” line chart
6.3 Multiple line chart (comparing series over time)
6.4 Growth curve and evolution line charts
6.5 Peak and arrow line charts (highlighting key points and inflections)
6.6 Radial line chart (when circular timelines are appropriate)
6.7 Common pitfalls and good practices for line charts
Chapter 7. Pie and Doughnut-Type Charts
7.1 When (and when not) to use pie charts
7.2 Simple pie chart (one point in time, few categories)
7.3 Doughnut chart and multiple doughnut chart (comparing mixes)
7.4 Harvey balls (qualitative part-to-whole indicators)
7.5 Wheel charts (circular category layouts)
7.6 Alternatives to pies: bars, stacked bars, Mekko, and others
Chapter 8. Area Charts
8.1 When to use area charts vs stacked bars or lines
8.2 Simple area chart (emphasizing total over time)
8.3 Stacked and proportional area charts (mix over time)
8.4 Rectangle / proportional area charts (space-filling composition)
8.5 Common pitfalls and good practices for area charts
Chapter 9. Scatter, Bubble, and Dot-Matrix Charts
9.1 When to use scatter charts (relationships, clusters, outliers)
9.2 Simple scatter chart (two-variable relationships)
9.3 Four-quadrant scatter chart (strategy maps, positioning)
9.4 Segmented scatter chart (color-coding segments)
9.5 XY bubble chart (adding a third variable with bubble size)
9.6 Dot matrix chart (grids of dots to compare magnitudes)
9.7 Radar chart (multi-attribute profiles)
9.8 Common pitfalls and good practices for scatter and bubble charts
Chapter 10. Distribution and Density Charts
10.1 When the story is about distribution, not just averages
10.2 Histograms (frequency distributions)
10.3 Density charts (smoothed distributions)
10.4 Box-and-whisker and range-style alternatives (where appropriate)
10.5 Population pyramids as distribution charts
10.6 Common pitfalls and good practices for distribution charts
Chapter 11. Structural, Portfolio, and Composition Charts
11.1 Mekko (Marimekko) charts: size and mix in one view
11.2 Percentage breakdown and “tile” charts
11.3 Heat maps (color-coded matrices)
11.4 Combination charts (e.g., column + line)
11.5 Using shape and area to show structure without confusing the reader
Chapter 12. From Question to Chart: A Practical Selection Guide
12.1 Mapping business questions to chart families
12.2 Fast recipes for the 10 most common consulting chart stories
12.3 Sanity-check checklist before sending a chart to a client
12.4 Frequent errors (and how to fix them in under five minutes)
12.5 Building your own “personal chart library” in PowerPoint
