Skip to main content

Spread Sparklines

Spread sparklines are compact charts that display how data points are distributed along a scale. Each mark or dot represents a single value along a horizontal (or vertical) axis. These sparklines help reveal concentration, gaps, and variability in a dataset.

When to use spread sparklines​

  • Visualizing data variation: Show how values are distributed across a range to identify trends, outliers, or gaps.
  • Comparing high and low ranges: Highlight the spread between minimum and maximum values to assess consistency or volatility.
  • Tracking performance by category: Display value distributions across groups or time periods in a compact format.

Create a spread sparkline​

  1. On the Insert tab, select Sparklines.
  2. Under Scatter Sparkline, select Insert Spread Sparkline. The Create Sparklines dialog opens.
  3. In Data Range, select a continuous range of cells (in the same row or column).
  4. In Location Range, select the cell where the sparkline will appear.
  5. Click Ok. The sparkline is inserted into the selected cell.

Edit a spread sparkline​

  1. Select the spread sparkline in your workbook.
  2. On the Sparkline tab, select Settings. The SpreadSparkline Setting dialog opens.
  3. Set the parameters, then click Ok.
  4. Copy and paste the sparkline cell to duplicate the configuration in another location, as needed.

Spread sparkline parameters​

The spread sparkline formula supports the following format:

=SPREADSPARKLINE(points, showAverage?, scaleStart?, scaleEnd?, style?, colorScheme?, vertical?)
ParameterDescription
PointsDefine the range of cells containing values, such as A1:A4. Invalid or empty values are treated as 0.
StyleDefine the visual style of the sparkline:

  • Stacked – Draw lines from center outward.
  • Spread – Draw dots from center outward.
  • Jitter – Place dots randomly.
  • Poles – Draw lines across the full width (default).
  • StackedDots – Draw dots from one side to another.
  • Stripe – Draw uniform-length lines.
ScaleStart(Optional) Set the minimum boundary, such as 8 or A7. Default: minimum value in the dataset.
ScaleEnd(Optional) Set the maximum boundary, such as 9 or A8. Default: maximum value in the dataset.
ColorSchemeSet the color of the sparkline marks. Default: #646464.
ShowAverage(Optional) Display a marker for the average value.
Vertical(Optional) Display the sparkline vertically.