# HISTOGRAMSPARKLINE

## Content

This function returns a data set used for representing a histogram sparkline.

## Syntax

`HISTOGRAMSPARKLINE(dataRange, [continuous, paintLabel, scale, barWidth, barColor, labelFontStyle, labelColor, edgeColor])`

## Arguments

| Argument | Description |
| -------- | ----------- |
| *dataRange* | Specifies the range of data sources. It supports a range.<br>It supports calc array and calc reference. |
| *continuous* | (Optional) Specifies the type of histogram sparkline.<br>If set to true, the sparkline is a continuous histogram.<br>If set to false, the sparkline is a discrete histogram.<br>The default value is true. |
| *paintLabel* | (Optional) Specifies whether to paint the sparkline data label. The default value is false. |
| *scale* | (Optional) Specifies the bin width. This value is useful when histogram type is continuous. The default value is false. |
| *barWidth* | (Optional) Specifies the bar width. The default value is 1.<br>Bar width = auto calc width \* barWidth<br>Value range is 0 < value ≤ 1. |
| *barColor* | (Optional) Specifies the color of the bar. The default value is '5B9BD5'.<br>Supports CSS color property. |
| *labelFontStyle* | (Optional) Specifies the font style of the data label font. The default value is 9pt Calibri.<br>Supports CSS font property. It supports font-style, font-weight, font-size, font-family. |
| *labelColor* | (Optional) Specifies the font color of data label font. The default is black (#00000).<br>Supports CSS color string. |
| *edgeColor* | (Optional) Specifies the color of the edge. The default value is silver (#C0C0C0).<br>Supports CSS color property. |

## Data Types

Returns sparkline.

## Examples

```JavaScript
sheet1.setFormula(2, 1, 'HISTOGRAMSPARKLINE(Sheet1!B4: B52, true, true, 20, 1, "#DC4463", "bold normal 10pt Calibri", "black")');,clflvmcbxzzzxxx
```