# VBARSPARKLINE

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns a data set used for representing a Vbar sparkline.

## Syntax

VBARSPARKLINE(*value, [colorScheme, axisVisible, barWidth*])

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *value* | A number or reference that represents the length of the bar. The value should be between 100% and -100%. |
| *colorScheme* | (Optional) A string that represents the color of the bar. The default value is "grey". |
| *axisVisible* | (Optional) A Boolean value that indicates whether or not to show the axis. The default value is true. |
| *barWidth* | (Optional) A number greater than 0 and less than or equal to 1, which indicates the percentage of bar width according to the cell width. |

## Data Types

Returns sparkline.

## Example

```csharp
activeSheet.setFormula(0, 1, '=VBARSPARKLINE(A1,"red", FALSE, 0.8)');
```