Use sparklines to show data trends

A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. 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. For best impact, position a sparkline near its data.

Add a Sparkline

Select a blank cell at the end of a row of data.

Blank Cell
Select Insert and pick Sparkline type, like Line, or Column.

Insert
Select cells in the row and OK in menu.

Cells
More rows of data? Drag handle to add a Sparkline for each row.

Sparkline

Format a Sparkline chart

Select the Sparkline chart.

Sparkline Chart
Select Sparkline and then select an option.
- Select Line, Column, or Win/Loss to change the chart type.
- Select a Style for the Sparkline.
- Select Sparkline Color and the color.
- Select Marker Color to change the color of the markers.
  
  Sparkline
- If the data has positive and negative values, select Axis to show the axis.
  
  Axis