- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
-
Functions T to Z
- T
- T.DIST
- T.DIST.2T
- T.DIST.RT
- T.INV
- T.INV.2T
- T.TEST
- TAKE
- TAN
- TANH
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- TDIST
- TEXT
- TEXTAFTER
- TEXTBEFORE
- TEXTJOIN
- TEXTSPLIT
- TIME
- TIMEVALUE
- TINV
- TOCOL
- TODAY
- TOROW
- TRANSPOSE
- TREND
- TRIM
- TRIMMEAN
- TRUE
- TRUNC
- TTEST
- TYPE
- UNICHAR
- UNICODE
- UNIQUE
- UPPER
- USDOLLAR
- VALUE
- VALUETOTEXT
- VAR
- VAR.P
- VAR.S
- VARA
- VARISPARKLINE
- VARP
- VARPA
- VBARSPARKLINE
- VDB
- VLOOKUP
- VSTACK
- WEBSERVICE
- WEEKDAY
- WEEKNUM
- WEIBULL
- WEIBULL.DIST
- WINLOSSSPARKLINE
- WORKDAY
- WORKDAY.INTL
- WRAPCOLS
- WRAPROWS
- XIRR
- XLOOKUP
- XMATCH
- XNPV
- XOR
- YEAR
- YEARFRAC
- YEARSPARKLINE
- YIELD
- YIELDDISC
- YIELDMAT
- Z.TEST
- ZTEST
VBARSPARKLINE
This function returns a data set used for representing a Vbar sparkline.
Syntax
VBARSPARKLINE(value, [colorScheme, axisVisible, barWidth])
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| value | A number or reference that represents the length of the bar. The value should be between 100% and -100%. |
| colorScheme | (Optional) A string that represents the color of the bar. The default value is "grey". |
| axisVisible | (Optional) A Boolean value that indicates whether or not to show the axis. The default value is true. |
| barWidth | (Optional) A number greater than 0 and less than or equal to 1, which indicates the percentage of bar width according to the cell width. |
Data Types
Returns sparkline.
Example
activeSheet.setFormula(0, 1, '=VBARSPARKLINE(A1,"red", FALSE, 0.8)');