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
- A chart is linked to cells: change a number and the column redraws.
- If the data is formatted as a table (Ctrl+T), new rows join the chart automatically.
- For "the last 12 months" the range is defined by a name with an
OFFSETformula or with dynamic array functions. - A filter in a PivotTable immediately changes its PivotChart.