HISTOGRAMSPARKLINE

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

Syntax

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")');