The Job of a Chart: Answer a Question, Not Decorate
Learning objective: start from analytical question and audience; define one primary message per chart.
A colleague asks you to "visualize the quarterly numbers." If you open a spreadsheet and pick whatever chart type looks nice, you have already lost the thread: a chart is not decoration, it is the answer to a specific question for a specific audience. Before choosing a chart type, you need to know what question it answers and what the one sentence underneath it should say.
Decoration first
Pick an attractive chart type, add every available metric, apply a colorful theme, and hope the reader finds the point.
Question first
- Question
- State the one analytical question this chart must answer (a comparison, a trend, a distribution, a relationship, or a composition).
- Audience
- Identify who reads this and what decision or follow-up question they have.
- Message
- Write the one sentence the chart should let the reader say out loud.
| Vague request | Chart brief |
|---|---|
| "Visualize the quarterly numbers" | Question: which of our five product lines grew fastest this quarter? Audience: department head deciding where to invest next quarter. |
| "Show the ESG data" | Question: how has our water-intensity metric trended over the last two years? Audience: sustainability committee checking progress against a target. |
import pandas as pd
# clean: a multi-entity, multi-period indicator table (ESG / campus / operations)
df = pd.read_csv("DS103_Indicators_Clean.csv")
df.shape
df.head()
# Before plotting anything: what is the ONE question this chart must answer?
question = "Which entities had the highest emissions intensity in the latest period?"Warning
Info
- State the question in one sentence, and make it exactly one of: comparison, trend, distribution, relationship, or composition
- Name the audience as a specific role or decision-maker, not "everyone"
- Write the message so the reader can say it out loud within five seconds, with no extra explanation needed
- Write the brief before drawing anything, not as a caption added after the chart is already built
A sales manager originally asked only to "chart the sales team numbers." After a follow-up question, the real question turned out to be "which region's new-customer conversion rate dropped the most over the last four quarters?", and the audience was the regional director deciding where to put next quarter's training budget. With that brief in hand, the right chart type (a trend line colored by region with direct labels) is almost immediate, without testing seven or eight chart types first.
A strong message
- Fits in one sentence with no spoken explanation needed
- Names a specific entity, period, or value
- States clearly what is being compared, tracked, or highlighted
A weak message
- Only repeats variable names already on the axis or legend
- Needs a spoken explanation before the point lands
- Tries to answer more than one question at once
A manager asks you to "make a chart of everything in the sales file." What should you do first?