This function returns a data set used for representing a histogram sparkline.
HISTOGRAMSPARKLINE(dataRange, [continuous, paintLabel, scale, barWidth, barColor, labelFontStyle, labelColor, edgeColor])
This function has the following arguments:
| Argument | Description |
|---|---|
| dataRange |
Specifies the range of data sources. It supports a range. It supports calc array and calc reference. |
| continuous |
(Optional) Specifies the type of histogram sparkline. If set to true, the sparkline is a continuous histogram. If set to false, the sparkline is a discrete histogram. 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. Bar width = auto calc width * barWidth Value range is 0 < value ≤ 1. |
| barColor |
(Optional) Specifies the color of the bar. The default value is '5B9BD5'. Supports CSS color property. |
| labelFontStyle |
(Optional) Specifies the font style of the data label font. The default value is 9pt Calibri. 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). Supports CSS color string. |
| edgeColor |
(Optional) Specifies the color of the edge. The default value is silver (#C0C0C0). Supports CSS color property. |
Returns sparkline.
sheet1.setFormula(2, 1, 'HISTOGRAMSPARKLINE(Sheet1!B4: B52, true, true, 20, 1, "#DC4463", "bold normal 10pt Calibri", "black")');,clflvmcbxzzzxxx