# SPREADSPARKLINE

## Content

This function returns a data set used for representing a spread sparkline.

## Syntax

`SPREADSPARKLINE(points, [showAverage, scaleStart, scaleEnd, style, colorScheme, vertical])`

## Arguments

| Argument | Description |
| -------- | ----------- |
| *points* | A reference that represents a range of cells that contains the values, such as "A1:A10". |
| *showAverage* | (Optional) A boolean that represents whether to show the average. The default value is false. |
| *scaleStart* | (Optional) A number that represents the minimum boundary of the sparkline. The default value is the minimum of all values. |
| *scaleEnd* | (Optional) A number that represents the maximum boundary of the sparkline. The default value is the maximum of all values. |
| *style* | (Optional) A number that references the style of the Spread sparkline. The default value is 4 (poles). |
| *colorScheme* | (Optional) A string that represents the color of the sparkline. The default value is "#646464". |
| *vertical* | (Optional) A boolean that represents whether to display the sparkline vertically. The default value is false. |

## Data Types

Returns sparkline.

## Examples

```JavaScript
activeSheet.setFormula(2, 2, '=SPREADSPARKLINE(B3:B20,TRUE,,,4,"green")');
```