Skip to main content

HBARSPARKLINE

The sparkline starts at the left of the cell for positive values and right of the cell for negative values. If the value is greater than 100% or smaller than -100%, an arrow is displayed.

The hbar sparkline has the following options:

OptionDescription
valueA number or reference that represents the length of the bar. The value should be between 100% and -100%.
colorSchemeA string that represents the color of the bar. This setting is optional. The default value is "grey".

Sample Usage

In order to use the HBARSPARKLINE formula, start with your edited Excellentable:

Then type in the HBARSPARKLINE formula in the area you would like to display the outcome:

By adding the values you would like to calculate the HBARSPARKLINE formula for, Excellentable will generate the outcome:


A
B
1
Formula
Value
2
0.44
3
-0.4
4
HBARSPARKLINE(A2,"red")
#NAME?
5
HBARSPARKLINE(A3,"green")
#NAME?

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.