3.2Charts & pivot charts
The essentials in 30 seconds
- The chart serves a message: compare → columns/bars, trend → lines, breakdown → pies (≤ 5 parts) — you choose according to the message, not aesthetics.
- Clean up to read in 3 seconds: clear title, readable axes, no decoration — no heavy gridlines, no 3D, no useless legend.
- The pivot chart follows the pivot table: linked to the pivot table, it updates when you filter or rearrange — the building block of the dashboard.
Running mini-case — Wassim and the pie that said everything… except the essential
Wassim, an accountant in Algiers, presents the revenue trend over 12 months as a pie chart: his director sees no trend. He starts over: a line for the trend, columns to compare the regions, then a pivot chart linked to his pivot table — when he filters on Algiers, the whole visual follows. The director understands in 3 seconds. The message chooses the chart, never the other way around.
The same case returns in the course, the diagram, the script and the 48h challenge.
1. The chart serves a message, not decoration
A chart is not decorative: it must make a message obvious. Simple rule: compare categories → columns/bars; show a trend over time → lines; a breakdown of a whole → pies (sparingly, 5 parts maximum). You choose the type according to what you want to make understood, not according to aesthetics.
Wassim's classic mistake — a pie for a trend — blurs everything: twelve illegible slices instead of a trend. Horizontal bars when the labels are long (they stay readable), columns otherwise: same use, better readability. The chart type is deduced from the message.
2. Clean up, then link to the pivot table: the interactive visual
You select the data (with headers) then Insert ▸ Chart. The essential thing next is to clean up: a clear title, readable axes, remove the superfluous (heavy gridlines, 3D effects, useless legends). A good chart reads in 3 seconds — otherwise, it is noise.
A pivot chart is linked to a pivot table: it updates when you rearrange or filter the pivot table, and reacts to slicers (next section). It is the basic building block of an interactive dashboard: you filter once, the whole visual follows.
The pie of shame
A pie does not show time passing — it slices it up.
🔎 Concrete example — The wrong chart blurs the message
Wassim wants to show the revenue trend over 12 months:
PIE 12 months: impossible to read a trend
LINE 12 months: the trend jumps to the eye
Compare 5 regions? => columns, not a line.Reading: a time trend = a line; a comparison = columns.
Lesson: the chart type is deduced from the message to convey.
Section vocabulary
- Chart
- Visual representation of data that conveys a precise message in 3 seconds.
Simple example: Wassim's revenue line, readable at a glance.
What it is not: a table of raw figures or a decorative visual.
Reflex: one chart = one message.
- Columns / bars
- Compare values between categories; horizontal bars if labels are long.
Simple example: Sales compared by region.
What it is not: a time trend in stacked columns.
Reflex: compare = columns, long labels = bars.
- Lines
- Show a trend over time — the trend jumps to the eye.
Simple example: Wassim's revenue month by month.
What it is not: a 12-slice pie breakdown.
Reflex: time passing = a line.
- Pies
- Show a breakdown of a whole, 2 to 5 parts maximum, total 100%.
Simple example: Each product's share of revenue (4 products).
What it is not: 12 regions in an illegible pie.
Reflex: more than 5 parts = sorted columns.
- Pivot chart
- Chart linked to a pivot table: it follows its filters and rearrangements, and reacts to slicers.
Simple example: Wassim's visual that follows the Algiers filter.
What it is not: a chart frozen on a static range.
Reflex: living visual = linked to the pivot table.
In practice — Choosing and cleaning up a chart
- Create a column chart comparing sales by region.
- Create a line showing the monthly trend.
- Clean up: clear title, remove useless gridlines/effects.
- Insert a pivot chart from a pivot table.
Ready-to-say script — defending your chart in a meeting (30 s)
«I put a line because the message is the trend over 12 months — a pie shows no trend. The chart is linked to the pivot table: if you want to see Algiers alone, I filter and the visual follows live.»
To say while presenting; filter the pivot table live to demonstrate.
Step-by-step template — pivot chart linked to the pivot table
1) Click in the pivot table > PivotTable Analyze > PivotChart
2) Type according to the message: Line (trend) / Columns (comparison)
3) Clear title: «Monthly revenue 2026 (kDA)»
4) Clean up: lighter gridlines, no 3D, legend only if useful
5) Filter the pivot table => the chart follows by itselfFreelancer
Message first, type second: your clients understand your figures in 3 seconds.
SME in Algiers
Wassim presents to the director: trend line, columns by region, visual linked to the pivot table.
Project team
Standardize: line for time, columns to compare, pies ≤ 5 parts.
Beginner
This week: a clean trend line + a chart linked to your pivot table.
✓ Best practices
- Choose the type according to the message.
- Clean up: title, axes, less decoration.
- Link to the pivot table for an interactive visual.
✗ Common pitfalls
- Pie for a trend → illegible.
- Pies with 12 parts → mush.
- Stacking 3D effects and colors that drown the information.
Key takeaways
- The chart serves a precise message.
- Compare → columns/bars; trend → lines; breakdown → pies (≤5).
- Clean up: a good chart reads in 3 seconds.
- The pivot chart follows the pivot table and the filters.
48h challenge — apply tomorrow
Redo 1 poorly chosen chart (right type + cleaned up) and add 1 pivot chart linked to your pivot table.
- My chart type follows from the message.
- My visual reads in 3 seconds, without decoration.
- My pivot chart follows the pivot table's filters.
Frequently asked questions
Columns or bars?
Same use (compare): columns (vertical) by default; bars (horizontal) when the category labels are long or numerous, because they stay readable horizontally.
Is the pie to be banned?
Not entirely, but reserved for a simple breakdown (2 to 5 parts, sum = 100%). Beyond that, it becomes illegible: prefer sorted columns or a bar chart.
Which chart to show a figure's trend over 12 months?