A handy feature in Excel is Sparklines. A Sparkline is a little chart that displays in the background of a cell and can help you to spot data trends at a glance. Sparklines take little room (the contents of one cell) and allow you to get a glance of your underlying data and a graphical representation of data trends right next to each other. What’s especially handy, is that if you change any of the underlying data, the Sparklines update instantly.
Sparklines can be added from the Insert tab of the Ribbon.
To Insert Sparklines into your Worksheet
- Click the Insert tab on the Ribbon.
- Choose Line, Column or Win/Loss (shows a basic positive or negative representation of your data set) from the Sparklines group of the Ribbon.
- Select or enter the range of cells that will serve as the underlying data for the Sparklines.
- Click in the Location Range box and then select or enter the range of cells where you wish the Sparklines to appear (The range should be in a single row or column).
- Click OK.
Share this post