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:
|
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 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:
There were errors rendering macro:
- An unknown error occurred.