[]
This function returns a data set used for representing a histogram sparkline.
HISTOGRAMSPARKLINE(dataRange, [continuous, paintLabel, scale, barWidth, barColor, labelFontStyle, labelColor, edgeColor])
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