Course contents · Charts

Sparklines and live charts

Open the practice in the trainer →

A sparkline is a tiny chart inside a cell: each row's trend sits right next to its numbers. Insert → Sparklines → Line / Column / Win/Loss; give the data range and the cells for the sparklines. The Sparkline tab marks the high point, low point, negative points.

Charts that update themselves

Chart tasks

  1. Insert line sparklines: data B2:M4, location N2:N4.
  2. Mark the high point on the sparklines.
  3. Change the sparkline type to column.
  4. Build a line chart of A1:M4 with series in rows — one line per product.
  5. The chart is live: type 0 into M3 — the Product B line and its sparkline will drop.

Solve the tasks in the trainer →

Check yourself

  1. Where does a sparkline live?
  2. How do you make new rows join a chart by themselves?