Every chart on this page uses the same delivery sequence. Memorize these five steps and you won't worry about what to say next. The formula applies to most visuals an analyst would create and present.
Explain the horizontal axis.
Explain the vertical axis.
Walk through the legend or groups.
Put one number into a sentence.
Share the takeaway.
Before the case · Why the formula matters
Bad example
You can't present every chart. If a chart is too busy the creator didn't spend enough time on it.
Target Canada — Everything We Could Possibly Measure
Too many metrics · too many scales · no single number · no clear takeaway
This chart resembles the same Target Canada story, but it is not ready to present. Store count, in-stock rate, gross margin, inventory, segment loss, and distribution throughput are all crammed onto two axes with competing annotations, and there is no single number the audience can hold onto.
Do not judge your presentation ability by a slide like this. No one can present it clearly because the slide does not give the presenter a path. We are going to tell the same story in a simpler manner: one chart, one number, one takeaway at a time.
Practice Case · Target Canada 2013–2015
The story we will use for practice
To practice the formula, we need a story with real charts and a clear narrative. We will use Target Canada from 2013 to 2015.
The idea was reasonable. Canadians already knew Target from shopping across the border, the old Zellers chain was fading, and instead of building stores one at a time, Target bought a ready-made national footprint — the leases to 220 Zellers locations for about C$1.8 billion. Open the doors, hang the red bullseye, and a brand people already wanted would be everywhere at once.
The strategy was not the problem. The speed was. Target opened 133 stores in roughly eleven months, all running on a brand-new inventory and ordering system nobody had tested at this scale. The data feeding that system was wrong — wrong sizes, wrong barcodes, wrong prices — so the warehouses filled up with the wrong product while the store shelves sat empty. A customer who drove to a store people had waited years for found bare racks and prices higher than the Target they knew. You do not get a second first impression at 133 stores at once.
Target pulled out of Canada in under two years. The four charts below give us enough story to practice with. The chart type changes. The delivery method does not.
Chart 1 of 4 · Waterfall chart
Slide takeaway
Target turned 220 Zellers leases into a 133-store national chain in under a year. On paper, it looked like a bold, ready-made expansion.
Target Canada — How the Footprint Was Built
Number of store sites · Zellers leases to stores opened · 2011–2013
Source: Target and Hudson's Bay Company filings and announcements. Navy = leases acquired; orange = stores actually opened. The middle bar is the leases Target did not open as its own stores.
Presentation script using the five-step formula
Explain horizontal axis "On the horizontal axis, we have steps, left to right: the leases Target started with, then the ones it did not open, then the stores it actually opened."
Explain vertical axis "On the vertical axis, we have the number of store sites — a simple count."
Walk through legend/groups "This is a waterfall, so read it like stairs. The first and last bars sit on the floor — those are totals. The middle bar floats and hangs down, showing the sites that dropped out between the start and the end. The navy bar on the left is the leases acquired; the orange bar on the right is the stores that opened."
Put one number in sentence "Target opened 133 stores — the orange bar — out of the 220 leases it bought, with 87 sites not opened as Target stores."
Share takeaway "The takeaway is that this looked like a bold, ready-made expansion. A national chain stood up in under a year, and on paper that is the kind of move that gets applause."
Notice the order
The presenter does not start with the whole business story. They follow the same five-part order every time: explain the horizontal axis, explain the vertical axis, walk through the legend or groups, put one number into a sentence, share the takeaway. And if the number matters, put it on the slide so the audience does not have to do the math.
Chart 2 of 4 · Histogram
Slide takeaway
The in-stock target was 95%. Across the 133 stores, almost none came close. The empty shelves were everywhere.
Target Canada — In-Stock Rate Across the 133 Stores
Number of stores by in-stock % range · target was 95%
Illustrative distribution — per-store in-stock values are modeled to the reported 95% in-stock target and the chain's widely reported on-shelf availability in the low-70s; not company-disclosed. The 95% target and the roughly-70% actual are the reported anchors.
Presentation script using the five-step formula
Explain horizontal axis "On the horizontal axis, we have ranges of in-stock rate, not time. In-stock rate is the share of products that are actually on the shelf when a customer reaches for them — if nineteen of twenty items a shopper wants are there, that is a 95% in-stock rate. Each range is a band, like seventy to eighty percent."
Explain vertical axis "On the vertical axis, we have the number of stores that fall in each range — how many of the 133 stores landed in each band."
Walk through legend/groups "Read the shape, not one bar. The bars touch because the ranges run end to end. The blue dashed line on the right marks the 95% target. Most stores pile up far to the left of it."
Put one number in sentence "48 stores — the tallest bar — landed in the seventy-to-eighty percent range, nowhere near the 95% target."
Share takeaway "The takeaway is that the empty shelves were not a few bad stores. The whole chain missed the target at once, so this was a system failure, not a local one."
Chart 3 of 4 · Pareto chart
Slide takeaway
A handful of causes broke the chain, and the SAP data errors sat underneath most of them.
Target Canada — What Broke the Chain
Share of the breakage by cause, sorted · with running total
Illustrative weights — the ranking of causes follows reported accounts of the failure, with the SAP data-integrity errors as the root cause, then forecasting, then distribution, then over-ordering, then pricing. The percentage shares are modeled to that order, not company-disclosed.
Presentation script using the five-step formula
Explain horizontal axis "On the horizontal axis, we have the causes that broke the supply chain, sorted from biggest to smallest, left to right."
Explain vertical axis "There are two vertical axes, and a Pareto chart is the one place that is allowed. The left axis is each cause's share of the breakage, in percent — that is the bars. The right axis is the running total, also in percent — that is the line, adding the causes up as you move right."
Walk through legend/groups "The first bar is the SAP system — the new software that held all the product data, like sizes, barcodes, and prices. When that data is wrong, every order downstream is wrong. The orange bars are the few causes that do most of the damage; the grey bars are the smaller ones. The line climbs to show how fast they add up. The gold line marks 80%."
Put one number in sentence "The first two causes — the SAP errors and the forecasting — already reach 62% of the breakage, the labeled point on the line."
Share takeaway "The takeaway is that this was not a hundred small problems. A couple of root causes, led by the data in the new system, drove most of it — which is exactly what you fix first."
Chart 4 of 4 · Dumbbell chart
Slide takeaway
Over the same window, Walmart and Costco Canada grew. Target went to zero. The market was fine; the execution was not.
Canadian Store Count — Target vs. the Incumbents
Number of stores or warehouses · 2013 vs. 2015
2013 (start)2015 (Target exited)
Store and warehouse counts are approximate, for the same 2013–2015 window. Walmart Canada and Costco Canada grew; Target Canada exited. Using the same unit for all three keeps the comparison honest.
Presentation script using the five-step formula
Explain horizontal axis "On the horizontal axis, we have the number of stores — or warehouses, for Costco — running left to right."
Explain vertical axis "Each row down the side is one retailer: Walmart Canada, Costco Canada, and Target Canada."
Walk through legend/groups "Every row has two dots joined by a line. The navy dot is where the retailer started in 2013; the other dot is where it ended in 2015. The line between them is the change. For Target, the end dot is orange and sits at zero."
Put one number in sentence "Target went from 133 stores to 0, while Walmart Canada moved from 379 stores to 400."
Share takeaway "The takeaway is that the Canadian market was not the problem. The two incumbents grew over the exact same stretch. Only Target, with the broken execution, went to zero."
What you just practiced
The chart type changed. The approach to presenting them didn't.
The lesson: do not make the audience decode the chart alone. A waterfall, a histogram, a Pareto, and a dumbbell all read the same way: explain the horizontal axis, explain the vertical axis, walk through the legend or groups, put one number into a sentence, share the takeaway. The chart type tells you what to draw. The formula tells you what to say.