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:
|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".|
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: