# VARISPARKLINE

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 variance sparkline.

## Syntax

VARISPARKLINE(*variance, [reference, mini, maxi, mark, tickunit, legend, colorPositive, colorNegative, vertical*])

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *variance* | A number or reference that represents the bar length, such as 2 or "A1". |
| *reference* | (Optional) A number or reference that represents the location of the reference line, such as 0 or "A2". The default value is 0. |
| *mini* | (Optional) A number or reference that represents the minimum value of the sparkline, such as -5 or "A3". The default value is -1. |
| *maxi* | (Optional) A number or reference that represents the maximum value of the sparkline, such as 5 or "A4". The default value is 1. |
| *mark* | (Optional) A number or reference that represents the position of the mark line, such as 3 or "A5". |
| *tickunit* | (Optional) A number or reference that represents a tick unit, such as 1 or "A6". The default value is 0. |
| *legend* | (Optional) A boolean that represents whether to display the text. The default value is false. |
| *colorPositive* | (Optional) A string that represents the color scheme for variance and is larger than reference. The default value is "green". |
| *colorNegative* | (Optional) A string that represents the color scheme for variance and is smaller than reference. The default value is "red". |
| *vertical* | (Optional) A boolean that represents whether to display the sparkline vertically. The default value is false. |

## Data Types

Returns sparkline.

## Example

```csharp
activeSheet.setFormula(0,1,'=VARISPARKLINE(3,0,-5,5,0.5,0.5,TRUE,"green","red",FALSE)');
```