Sparklines

If you use sparklines Excel has some excellent features. Use Excel sparklines to analyze trends in your data.

To create sparklines:

Generally, you will have one sparkline for each row, but you can create as many as you want in any location. Just like formulas, it's usually easiest to create a single sparkline and then use the fill handle to create sparklines for the adjacent rows. In our example, we'll create sparklines to help visualize trends in sales over time for each salesperson.

  1. Select the cells that will serve as the source data for the first sparkline. In our example, we'll select the cell range B2:G2.
    Screenshot of Excel 2013Selecting cells B2:G2
  2. Select the Insert tab, then choose the desired Sparkline from the Sparklines group. In our example, we'll choose Line.
    Screenshot of Excel 2013Clicking the Line command
  3. The Create Sparklines dialog box will appear. Use the mouse to select the cell where the sparkline will appear, then click OK. In our example, we'll select cell H2, and the cell reference will appear in the Location Range: field.


    Screenshot of Excel 2013Selecting a location for the sparkline and clicking OK
  4. The sparkline will appear in the specified cell.


    Screenshot of Excel 2013A sparkline
  5. Click, hold, and drag the fill handle to create sparklines in adjacent cells.
    Screenshot of Excel 2013Dragging the fill handle to create sparklines in adjacent cells
  6. Sparklines will be created for the selected cells. In our example, the sparklines show clear trends in sales over time for each salesperson in our worksheet.


    Screenshot of Excel 2013Sparklines filled to multiple rows