Analyze trends in data using sparklines

Showing trends in your worksheet data can be useful, especially when you’re sharing your data with other people. Use sparklines, tiny charts inside single worksheet cells, to visually represent and show a trend in your data. Sparklines can draw attention to things like seasonal increases or decreases or economic cycles, and highlight maximum and minimum values in a different color.

Worksheet with sparklines

  1. Select a blank cell next or close to the data you want to show in a sparkline.

  2. Click Insert > Line, Column, or Win/Loss.

Sparkline commands on the Insert tab

  1. In the Data Range box, enter the range of cells that has the data you want to show in the sparkline. For example, if your data is in cells A, B, C, and D of row 2, enter A2:D2.

Create Sparklines dialog box

If you’d rather select the range of cells on the worksheet, click Button image to temporarily collapse the dialog box, select the cells on the worksheet, and then click Button image to show the dialog box in full.

  1. Click OK.

The Sparkline Tools appear on the ribbon. Use the commands on the Design tab to customize your sparklines.

Sparkline Tools on the ribbon


  • Because a sparkline is embedded in a cell, any text you enter in the cell uses the sparkline as its background, like this:

    A cell containing a sparkline and text

  • If you select one cell, you can always copy a sparkline to other cells in a column or row later by dragging or using Fill Down (Ctrl+D).

Customize your sparklines

After you create sparklines, you can change their type, style, and format at any time.

  1. Select the sparklines you want to customize to show the Sparkline Tools on the ribbon.

Sparkline Tools on the ribbon

  1. On the Design tab, pick the options you want. You can:

    • Show markers to highlight individual values in line sparklines.

      Show group on the Design tab of the Sparkline Tools

    • Change the style or format of sparklines.

      Styles on the Design tab of the Sparkline Tools

    • Show and change axis settings.

      Axis button on the Design tab of the Sparkline Tools

    • Change the way data is shown

      Edit Data button in the Sparkline group

Applies To: Excel 2013

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language