Course contents · Charts

Choosing a chart

Open the practice in the trainer →

A chart answers one question. Phrase the question first — it tells you the type.

Compare amountscolumn (vertical bars) or bar (horizontal — when category labels are long or there are many categories)
Show change over timeline: months or years on the X axis, the line shows the trend
Show parts of a wholepie — only with 2–5 parts that add up to 100%. Otherwise a bar chart is better
Find a relationship between two measuresscatter: each dot is a pair of numbers (advertising and sales); you see whether one grows with the other

How to build one

  1. Select the data with the headers: the first row becomes the series names, the first column the category labels.
  2. Insert → Recommended Charts — Excel suggests suitable ones; or pick the type yourself.
  3. 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.

Chart tasks

  1. Compare regional sales: a column chart of A1:B6.
  2. Show the monthly revenue trend: a line chart of D1:E13.
  3. Show the share of sales channels: a pie chart of G1:H5.
  4. Is there a link between advertising and sales? A scatter chart of J1:K11.

Solve the tasks in the trainer →

Check yourself

  1. You need to show how revenue changed month by month over 3 years. Which type?
  2. When is a pie chart appropriate?