Fixing a Three-Visual Business Review Slide
A monthly business review slide for 12 regional managers packs three visuals: a 3D exploded pie chart with 11 regional slices plus "Other," a line chart whose vertical axis starts at 80% and shows a "dramatic" rise from 84 to 89, and a 9-column, 14-row table set at 9-point. The slide will be projected in a 20-person conference room and printed in black and white as a handout. The presenter's message is "the North region improved, but two regions are below target, and the rest are flat." The data source is a spreadsheet that updates monthly. A regional manager has already challenged the line chart in a previous meeting, saying it exaggerates the trend. The deck owner wants to keep all detail "for transparency."
1. Choose the primary visualization for regional performance and justify it against the presenter's message. Explain what happens to the pie chart.
Read the worked answer
The message has three parts: one region improved, two are below target, and the rest are flat. That is a comparison and exception story, not a part-to-whole story. A sorted horizontal bar chart with 11 regions is the right primary visual: region names are readable on the left, bars compare actual performance against a target line, and the three exceptions can be highlighted with one accent color while the flat regions recede in gray.
Add a target line and label it. Highlight North for improvement and the two below-target regions for risk, but do not use a third and fourth color; use one accent plus bold labels. Put the actual and target values at the bar ends so the chart survives black-and-white printing.
The 3D exploded pie is the wrong tool. Twelve slices cannot be compared accurately, the explosion adds no information, and 3D perspective distorts area. Keep a pie only in the appendix if someone needs share of total, and then use a single 100% stacked bar or a sorted bar chart instead. If the deck owner wants transparency, move the 12-slice pie and the source table to the appendix rather than forcing three visuals onto one projected slide.
2. Fix the line chart and its axis. What is defensible practice when the audience has already challenged the chart?
Read the worked answer
A vertical axis starting at 80 makes a 5-point change look like a cliff. That is the root of the credibility problem, not the audience's misunderstanding. For a line chart, starting at zero is not an absolute rule, but a truncated axis is only defensible when it is clearly labeled, the range is justified, and the chart does not imply a magnitude it does not show. Here the presenter wants "dramatic," so the truncation is doing persuasive work rather than analytical work.
Replace the chart with one that matches the claim. If the claim is change over time, use a line chart with a 0–100 axis and annotate the 5-percentage-point change directly. If the claim is improvement relative to target, use a slope or column chart of change in percentage points, or a dot plot showing prior and current values against the target. Label the axis in percentage points and put the actual values at the endpoints.
If a zoomed view is genuinely needed, label the axis "axis starts at 80%" in the same size as the axis labels and add a note that the vertical distance is magnified. Do not use 3D, shadows, or gradient fills. Rehearse the explanation so the presenter can say "five points, against a target of 90" without defensiveness.
3. Redesign the 9-column, 14-row table for projection and black-and-white print. Decide what stays, what goes to the appendix, and how to preserve transparency.
Read the worked answer
At 9-point and nine columns, the table is unreadable in a 20-person room and will turn to gray mush in black-and-white print. Reduce the projected table to five columns: region, actual, target, variance, and status or trend. Keep 11 region rows plus a total, set at 14 points minimum, sorted by variance so the two below-target regions sit at the top or bottom where the eye lands. Replace color coding with bold text, plus and minus signs, and explicit labels such as "below target." Highlight only the three exceptions.
The four removed columns and the full 14-row detail go to an appendix slide and to the printed handout, which is where transparency actually helps. Put the data-source note and refresh date on both. If the table must update monthly, link it to the spreadsheet or paste as a linked table, but test that formatting survives the update.
Do not keep all nine columns on the projected slide "for transparency." Transparency means the detail is available and the numbers are traceable, not that every column is visible at once. The projected slide should support the decision the meeting is making; the appendix should support the audit.