# HBARSPARKLINE

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 an Hbar sparkline.

## Syntax

HBARSPARKLINE(*value, [colorScheme, axisVisible, barHeight*])

## Arguments

This function has the following 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 to show the axis. The default value is true. |
| *barHeight* | (Optional) A number greater than 0 and less than or equal to 1, which indicates the percentage of bar height according to the cell height. |

## Data Types

Returns sparkline.

## Example

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