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:

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




Error.

User does not have sufficient privileges to access this Content
Learn More