Same data, different truths: perspective and framing in charts

TL;DR

Difficulty: Intermediate

The same numbers can honestly support opposite conclusions, because every chart needs a framing: a unit, a baseline and something to divide by.

  • Show absolute change next to relative change, or a small base looks huge.
  • Rates change in percentage points; pick one unit for every rate.
  • Totals grow with the crowd, so add a per customer view.
  • Index to a meaningful base, and adjust money across years for inflation.
  • Show the parts next to the whole (Simpson's paradox) and ask who is missing (survivorship).
  • Choose the framing on purpose, use it for good and bad news alike, and write it under the chart.

The marketing lead says the quarter was great. The finance lead says it was worrying. Both used the same spreadsheet, and both are right. This chapter takes one invented quarter at an outdoor gear brand in Leeds and shows the eight framing choices that turn the same data into opposite stories, then builds the one board slide that shows both.

Two people, one spreadsheet, opposite conclusions

It happens in almost every quarterly meeting. The marketing lead puts up a slide that says the business is flying. The finance lead puts up a slide that says it is slipping. Both took their numbers from the same spreadsheet, and neither made anything up. So who is right?

Usually both are, and that is the uncomfortable part. A number on its own says very little. It only means something once you decide what to compare it with, which unit to show it in, and whose point of view to take. Those decisions are called the framing. The previous chapter, how charts lie and how to catch them, was about charts that distort the data. This one is about charts that show the data perfectly and still steer you, because the framing was chosen for you.

Framing is not a small effect. In a famous experiment, Amos Tversky and Daniel Kahneman gave people the same choice twice, once described in terms of lives saved and once in terms of lives lost. The outcomes were identical. The preferences flipped.1 If the wording of a question can do that, the choice of axis, unit and baseline on a chart can do it too.

This article walks through the framing choices that matter most in a business: absolute against relative change, percentage change against percentage points, totals against per customer figures, indexing, money with and without inflation, Simpson's paradox, survivorship and the choice of baseline. Each one gets its own example. At the end, the whole thing comes together in one honest board slide.

Example: the quarter that started an argument

Pennine Outfitters is an outdoor gear brand in Leeds. It sells through a web shop, a small social media shop, and one physical shop in the city. Its analyst, Sam, prepares the board report. The quarter in question is July to September 2026, compared with the same quarter a year earlier. All numbers in this article are invented for the example.

ChannelQ3 2025Q3 2026
Web shop£176,000£224,000
Social shop£4,000£10,000
Leeds shop£220,000£196,000
Total revenue£400,000£430,000
Customers5,0006,200
Web conversion rate2.0%2.4%
Return rate8%10%

Hannah, the marketing lead, and Owen, the finance lead, each have ten minutes with Helen, the owner. Every claim they make in the sections below is true. Watch how far apart they end up.

Relative change makes small things look big

A change can be told in two ways. The absolute change is the plain difference: the thing went up by £6,000. The relative change is that difference measured against where you started: the thing went up by 150%. Both are correct. They answer different questions. The absolute change tells you how much it matters to the business. The relative change tells you how fast it moved.

Δ=vnew−vold,r=vnew−voldvold×100\Delta = v_{\text{new}} - v_{\text{old}}, \qquad r = \frac{v_{\text{new}} - v_{\text{old}}}{v_{\text{old}}} \times 100

Here Δ\Delta is the absolute change, in the same unit as the data (pounds, customers, orders). rr is the relative change, as a percentage. vnewv_{\text{new}} is the value now and voldv_{\text{old}} is the value you compare against. Because voldv_{\text{old}} sits underneath the fraction, a small starting value makes any change look enormous. The full explanation is in Foundations: percentages.

That denominator is where the trouble lives. Gerd Gigerenzer and colleagues describe what happened in the UK in 1995, when a warning said that newer contraceptive pills doubled the risk of a dangerous blood clot, an increase of 100%. In the studies behind the warning, about one in 7,000 women on the older pills had a clot, against about two in 7,000 on the newer ones. The relative increase really was 100%. The absolute increase was one woman in 7,000. Many women stopped taking the pill, and the authors cite an estimated 13,000 additional abortions in England and Wales the following year.2 The same paper notes that a screening programme described as reducing deaths by 25% meant, in absolute terms, one fewer death in every 1,000 women screened.2 Relative numbers make better headlines. Absolute numbers make better decisions.

Example: Hannah's social shop and Owen's Leeds shop

Hannah opens with the social shop. Its revenue went from £4,000 to £10,000. Using the formula: r=10,000−4,0004,000×100=6,0004,000×100=150%r = \frac{10{,}000 - 4{,}000}{4{,}000} \times 100 = \frac{6{,}000}{4{,}000} \times 100 = 150\%. Her slide says "Social sales up 150%".

Owen opens with the Leeds shop. Its revenue went from £220,000 to £196,000. The relative change is r=196,000−220,000220,000×100=24,000220,000×100≈10.9%r = \frac{196{,}000 - 220{,}000}{220{,}000} \times 100 = \frac{24{,}000}{220{,}000} \times 100 \approx 10.9\%, downwards. On a chart of percentages, a fall of 10.9% next to a rise of 150% looks like a rounding error.

Now the absolute changes. The social shop gained Δ=10,000−4,000=£6,000\Delta = 10{,}000 - 4{,}000 = \text{£}6{,}000. The Leeds shop lost Δ=220,000−196,000=£24,000\Delta = 220{,}000 - 196{,}000 = \text{£}24{,}000. The web shop gained 224,000−176,000=£48,000224{,}000 - 176{,}000 = £48{,}000, which is a relative change of about 27.3%. In pounds, the social shop is the smallest story of the three, and the Leeds shop lost four times what the social shop gained.

Bar chart of the change in revenue from Q3 2025 to Q3 2026 for Pennine Outfitters, invented example data, shown as percentage changes. The social shop rose 150%, the web shop rose 27.3% and the Leeds shop fell 10.9%. Shown alone, the percentages make the social shop look like the main story and the Leeds shop fall look minor. Tap or click to open full screen and move around
Bar chart of the same change in revenue from Q3 2025 to Q3 2026 for Pennine Outfitters, invented example data, shown in pounds. The web shop gained 48,000 pounds, the social shop gained 6,000 pounds and the Leeds shop lost 24,000 pounds. In pounds the web shop is the main story and the Leeds shop loss is four times the social shop gain. Tap or click to open full screen and move around

The honest version is not the second chart on its own. It is both, or a single chart in pounds with the percentage written on each bar. Helen needs the pounds to judge the size and the percentage to judge the speed.

Percentage change and percentage points are different units

When the number you are changing is itself a percentage, such as a conversion rate or a return rate, there are two ways to describe the change, and they can differ by a factor of ten or more. A percentage point is the plain difference between two percentages. A percentage change is that difference measured against the starting percentage.

Δpp=pnew−pold\Delta_{\text{pp}} = p_{\text{new}} - p_{\text{old}}

Δpp\Delta_{\text{pp}} is the change in percentage points. pnewp_{\text{new}} and poldp_{\text{old}} are the two rates, both already written as percentages. The relative change of a rate uses the formula from the previous section with pp in place of vv. See Foundations: percentages for both, and Foundations: ratios and rates for what a conversion rate is.

Neither unit is wrong. The problem starts when someone picks the unit that sounds best, rate by rate.

Example: the same two rates, described by both leads

The web conversion rate went from 2.0% to 2.4%. In points: Δpp=2.4−2.0=0.4\Delta_{\text{pp}} = 2.4 - 2.0 = 0.4 percentage points. As a percentage change: r=2.4−2.02.0×100=0.42.0×100=20%r = \frac{2.4 - 2.0}{2.0} \times 100 = \frac{0.4}{2.0} \times 100 = 20\%.

The return rate went from 8% to 10%. In points: Δpp=10−8=2\Delta_{\text{pp}} = 10 - 8 = 2 percentage points. As a percentage change: r=10−88×100=28×100=25%r = \frac{10 - 8}{8} \times 100 = \frac{2}{8} \times 100 = 25\%.

Now watch what each lead says.

ClaimWho says itUnit chosenWhat it hides
"Conversion up 20%"Hannahpercentage changeit is 0.4 points
"Returns up only 2 points"Hannahpointsit is a rise of a quarter
"Conversion up a mere 0.4 points"Owenpointsit is a fifth more orders per visit
"Returns up 25%"Owenpercentage changeit is 2 in every 100 orders

Each line is true. Hannah uses percentage change for the good news and points for the bad news. Owen does the opposite. The fix is boring and effective: pick one unit for all rates in a report, and say which one. I would choose percentage points for rates, with the percentage change in brackets when it helps: "conversion rose 0.4 points (a fifth more orders per visit), returns rose 2 points (a quarter more returns per order)".

Totals hide how many people are behind them

A total grows when the business grows, even if every single customer is spending less. A figure per customer (or per order, per visit, per head of population) takes the size of the crowd out. Neither is the truth on its own. The total tells you whether the business got bigger. The figure per customer tells you whether it got better at what it does with each person.

vˉ=RN\bar{v} = \frac{R}{N}

vˉ\bar{v} is the value per customer. RR is the total, for example revenue in the period. NN is the number of customers in the same period. It is a plain mean, so everything in Foundations: the mean applies, including the warning that one very large customer can pull it up.

The same idea is behind every official figure quoted "per head". A country's output, a region's crime figures or a city's spending only compare fairly once you divide by the number of people, because a bigger place will almost always have a bigger total.

Example: more customers, less from each

Hannah's slide says "24% more customers". She is right: r=6,200−5,0005,000×100=1,2005,000×100=24%r = \frac{6{,}200 - 5{,}000}{5{,}000} \times 100 = \frac{1{,}200}{5{,}000} \times 100 = 24\%.

Owen divides revenue by customers. In Q3 2025, vˉ=400,0005,000=£80\bar{v} = \frac{400{,}000}{5{,}000} = \text{£}80. In Q3 2026, vˉ=430,0006,200≈£69.35\bar{v} = \frac{430{,}000}{6{,}200} \approx \text{£}69.35. The change is r=69.35−8080×100≈13.3%r = \frac{69.35 - 80}{80} \times 100 \approx 13.3\%, downwards. His slide says "Each customer spent 13% less".

Both slides are true, and they are true together: Pennine Outfitters found many more customers, and on average each one bought less. That combination is the real finding, and it raises the question Helen actually needs answered: are the new customers smaller, or are the old ones shrinking? Neither total answers it. A split by new and returning customers would.

Indexing puts different scales on one chart

Sometimes you want to compare how several things grew, but they live on wildly different scales. Web visits are in the hundreds of thousands, orders in the thousands, revenue in pounds. Draw them on one axis and the biggest series flattens the others into a line along the bottom. Draw them on two axes and you invite the dual axis tricks from the previous chapter.

Indexing solves this. You pick one period as the base, set every series to 100 at that point, and show everything else relative to it.

It=vtvbase×100I_t = \frac{v_t}{v_{\text{base}}} \times 100

ItI_t is the index value in period tt. vtv_t is the actual value in period tt, and vbasev_{\text{base}} is the value in the base period. An index of 120 means 20% above the base, and 90 means 10% below. Official inflation figures are published exactly this way. More in Foundations: indexing and base rates.

Indexing has one framing choice built in: the base. Pick a weak period as the base and everything after it looks like a recovery. Pick a strong one and everything looks like a decline.

Example: visits, orders and revenue over five quarters

Sam has five quarters of data for Pennine Outfitters (invented):

QuarterWeb visitsOrdersRevenue
Q3 2025300,0005,600£400,000
Q4 2025360,0007,000£520,000
Q1 2026270,0004,800£350,000
Q2 2026330,0006,000£410,000
Q3 2026380,0006,900£430,000

On one axis, visits run from 270,000 to 380,000 and orders from 4,800 to 7,000. The orders line hugs the bottom of the chart and looks flat.

Line chart of Pennine Outfitters web visits and orders over five quarters from Q3 2025 to Q3 2026, invented example data, drawn on one axis in raw counts. Visits range from 270,000 to 380,000 while orders range from 4,800 to 7,000, so the orders line sits flat along the bottom and its movement is invisible. Tap or click to open full screen and move around

Sam indexes each series to Q3 2025. For visits in Q3 2026: I=380,000300,000×100≈126.7I = \frac{380{,}000}{300{,}000} \times 100 \approx 126.7. For orders: I=6,9005,600×100≈123.2I = \frac{6{,}900}{5{,}600} \times 100 \approx 123.2. For revenue: I=430,000400,000×100=107.5I = \frac{430{,}000}{400{,}000} \times 100 = 107.5. The other quarters work the same way.

Line chart of Pennine Outfitters web visits, orders and revenue over five quarters, invented example data, each indexed so that Q3 2025 equals 100. By Q3 2026 visits reach 126.7, orders 123.2 and revenue only 107.5. The three lines move together through the seasons, but revenue grows far less than visits and orders, which shows that the value of each order has fallen. Tap or click to open full screen and move around

Now the story is visible. Visits and orders grew by about a quarter, revenue by 7.5%. The gap between the orders line and the revenue line is the fall in revenue per order that Owen found.

Then the base trap. Suppose Hannah indexes to Q1 2026, the quiet winter quarter, instead. Revenue in Q3 2026 becomes I=430,000350,000×100≈122.9I = \frac{430{,}000}{350{,}000} \times 100 \approx 122.9, and her slide can say "revenue up 23% since the start of the year". True, and almost entirely the normal summer season. The honest choice is a base that means something for the question: the same quarter last year for a seasonal business, or the average of a full year.

Money now and money then are not the same money

A pound in 2025 buys less than a pound in 2021. Revenue in pounds as they were at the time is called nominal. Revenue converted into the pounds of one chosen year, so that prices are held still, is called real. A nominal chart of several years of revenue mixes two things: how much more the business sold, and how much prices went up. Only the first one is growth.

To convert, you use a price index such as the Consumer Prices Index (CPI), which the Office for National Statistics (ONS) publishes every month.3

Rtreal=Rt×PbasePtR^{\text{real}}_t = R_t \times \frac{P_{\text{base}}}{P_t}

RtrealR^{\text{real}}_t is revenue in year tt, expressed in the money of the base year. RtR_t is the nominal revenue in year tt. PtP_t is the price index in year tt and PbaseP_{\text{base}} is the price index in the base year. If prices rose, PtP_t is bigger than PbaseP_{\text{base}}, so the fraction is below 1 and real revenue is smaller than nominal. The index logic is in Foundations: indexing and base rates.

For a growth rate over a period, there is a shortcut:

greal=1+g1+π−1g_{\text{real}} = \frac{1 + g}{1 + \pi} - 1

grealg_{\text{real}} is the real growth rate, gg is the nominal growth rate and π\pi is the inflation rate over the same period, all as decimals (so 20% is 0.20). Subtracting π\pi from gg is a rough approximation that works only when both are small. See Foundations: growth rates and compounding.

Example: five years of Pennine Outfitters in real pounds

Pennine Outfitters' annual revenue (invented) went from £1.40 million in 2021 to £1.68 million in 2025. The nominal growth is g=1.68−1.401.40=0.281.40=0.20g = \frac{1.68 - 1.40}{1.40} = \frac{0.28}{1.40} = 0.20, so 20%.

The ONS CPI index (2015 = 100) averaged 111.6 in 2021 and 138.4 in 2025.3 Prices rose by π=138.4−111.6111.6=26.8111.6≈0.240\pi = \frac{138.4 - 111.6}{111.6} = \frac{26.8}{111.6} \approx 0.240, so about 24%.

In 2021 pounds, 2025 revenue is Rreal=1.68×111.6138.4=1.68×0.8064≈£1.355R^{\text{real}} = 1.68 \times \frac{111.6}{138.4} = 1.68 \times 0.8064 \approx \text{£}1.355 million. The real growth is greal=1.201.240−1≈0.968−1=−0.032g_{\text{real}} = \frac{1.20}{1.240} - 1 \approx 0.968 - 1 = -0.032, a real fall of about 3.2%. 20% more pounds bought about 3% less.

The same sum for each year, with the yearly CPI averages of 121.7 for 2022, 130.5 for 2023 and 133.9 for 2024,3 gives the real line in the chart.

Line chart of Pennine Outfitters annual revenue from 2021 to 2025, invented example data, in millions of pounds. The nominal line rises steadily from 1.40 to 1.68 million. The real line, adjusted to 2021 prices with the ONS Consumer Prices Index, starts at 1.40 million and drifts down to about 1.35 million, so in real terms revenue fell by about 3%. Tap or click to open full screen and move around

Over a single year the gap is smaller, but it is not zero. UK consumer prices in September 2026 were 3.5% higher than a year earlier.4 That figure comes back in the board slide at the end.

Simpson's paradox: every part improves and the whole gets worse

Sometimes a figure for the whole business moves one way while every part of it moves the other. This is Simpson's paradox, and it happens whenever the mix between the parts changes.5 The best known case is graduate admissions at the University of California, Berkeley, in 1973. Across the university, men were admitted at a higher rate than women. Department by department, Peter Bickel and his colleagues found no bias against women. Women had applied more often to the departments that turned most people away.6

The arithmetic behind it is a weighted mean. A total rate is the rates of the parts, each weighted by its share of the whole.

m=∑cwc mcm = \sum_{c} w_c \, m_c

mm is the overall figure, here the gross margin of the whole business as a percentage. cc runs over the channels. wcw_c is channel cc's share of revenue (the shares add up to 1), and mcm_c is the margin inside channel cc. If the weights wcw_c shift towards a low margin channel, mm can fall even when every mcm_c rises. The weighted mean is in Foundations: the mean, and the article on why averages mislead goes much deeper into the paradox.

Example: both channels earn more, the business earns less per pound

Gross margin is the share of revenue left after paying for the goods sold. The physical shop sells at full price with no delivery cost. Online sells with discounts and free delivery. Both improved their margin by a point this year:

ChannelRevenue Q3 2025Margin Q3 2025Revenue Q3 2026Margin Q3 2026
Leeds shop£220,00052%£196,00053%
Online (web and social)£180,00028%£234,00029%

In Q3 2025 the shop had w=220,000400,000=0.55w = \frac{220{,}000}{400{,}000} = 0.55 of revenue and online 0.450.45. So m=0.55×52%+0.45×28%=28.6%+12.6%=41.2%m = 0.55 \times 52\% + 0.45 \times 28\% = 28.6\% + 12.6\% = 41.2\%.

In Q3 2026 the shop had w=196,000430,000≈0.456w = \frac{196{,}000}{430{,}000} \approx 0.456 and online ≈0.544\approx 0.544. So m≈0.456×53%+0.544×29%≈24.17%+15.78%≈39.9%m \approx 0.456 \times 53\% + 0.544 \times 29\% \approx 24.17\% + 15.78\% \approx 39.9\%.

Grouped bar chart of gross margin for Pennine Outfitters in Q3 2025 and Q3 2026, invented example data. The Leeds shop rose from 52% to 53%, online rose from 28% to 29%, yet the margin of the whole business fell from 41.2% to 39.9%, because more of the revenue came from the lower margin online channel. Tap or click to open full screen and move around

Owen can show "margin down 1.3 points". Hannah can show "margin up in every channel". Both are true. The honest chart shows the parts and the whole together, and the honest sentence names the cause: the mix moved online. One more framing hides in the same table. Gross profit in pounds went from £164,800 to about £171,700, up by roughly £6,900. A lower margin on a bigger total can still leave more money in the bank.

Survivorship bias: the data you see is the data that stayed

Every dataset is made of the things that were around to be counted. Customers who left do not fill in surveys. Products that were dropped are not in this year's sales report. Shops that closed are not in the industry average. When the missing ones differ from the ones that stayed, every chart built on the survivors is biased. This is called survivorship bias.

The classic story comes from the Second World War. The statistician Abraham Wald worked on how to protect aircraft, using the damage on planes that came back. The planes that were hit in the most vulnerable places mostly did not come back, so the damage you could see on returning planes pointed away from where armour was needed most. Marc Mangel and Francisco Samaniego later reconstructed his method from his wartime memoranda.7

Example: the loyalty scheme that everyone loves

Hannah's next slide says "85% of members rate the loyalty scheme good or very good". Sam checks where the number comes from.

GroupMembers
Joined the scheme in the year2,000
Left the scheme again800
Still members, surveyed1,200
Answered the survey600
Answered good or very good510

The 85% is 510600×100=85%\frac{510}{600} \times 100 = 85\%. It is the share of happy people among members who stayed and chose to answer. The 800 who left were never asked, and they are exactly the people most likely to say no. Measured against everyone who joined, the share with a confirmed good opinion is 5102,000×100=25.5%\frac{510}{2{,}000} \times 100 = 25.5\%. That is not the true approval rate either, since 1,400 people gave no answer. The honest statement is a range with its denominator: "Of 2,000 people who joined, 510 told us they rate it good, 90 told us they do not, 800 left without being asked, and 600 members did not reply." A short exit question for people who leave would turn the biggest unknown into data.

The baseline decides the verdict

"Up" and "down" only mean something against a baseline, and a business has at least three: the same period last year, the target someone set, and the plan or budget the board approved. A single actual figure can beat one and miss another. Choosing which one to show is choosing the verdict.

Each baseline answers a different question. Against last year: are we growing? Against the target: did we reach what we aimed for? Against the plan: is the money we budgeted on the basis of this figure still safe? A board needs all three, in a fixed order, every quarter. If the comparison changes from report to report, a reader should ask why.

The size of a gap against a baseline is the same relative change as before, with the baseline as voldv_{\text{old}} (see Foundations: percentages).

Example: £430,000 is a win, a miss and roughly on plan

Pennine Outfitters' Q3 2026 revenue was £430,000.

BaselineBaseline valueGap in poundsGap as a percentage
Same quarter last year£400,000up £30,00030,000400,000×100=7.5%\frac{30{,}000}{400{,}000} \times 100 = 7.5\% up
Target set in January£460,000down £30,00030,000460,000×100≈6.5%\frac{30{,}000}{460{,}000} \times 100 \approx 6.5\% down
Budget plan£420,000up £10,00010,000420,000×100≈2.4%\frac{10{,}000}{420{,}000} \times 100 \approx 2.4\% up

Hannah shows the first row. Owen shows the second. The plan row is the one nobody chose, and it is the one Helen signed off. All three go on the slide, always in the same order.

Framing on purpose, and saying so

Every chart has a framing, because every chart needs a unit, a baseline and a choice of what to divide by. You cannot avoid choosing. What you can avoid is choosing silently, or choosing a different framing for each number depending on which one flatters it.

The UK's Office for Statistics Regulation calls the standard it expects from government "intelligent transparency". Its guidance asks for figures to come with their source, their definitions, their strengths and limitations, and the context needed to read them, and it warns against selective use of data without that context.8 That is a public sector standard, but it is a good one for any board report.

In practice it comes down to a few habits:

  • Say the framing in the chart. One line under the title: what is compared with what, in which unit, adjusted or not.
  • Use the same framing for good and bad news. Points for every rate, or percentage change for every rate. Never one for the good and the other for the bad.
  • Show the size and the speed. Absolute change and relative change together, at least for the headline numbers.
  • Show the parts next to the whole whenever the mix can move.
  • Ask who is missing before trusting a rate.

This is also why I start every analytics project from the decision the numbers should support rather than from a dashboard (the article start with the decision, not the dashboard explains the method). Once you know the decision, the right framing usually follows: a decision about stock needs units, a decision about marketing spend needs pounds per customer, and a decision about prices over several years needs real money.

The flow chart below is the checklist Sam runs before any number goes onto a slide.

Tap or click to open full screen and move around

Example: the framing note under one chart

Sam's chart of channel revenue gets this line under its title: "Change against July to September 2025, in pounds, not adjusted for inflation. Percentage change shown on each bar." It takes ten seconds to write. It removes the argument about which framing was used, so the meeting can argue about the business instead.

Worked example: one quarter, two stories, one honest slide

Here is the full quarter, put together. First the two stories as they arrived.

Hannah's four charts:

  1. Social shop revenue up 150%.
  2. Web conversion up 20%.
  3. Customers up 24%.
  4. Margin up in every channel, and 85% of loyalty members happy.

Owen's four charts:

  1. Leeds shop revenue down £24,000.
  2. Returns up 25%.
  3. Revenue per customer down 13%.
  4. Business margin down 1.3 points, and revenue £30,000 below target.

Every one of these eight claims is correct. Read Hannah's alone and the business is thriving. Read Owen's alone and it is in trouble. Helen cannot decide anything from either.

Sam builds one slide instead, in four steps.

Step 1, the headline in pounds and as a percentage. Revenue rose from £400,000 to £430,000, which is £30,000 or 7.5%.

Step 2, the real figure. Prices were 3.5% higher than a year earlier,4 so with the shortcut formula, real growth is greal=1.0751.035−1≈1.0386−1=0.0386g_{\text{real}} = \frac{1.075}{1.035} - 1 \approx 1.0386 - 1 = 0.0386, about 3.9%. Strictly the quarter's own inflation rate should be used, and a monthly figure is close enough for a board slide as long as the slide says so.

Step 3, where the change came from, as a bridge. A waterfall chart starts at last year's total, adds each channel's change, and lands on this year's total. Both totals are drawn from zero, so the size of every step is honest.

Waterfall chart for Pennine Outfitters, invented example data. It starts with total revenue of 400,000 pounds in Q3 2025, adds 48,000 pounds from the web shop and 6,000 pounds from the social shop, subtracts 24,000 pounds from the Leeds shop, and ends at 430,000 pounds in Q3 2026. The web shop carried the growth, and the Leeds shop fall took away half of it. Tap or click to open full screen and move around

Step 4, the context everyone needs, one framing for each kind of number:

MeasureQ3 2025Q3 2026Change
Revenue£400,000£430,000up £30,000 (7.5%, about 3.9% real)
Against target (£460,000)down £30,000 (6.5%)
Against plan (£420,000)up £10,000 (2.4%)
Customers5,0006,200up 1,200 (24%)
Revenue per customer£80.00£69.35down £10.65 (13.3%)
Web conversion rate2.0%2.4%up 0.4 points
Return rate8%10%up 2 points
Gross margin41.2%39.9%down 1.3 points, both channels up 1 point
Gross profit£164,800£171,740up £6,940

The title of the slide states the finding, as the first chapter of this series recommends: "More customers and more profit, but each customer spends less and the Leeds shop is shrinking." Under it, the framing line: "All changes against July to September 2025. Rates in percentage points. Real growth uses the CPI rate for September 2026."

Notice what happened to the argument. Hannah's best point (more customers, online growing) is on the slide. Owen's best point (smaller baskets, a shrinking shop, a missed target) is on the slide. The loyalty score is left off until the leavers have been asked. Helen now has two real questions to decide on instead of two stories to choose between: why are new customers buying less, and what is the plan for the Leeds shop?

The point in one paragraph

The same data can support opposite conclusions, and usually neither side is lying. They are choosing different framings: relative or absolute, percentage change or points, total or per customer, a convenient base, nominal or real money, the whole or its parts, the survivors or everyone, last year or the target. You cannot present a number without a framing. You can present it with a framing that you chose on purpose, applied the same way to good news and bad, and written under the chart. When two framings tell different stories, the honest slide shows both and lets the decision makers see the tension, because the tension is usually where the decision is.

If your board hears two stories from the same numbers every quarter, book the free workshop: we pick the framing for each number together, around the decision it supports, and the first two weeks of work are on me.

Sources

  1. 1.

    Amos Tversky and Daniel Kahneman, The framing of decisions and the psychology of choice, Science, volume 211, issue 4481, pages 453 to 458, 1981, https://pubmed.ncbi.nlm.nih.gov/7455683/

  2. 2.

    Gerd Gigerenzer, Wolfgang Gaissmaier, Elke Kurz-Milcke, Lisa M. Schwartz and Steven Woloshin, Helping doctors and patients make sense of health statistics, Psychological Science in the Public Interest, volume 8, issue 2, pages 53 to 96, 2007, https://doi.org/10.1111/j.1539-6053.2008.00033.x

  3. 3.

    Office for National Statistics, CPI index 00: all items 2015=100 (series D7BT), annual averages 2021 to 2025, https://www.ons.gov.uk/economy/inflationandpriceindices/timeseries/d7bt/mm23

  4. 4.

    Office for National Statistics, CPI annual rate 00: all items 2015=100 (series D7G7), September 2026, released 21 October 2026, https://www.ons.gov.uk/economy/inflationandpriceindices/timeseries/d7g7/mm23

  5. 5.

    Jan Sprenger and Naftali Weinberger, Simpson's Paradox, Stanford Encyclopedia of Philosophy, 2021, https://plato.stanford.edu/entries/paradox-simpson/

  6. 6.

    P. J. Bickel, E. A. Hammel and J. W. O'Connell, Sex bias in graduate admissions: data from Berkeley, Science, volume 187, issue 4175, pages 398 to 404, 1975, https://doi.org/10.1126/science.187.4175.398

  7. 7.

    Marc Mangel and Francisco J. Samaniego, Abraham Wald's work on aircraft survivability, Journal of the American Statistical Association, volume 79, issue 386, pages 259 to 267, 1984, https://doi.org/10.1080/01621459.1984.10478038

  8. 8.

    Office for Statistics Regulation, Regulatory guidance on intelligent transparency, UK Statistics Authority, published 2 February 2022, updated September 2023, https://osr.statisticsauthority.gov.uk/guidance/regulatory-guidance-on-intelligent-transparency/pages/2/