# MONTHSPARKLINE

## 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

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

## Examples

```JavaScript
activeSheet.setFormula(6, 2, '=MONTHSPARKLINE(2017,1,A2:B32,"yellow","lightgreen","green","darkgreen")');
```