Working with Sparklines

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

Changing the appearance of your sparklines

To show points on the sparkline:

Certain points on the sparkline can be emphasized with markers—or dots—making the sparkline more readable. For example, in a line with a lot of ups and downs, it may be difficult to tell which ones are the highest and lowest points, but if you show the High Point and Low Point it will be easy to identify them.

  1. Select the sparklines you want to change. If they are grouped, you only need to select one of them.
  2. Locate the Show group in the Design tab.
  3. Hover over the different check boxes to see a description of each one.
    Hovering over the High Point check boxHovering over the High Point check box
  4. Check each option you want to show. The sparklines will update to show the selected options.
    The updated sparklinesThe updated sparklines

To change the style:

  1. Select the sparklines you want to change.
  2. Locate the Style group in the Design tab.
  3. Click the More drop-down arrow to show all of the available styles.
    Viewing all of the available stylesViewing all of the available styles
  4. Select the desired style.
    Selecting a sparkline styleSelecting a sparkline style
  5. The sparklines will update to show the selected style.
    The updated sparklinesThe new sparkline style

To change the sparkline type:

  1. Select the sparklines you want to change.
  2. Locate the Type group in the Design tab.
  3. Select the desired type (Column, for example).
    Converting the sparkline type to ColumnConverting the sparkline type to Column
  4. The sparkline will update to reflect the new type.
    The converted sparklinesThe converted sparklines

Some sparkline types will be better or worse for certain types of data. For example, Win/Loss is best suited for data where there may be positive and negative values (such as net earnings).