# BULLETSPARKLINE

## Content

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

## Syntax

`BULLETSPARKLINE(measure, target, maxi, [good, bad, forecast, tickUnit, colorScheme, vertical, measureColor, targetColor, maxiColor, goodColor, badColor, forecastColor, allowMeasureOverMaxi, barSize])`

## Arguments

| Argument | Description |
| -------- | ----------- |
| *measure* | A number or reference that represents the length of the measure bar, such as 5 or "A1". |
| *target* | A number or reference that represents the location of the target line, such as 7 or "A2". |
| *maxi* | A number or reference that represents the maximum value of the sparkline, such as 10 or "A3". |
| *good* | (Optional) A number or reference that represents the length of the good bar, such as 3 or "A4". The default value is 0. |
| *bad* | (Optional) A number or reference that represents the length of the bad bar, such as 1 or "A5". The default value is 0. |
| *forecast* | (Optional) A number or reference that represents the length of the forecast line, such as 8 or "A6". The default value is 0. |
| *tickunit* | (Optional) A number or reference that represents the tick unit, such as 1 or "A7". The default value is 0. |
| *colorScheme* | (Optional) A string that represents a color scheme for displaying the sparkline. The default value is "#A0A0A0". |
| *vertical* | (Optional) A boolean value that indicates whether to display the sparkline vertically. The default value is false. |
| *measureColor* | (Optional) A color string that indicates the color of measure bar. |
| *targetColor* | (Optional) A color string that indicates the color of target line. |
| *maxiColor* | (Optional) A color string that indicates the color of the maxi area. |
| *goodColor* | (Optional) A color string that indicates the color of the good area. |
| *badColor* | (Optional) A color string that indicates the color of the bad area. |
| *forecastColor* | (Optional) A color string that indicates the color of the forecast line. |
| *allowMeasureOverMaxi* | (Optional) A Boolean value that indicates whether the measure can exceed maxi area. The default value of this parameter is false. |
| *barSize* | (Optional) A number value greater than 0 and equal to or less than 1, which indicates the percentage of bar width or height according to the cell width or height. |

## Data Types

Returns sparkline.

## Examples

```JavaScript
activeSheet.setFormula(index, 3, '=BULLETSPARKLINE($C' + (index + 1) + ',$B$10,$B$11,$B$12,$B$13,$B' + (index + 1) + ',1,$B$14,false,$B$15,$B$16,$B$17,$B$18,$B$19,$B$20,$B$21,$B$22)');
```