你可以通过VBARSPARKLINE函数创建一个竖向柱状函数迷你图。
如上图所示，在竖向柱状函数迷你图中：
正值，条状图会从单元格的下边开始；负值，条状图会从单元格的上边开始。
如果这个值大于100% 或者小于 -100%，将会出现一个箭头。
VBARSPARKLINE函数有以下参数：
Option | Description |
value | A number or reference that represents the length of the bar. The value should be between 100% and -100%. |
colorScheme | A string that represents the color of the bar. This setting is optional. The default value is "grey". |
The vbar sparkline formula has the following format:
=VBARSPARKLINE(value, colorScheme)
Using Code
The following code creates vbar sparklines.
JavaScript | Copy Code |
activeSheet.setValue(0, 0, .4);activeSheet.setValue(1, 0, -.4);activeSheet.setValue(2, 0, 2);activeSheet.setFormula(0, 1, '=VBARSPARKLINE(A1,"blue")');activeSheet.setFormula(1, 1, '=VBARSPARKLINE(A2,"blue")');activeSheet.setFormula(2, 1, '=VBARSPARKLINE(A3,"blue")');activeSheet.setRowHeight(0, 50.0);activeSheet.setRowHeight(1, 50.0);activeSheet.setRowHeight(2, 50.0); |
|
See Also
setFormula Method