- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
-
Functions A to C
- ABS
- ACCRINT
- ACCRINTM
- ACOS
- ACOSH
- ACOT
- ACOTH
- ADDRESS
- AGGREGATE
- AMORDEGRC
- AMORLINC
- ANCHORARRAY
- AND
- ARABIC
- AREAS
- AREASPARKLINE
- ARRAYTOTEXT
- ASC
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BAHTTEXT
- BASE
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BETA.DIST
- BETA.INV
- BETADIST
- BETAINV
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BINOM.DIST
- BINOM.DIST.RANGE
- BINOM.INV
- BINOMDIST
- BITAND
- BITLSHIFT
- BITOR
- BITRSHIFT
- BITXOR
- BOXPLOTSPARKLINE
- BULLETSPARKLINE
- BYCOL
- BYROW
- CASCADESPARKLINE
- CEILING
- CEILING.MATH
- CEILING.PRECISE
- CELL
- CHAR
- CHIDIST
- CHIINV
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CHISQ.TEST
- CHITEST
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- CLEAN
- CODE
- COLUMN
- COLUMNS
- COLUMNSPARKLINE
- COMBIN
- COMBINA
- COMPLEX
- CONCAT
- CONCATENATE
- CONFIDENCE
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONVERT
- CORREL
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- COVAR
- COVARIANCE.P
- COVARIANCE.S
- CRITBINOM
- CSC
- CSCH
- CUMIPMT
- CUMPRINC
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
- Functions T to Z
-
Functions A to C
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
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. |
Data Types
Returns sparkline.
Example
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)');