This function returns a data set used for representing a bullet sparkline.
BULLETSPARKLINE(measure, target, maxi, [good, bad, forecast, tickUnit, colorScheme, vertical, measureColor, targetColor, maxiColor, goodColor, badColor, forecastColor, allowMeasureOverMaxi, barSize])
This function has the following 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. |
Returns sparkline.
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)');
