Skip to main content

Spread Sparklines

To create spread sparklines in the workbook:

  1. Click Insert from the menu.

  2. Click Sparkline and select the spread sparkline under Scatter Sparkline from the list.

  3. In the Create Sparklines dialog box:

    1. Select a range of cells in the same row or the same column.

    2. Select the cell where the sparkline will appear.

    3. Click OK.

  4. The sparkline is displayed in the cell. You can now customize the sparkline by clicking Design from the menu and selecting Settings.

  5. Set the parameters as described below and click OK.

  6. Copy and paste the cell as needed to finalize your spread sparklines.

Spread Sparkline ParameterDescription
PointsReference that represents the range of cells that contains the values, such as "A1:A10".
Style

Number reference for the style of the spread sparkline:

  1. Stacked - line from center to two sides
  2. Spread - dot from center to two sides
  3. Jitter - dot whose location is random
  4. Poles - line from one side to another side (default)
  5. StackedDots - dot from one side to another side
  6. Stripe - line whose length is equal
ScaleStart(Optional) Number or reference that represents the minimum boundary of the sparkline; the default value is the minimum of all values.
ScaleEnd(Optional) Number or reference that represents the maximum boundary of the sparkline; the default value is the maximum of all values.
ColorSchemeString that represents the color of the sparkline's box; the default value is "#646464".
ShowAverage(Optional) Boolean that represents whether to display the average. The default value is false.
Vertical(Optional) Boolean that represents whether to display the sparkline vertically. The default value is false.

The spread sparkline formula has the following syntax:

=SPREADSPARKLINE(points, showAverage?, scaleStart?, scaleEnd?, style?, colorScheme?, vertical?)