The sparkline starts at the bottom of the cell for positive values and the top of the cell for negative values. If the value is greater than 100% or smaller than -100%, an arrow is displayed.
The vbar 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 VBARSPARKLINE formula, start with your edited Excellentable:
Then type in the VBARSPARKLINE formula in the area you would like to display the outcome:
By adding the values you would like to calculate the VBARSPARKLINE formula for, Excellentable will generate the outcome: