# MONTHSPARKLINE

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

## Syntax

MONTHSPARKLINE(*year, month, dataRange, emptyColor, startColor, middleColor, endColor*)
MONTHSPARKLINE(*year, month, dataRange, colorRange*)

## Arguments

This function has the following arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *year* | A full year number, such as 2017. |
| *month* | A month number, such as 3. The month is 1-based (Jan = 1). |
| *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(6, 2, '=MONTHSPARKLINE(2017,1,A2:B32,"yellow","lightgreen","green","darkgreen")');
```