Home > Sample chapters > Microsoft Office > Excel

Analyzing Your Excel 2013 Data

Adding sparklines

Sparklines are simple and fun conditional formatting tools that make it easy for you to show at a glance what the data trend is in the values on your worksheet. You can customize your sparklines so that they appear in different colors and styles.

Excel 2013 offers three types of sparklines: Line, Column, and Win/Loss. The Line option displays your data as a small line chart. The Column sparkline format shows your data as comparison values displayed as a small bar chart. The Win/Loss option displays values as a sequence of colored dashes that clearly indicate the high and low points in your data.

Create sparklines

  1. Select the cells that you want to summarize.

  2. Click the Insert tab.

  3. In the Sparklines group, click the type of sparkline that you want to create.

    The Create Sparklines dialog box opens. The data that you selected already appears in the Data Range box, and the cursor is positioned in the Location Range box.

  4. Click the cell on the worksheet in which you want the sparkline to appear.

    The cell address displays in the Location Range box.

  5. Click OK to add the sparkline.

Edit sparklines

  1. Click the cell that contains the sparkline you want to edit.

    The Sparkline Tools Design tab appears, offering a number of tools that you can use to edit the sparklines.

  2. In the Show group, select the desired check boxes to add data markers to your sparkline.

  3. Choose a style to apply to the sparkline.

  4. Click to change sparkline color.

  5. Click to change the color of the data markers that you added to your sparkline.