# YEARSPARKLINE

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

## Syntax

YEARSPARKLINE(*year, dataRange, emptyColor, startColor, middleColor, endColor*)
YEARSPARKLINE(*year, dataRange, colorRange*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *year* | A full year number, such as 2017. |
| *dataRange* | A reference that represents a range where the first column is a date and the second column is a number, such as "A1:B400". |
| *emptyColor* | A color string that represents days with no value or zero value, such as "lightgray". |
| *startColor* | A color string that represents the minimum day value, such as "lightgreen". |
| *middleColor* | A color string that represents the day with the average minimum and maximum value, such as "green". |
| *endColor* | A color string that represents the day with the maximum value, such as "darkgreen". |
| *colorRange* | A reference that represents a range where the data is a color string. |

## Data Types

Returns sparkline.

## Example

```csharp
activeSheet.setFormula(0, 3, '=YearSparkline(2017, A2:B' + rowCount + ', C2:C' + rowCount +')');
```