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:
Option | Description |
value | A number or reference that represents the length of the bar. The value should be between 100% and -100%. |
colorScheme | A 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
|
||
2
|
||
3
|
||
4
|
||
5
|