Create a sparkline chart

A Sparkline is a small chart that shows simple patterns using the column and rows of data within cells of a worksheet. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values.

Steps

To create a sparkline

1. Select an empty cell to insert a sparkline.

2. Click Insert > Sparkline and then select LineColumn, or Win/Loss.

mceclip1.png

3. Specify the range of data (in row or column) on the Insert Sparkline dialog.

mceclip2.png

4. Click the OK button on the Insert Sparkline dialog.

mceclip3.png

Tip: Need more rows of data? Drag handle to add a sparkline for each row.

mceclip5.png

After dragging handle:

mceclip6.png

 

To delete a sparkline

  1. Select a cell with a sparkline to delete.
  2. Press the right mouse button and select Sparkline > Clear Selected Sparklines from the context menu.

mceclip0.png

Was this article helpful?
0 out of 0 found this helpful