Sparklines

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

Modifying sparklines

It's easy to change the way sparklines appear in your worksheet. Excel allows you to customize a sparkline's markers, style, type, and more.

To display markers:

Certain points on a 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 might be difficult to tell which values are the highest and lowest points. Showing the high point and low point will make them easier to identify.

  1. Select the sparkline(s) you want to change. If they are grouped in adjacent cells, you'll only need to click on one sparkline to select them all.


    Screenshot of Excel 2013Selecting a group of sparklines
  2. From the Design tab, select the desired option(s) from the Show group. In our example, we'll select High Point and Low Point.
    Screenshot of Excel 2013Showing the High and Low points on the sparklines
  3. The sparkline(s) will update to show the selected markers.
    Screenshot of Excel 2013The sparklines with high and low markers

To change the sparkline style:

  1. Select the sparkline(s) you want to change.
  2. From the Design tab, click the More drop-down arrow.
    Screenshot of Excel 2013Clicking the More drop-down arrow
  3. Choose the desired style from the drop-down menu.
    Screenshot of Excel 2013Choosing a sparkline style
  4. The sparkline(s) will update to show the selected style.
    Screenshot of Excel 2013The new sparkline style

To change the sparkline type:

  1. Select the sparkline(s) you want to change.
  2. From the Design tab, select the desired Sparkline type. In our example, we'll select Column.
    Screenshot of Excel 2013Choosing a new sparkline type
  3. The sparkline(s) will update to reflect the new type.
    Screenshot of Excel 2013The new sparkline type

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