and click "Line" in the Sparklines group of the Insert tab. You could choose another type of sparkline here, but the Line sparkline is the best way to create a mini-line chart showing a linear trend.

In Microsoft Excel, there are three types of sparklines, namely, Line, Column, and Win/loss. Sparklines are mini charts placed in single cells, each representing a row of data in your selection.

An curved arrow pointing right. Sparklines are word-sized charts that live in individual cells. This great feature was added to Excel in 2010 but still remains massively underutilized. Produced by ...