A chart with no message is a table in disguise

Start from the question, not the ribbon

The owner of Maple & Birch asks: did Alberta out-sell Ontario per order this quarter? The Module 7 pivot already holds the answer — Average of amount by prov: AB 1150, ON 498.75, BC 453.33, QC 161.67. The temptation is to select the pivot, press Insert → Chart, and accept whatever appears. What appears is a chart titled "Average of amount" with the provinces in alphabetical order and no unit on the axis. It is a table in disguise: the reader still has to work out the point.

Beginning Excel's rule is that a chart is built in four decisions, in order, and the ribbon comes last:

1. Message — the one sentence the chart must make a reader believe.
2. Data — only the cells that carry that sentence.
3. Chart type — chosen for the message and the variable types (Lesson 8.2).
4. Axes — a scale that shows the message honestly (Lesson 8.5).

Then the labelling that turns a picture into evidence: a title that states the message, axis labels with units, and a source line.

Worked example — the Alberta question

Message. "Alberta's average order is more than twice Ontario's — on only two orders." The second clause matters: 1150 is the mean of 1320 and 980, and Lesson 7.6 taught that a comparison across groups must say how many rows each group rests on.

Data. Four numbers: the province averages. Not the twelve orders, not the sums (AB's 2300 against ON's 1995 answers total, and the question was per order), not the counts as a second series. A chart that carries every column carries no message.

Chart type. One categorical (prov) and one numeric summary per category → a bar chart, with the bars sorted by value (AB, ON, BC, QC) so the eye reads the ranking without hunting; alphabetical order is the pivot's convenience, not the reader's.

Axes. The value axis starts at 0 so the AB bar is visibly about twice ON's. The category axis needs no units; the value axis reads Average order amount (CAD).

Labels. Title: Alberta leads on average order value (2 orders). Axis: Average order amount (CAD). Source: Maple & Birch orders, Jan–Mar 2025. Legend: none — one series needs no legend, and a legend reading "Average of amount" is chart junk.

Two mechanics that bite in the quiz

Select the data with its header row: the header becomes the series name and the axis title. Select the numbers alone and Sheets or Excel names the series Series1 and the legend says nothing. And select only the block you want — a pivot's Grand Total row, dragged into the selection, becomes a fifth bar three times taller than any province.

Order the steps, then rewrite a title

The questions ask for the first decision, for the title that states a message rather than a label, and for what selecting without headers costs.

CRISP-DM: choosing the message is business understanding written down; the chart itself is data understanding → explore data.