...
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". |
...
类型为数字或者引用，表示这个条的长度，比如 0.3 或者 "A1"。 | |
colorScheme | （可选参数）类型为颜色字符串，表示条的填充色的字符串；默认值是 "gray" |
你可以通过竖向柱状函数创建一个竖向柱状函数迷你图。比如
=VBARSPARKLINE(value, colorScheme) Using Code
The following code creates vbar sparklines.
...
JavaScript
...
Copy Code
下面代码展示了如何创建竖向柱状函数迷你图
| Code Block | ||||
|---|---|---|---|---|
| ||||
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