Skip to main content


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:

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:


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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.