Turning a spreadsheet into an executive presentation starts with reconciling the numbers, not copying the dashboard. Define what each metric counts, calculate the overall result from the underlying counts, and separate a change in performance from a change in business mix. Then build the slides around the decision the numbers support.
This matters when the headline and the regional reports appear to disagree. In the worked example below, both regions improve their on-time delivery rate, yet the company total falls. The presentation needs to explain that apparent contradiction before asking leaders to act. Once the calculation is settled, use this guide to choose a chart that matches the comparison.
1. Give the spreadsheet a clear reporting boundary
Suppose an operations team is preparing a quarterly review. Its question is: “Why did our overall on-time delivery rate fall, and where should we investigate?” The following numbers are an illustrative example, not customer results.
Count orders due for delivery in the quarter, rather than orders placed in the quarter. An on-time order is one delivered by its agreed due date. Keep the definition and the extraction cutoff identical across regions. If cancellation handling or the due-date rule changed, reconcile that difference before comparing the periods.
| Quarter | Region | Orders due | On time | On-time rate |
|---|---|---|---|---|
| Q2 | North | 800 | 760 | 95% |
| Q2 | South | 200 | 160 | 80% |
| Q3 | North | 400 | 388 | 97% |
| Q3 | South | 600 | 492 | 82% |
Keep these four records in the source table. Put totals in a separate calculation area so a chart or pivot table cannot accidentally count both the regional rows and their subtotal. Record the workbook version, sheet name, selected range, and extraction date with the analysis.
2. Recalculate the headline from counts
For Q2, the company rate is (760 + 160) ÷ (800 + 200) = 92%. For Q3, it is (388 + 492) ÷ (400 + 600) = 88%. The total fell by 4 percentage points; it did not fall by 4 percent. The relative decline is about 4.35%.
Do not average the two regional percentages. That would give 87.5% for Q2 and 89.5% for Q3: a rise that answers a different question, because it weights the small and large regions equally. The company rate must weight each order equally.
If the table above starts in cell A1, with counts in columns C and D, the Q2 rate is =(D2+D3)/(C2+C3). The Q3 rate is =(D4+D5)/(C4+C5). Format the results as percentages; retain the unrounded values in the calculations. When a denominator is zero, show “not available” rather than manufacturing a 0% result.
3. Explain why the regional and total results differ
North improves from 95% to 97%; South improves from 80% to 82%. But South's share of orders grows from 20% to 60%. More of the company's orders now sit in the region with the lower delivery rate.
To make the effect visible, hold the Q2 order mix constant and apply the Q3 regional rates: 80% × 97% + 20% × 82% = 94%. At the old mix, the improved regional rates would produce 94%, not the observed 88%.
This gives a simple, explicitly ordered bridge: 92% → 94% from the regional rate changes at the old mix, then 94% → 88% from changing the mix at the new rates. The two steps contribute +2 and −6 percentage points, adding to the observed −4 points. Label the calculation “Q3 rates at Q2 mix,” not “expected Q3 performance.” It is a comparison scenario, not a forecast.
The arithmetic explains the aggregate decline. It does not explain why South has a lower on-time rate. Staffing, order complexity, transport routes, and the reliability of due dates remain possible questions, not established causes.
4. Turn the calculation into five useful slides
Lead with what leaders need to decide. Do not make them work through a tour of the workbook before they learn why the figures matter.
| Slide | Message | What to show |
|---|---|---|
| 1. Decision | Investigate the larger South workload before choosing a remedy. | A proposed two-week operational review; name the owner and information needed. |
| 2. Company result | Overall on-time delivery fell from 92% to 88%. | Two directly labeled bars, with 920/1,000 and 880/1,000 beside them. |
| 3. Regional result | Both regions improved by 2 percentage points. | Paired bars for North and South, using the same scale. |
| 4. Workload mix | South's share of orders increased from 20% to 60%. | Two 100% stacked bars and a small annotation showing the 94% constant-mix result. |
| 5. Next analysis | Identify the late-order patterns before allocating extra capacity. | A breakdown request by route, order type, and due-date changes, with a review date. |
Use a zero baseline for bars and distinguish the two quarters with labels as well as color. Keep the complete source table and the calculation bridge in an appendix. If the audience wants exact values more than a visual pattern, the four-row table is a perfectly reasonable slide; it does not need to become a decorative chart.
5. Give AI the approved brief, not an unexplained workbook
Presenti's text-to-presentation workflow can turn an outline into an editable slide draft. For this task, prepare the calculations in your spreadsheet first, then supply the approved numbers and slide messages as text. This is not a claim that Presenti imports Excel formulas or keeps a live workbook connection.
Create a five-slide operations review using the outline above. The data is illustrative. Q2: North 760/800, South 160/200, total 920/1,000. Q3: North 388/400, South 492/600, total 880/1,000. Preserve all counts and percentages. Both regional rates rise by 2 percentage points; the company rate falls by 4 percentage points. At Q2 mix, Q3 rates give 94%. Distinguish this comparison scenario from the observed 88%. Do not invent a cause, benchmark, saving, or staffing requirement. The proposed next step is a two-week investigation, not an approved intervention.
Review the generated titles first. “South deteriorated” would contradict the source. “Additional staff will restore 92%” would introduce an unsupported outcome. Replace either with the narrower statements the analysis actually supports.
6. Hand over a deck that can be updated accurately
Keep the editable presentation with the exact workbook snapshot used to build it. For each quantitative slide, note the source sheet and range, reporting period, metric definition, and whether the chart is static or connected to a data source. Do not imply automatic refresh unless the actual handoff format has been tested.
When the next quarter arrives, update the counts before the titles. Recalculate the total and the comparison scenario, then decide whether the original explanation still holds. A new dataset may need a different recommendation even when the old slide design still works.
