- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
-
Sparkline Functions
- AREASPARKLINE
- BOXPLOTSPARKLINE
-
BULLETSPARKLINE
- CASCADESPARKLINE
- COLUMNSPARKLINE
- GAUGEKPISPARKLINE
- HBARSPARKLINE
- HISTOGRAMSPARKLINE
- IMAGE
- LINESPARKLINE
- MONTHSPARKLINE
- PARETOSPARKLINE
- PIESPARKLINE
- RANGEBLOCKSPARKLINE
- SCATTERSPARKLINE
- SPREADSPARKLINE
- STACKEDSPARKLINE
- VARISPARKLINE
- VBARSPARKLINE
- WINLOSSSPARKLINE
- YEARSPARKLINE
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
BULLETSPARKLINE
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
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)');