Charts: Picturing the Answer

Lesson 7 · taught by Pip

A summary table is good. A picture is often better, because the human eye grasps a shape faster than it reads a column of numbers. A chart (also called a graph) turns your figures into a drawing — bars, lines, slices — so the answer leaps out at a glance.

Think of a weather report. Nobody reads you a list of temperatures for the week; they show a little row of sun-and-cloud icons, and you understand the week in one look. A chart does that for your data: it trades numbers for a shape your eye can read instantly.

Match the chart to the question

The single most important skill here isn't drawing the chart — your spreadsheet does that. It's choosing the right kind. Three charts cover most everyday needs, and each answers a different sort of question.

Bar chart — for comparing categories. When you want to compare separate things side by side — sales per region, votes per candidate, students per class — a bar chart is your friend. Each category gets a bar; taller means more. The eye compares heights effortlessly. This is the workhorse, and when unsure, it's usually the right pick.

Line chart — for change over time. When your question is "how did this move over time?" — sales month by month, temperature through the day, visitors across the year — use a line. The line rises and falls, and you read the trend: climbing, dipping, steady. Lines are for time; don't use them to compare unrelated categories.

Pie chart — for parts of a whole. When you want to show how one total splits into pieces — what share of the budget each department takes — a pie shows the slices. Use it sparingly: pies only work when the slices are few (three or four) and clearly different in size. More than that and the eye can't judge the slices, and a bar chart does the job better.

The pieces of a chart

A few plain terms make charts easy to talk about. The bottom edge is the x-axis (often categories or time). The side edge is the y-axis (usually the numbers, the amounts). The title says what the chart shows in one line. The legend is the little key explaining what each color means. And labels are the names and numbers written along the axes.

A chart with no title and no axis labels is a riddle. Always name the chart and label the axes, so someone seeing it cold understands it without you standing there to explain.

Honest charts vs. misleading ones

Here's the part that matters most, because a chart can mislead as easily as it can illuminate — sometimes by accident.

The biggest trap is the y-axis that doesn't start at zero. If a bar chart's number line starts at 95 instead of 0, a change from 98 to 100 looks like a towering leap, when it's really a tiny nudge. For bar charts especially, start the y-axis at zero so the bar heights tell the truth.

Two more: don't cram so many lines or slices onto one chart that it becomes spaghetti — if it's unreadable, split it up. And label your units. "Sales: 40" — forty what? Dollars, thousands, units? An honest chart never makes the reader guess. The goal is always the same: help the eye see what's truly there, not trick it into seeing more.

Why this matters

A chart is how your data finally communicates. All the cleaning, sorting, filtering, and summarizing has been quiet, private work; the chart is where the answer goes public — in a report, a meeting, a post. A clear, honest chart can change a decision. A confusing or misleading one can wreck trust in everything you built. This is the payoff step, so it's worth getting right.

Your turn

Take a small summary — ideally the pivot table from last lesson:

1. Ask yourself the question first: comparing categories, change over time, or parts of a whole?
2. Insert the matching chart — bar, line, or pie.
3. Add a clear title and label both axes, including units.
4. Check the y-axis: does it start at zero? If not, ask whether that's honest for your data.

Next, in our final stop, we'll string the whole journey together into one shareable "data story." 🔦