Display the data as a line chart inside a cell. This is useful for visualizing and presenting fluctuating data such as stock changes and temperature changes.
Create Line Sparkline
- Select an empty cell to insert a sparkline.
- Click Data-Sparklines-Line.
- Specify the range of data on the Insert Sparkline dialog box.
- Click OK.
Change Line Sparkline Location
- Right-click the sparkline you want to move.
- Select Sparklines-Group Location and Edit Data from the context menu.
- In the Edit Sparkline Data dialog box, specify location to display the sparkline in Location Range.
- Click OK.