A chart answers one question. Phrase the question first — it tells you the type.
| Compare amounts | column (vertical bars) or bar (horizontal — when category labels are long or there are many categories) |
| Show change over time | line: months or years on the X axis, the line shows the trend |
| Show parts of a whole | pie — only with 2–5 parts that add up to 100%. Otherwise a bar chart is better |
| Find a relationship between two measures | scatter: each dot is a pair of numbers (advertising and sales); you see whether one grows with the other |
How to build one
- Select the data with the headers: the first row becomes the series names, the first column the category labels.
- Insert → Recommended Charts — Excel suggests suitable ones; or pick the type yourself.
- Quickly: Alt+F1 — a chart on the same sheet, F11 — on a separate sheet.
In the trainer below: select a range on the sheet with the mouse, click Use selection and choose a type.