[]

Formula Reference
Contacting Us
Getting Technical Support
Formula Overview
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
  - HARMEAN
  - HBARSPARKLINE
  - HEX2BIN
  - HEX2DEC
  - HEX2OCT
  - HISTOGRAMSPARKLINE
  - HLOOKUP
  - HOUR
  - HSTACK
  - HYPERLINK
  - HYPGEOM.DIST
  - HYPGEOMDIST
  - IF
  - IFERROR
  - IFNA
  - IFS
  - IMABS
  - IMAGE
  - IMAGINARY
  - IMARGUMENT
  - IMCONJUGATE
  - IMCOS
  - IMCOSH
  - IMCOT
  - IMCSC
  - IMCSCH
  - IMDIV
  - IMEXP
  - IMLN
  - IMLOG10
  - IMLOG2
  - IMPOWER
  - IMPRODUCT
  - IMREAL
  - IMSEC
  - IMSECH
  - IMSIN
  - IMSINH
  - IMSQRT
  - IMSUB
  - IMSUM
  - IMTAN
  - INDEX
  - INDIRECT
  - INFO
  - INT
  - INTERCEPT
  - INTRATE
  - IPMT
  - IRR
  - ISBLANK
  - ISERR
  - ISERROR
  - ISEVEN
  - ISFORMULA
  - ISLOGICAL
  - ISNA
  - ISNONTEXT
  - ISNUMBER
  - ISO.CEILING
  - ISODD
  - ISOMITTED
  - ISOWEEKNUM
  - ISPMT
  - ISREF
  - ISTEXT
  - JIS
  - KURT
  - LAMBDA
  - LARGE
  - LCM
  - LEFT
  - LEFTB
  - LEN
  - LENB
  - LET
  - LINEST
  - LINESPARKLINE
  - LN
  - LOG
  - LOG10
  - LOGEST
  - LOGINV
  - LOGNORM.DIST
  - LOGNORM.INV
  - LOGNORMDIST
  - LOOKUP
  - LOWER
- Functions M to Q
- Functions R to S
- Functions T to Z

HBARSPARKLINE

This function returns a data set used for representing an Hbar sparkline.

Syntax

HBARSPARKLINE(value, [colorScheme, axisVisible, barHeight])

Arguments

This function has the following 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 to show the axis. The default value is true.
barHeight	(Optional) A number greater than 0 and less than or equal to 1, which indicates the percentage of bar height according to the cell height.

Data Types

Returns sparkline.

Example

activeSheet.setFormula(0, 1, '=HBARSPARKLINE(A1,"red", FALSE, 0.5)');