月份迷你图

您可以使用 MonthSparkline 公式和单元格值来创建月份迷你图。

一个月的迷你图有6 * 7平方。水平方向是一个月中的星期（从左到右，从1日到6日）。垂直方向是工作日（从上到下，从星期日到星期六）。

月份迷你图公式具有以下选项：

选项	描述
year	类型为数字，表示年份，例如2017。
month	类型为数字，表示月份，月份从1开始（Jan = 1）。
dataRange	类型为引用，所引用的单元格第一列为日期，第二列为数字，比如 "A1:B400"。
emptyColor	类型为颜色字符串，用这种颜色填充没有值或者值为0的日期，比如 "lightgray"。
startColor	类型为颜色字符串，用这种颜色填充值最小的日期，比如 "lightgreen"。
middleColor	类型为颜色字符串，用这种颜色填充值为最大值和最小值平均值的日期，比如 "green"。
endColor	类型为颜色字符串，用这种颜色填充值最大的日期，比如 "darkgreen"。
colorRange	类型为引用，所引用的单元格数据为颜色字符串。

月份迷你图公式具有以下格式：

=MONTHSPARKLINE(year, month, dataRange, emptyColor, startColor, middleColor, endColor)

=MONTHSPARKLINE(year, month, dataRange, colorRange)

示例代码

本示例创建一个月迷你图。

for (var rowIndex = 1; rowIndex <= 31; rowIndex++) {
            activeSheet.setValue(rowIndex, 0, new Date(2017, 0, rowIndex));
}
activeSheet.setValue(1,1,10, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(2,1,5, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(3,1,98, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(4,1,50, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(5,1,75, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(6,1,25, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(7,1,65, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(8,1,30, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(9,1,22, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(10,1,82, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(11,1,89, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(12,1,43, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(13,1,15, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(14,1,12, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(15,1,63, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(16,1,54, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(17,1,77, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(18,1,39, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(19,1,20, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(20,1,65, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(21,1,20, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(22,1,20, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(23,1,20, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(24,1,18, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(25,1,20, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(26,1,42, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(27,1,21, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(28,1,20, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(29,1,99, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(30,1,20, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setValue(31,1,9, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setFormula(6, 2, '=MONTHSPARKLINE(2017,1,A2:B32,"yellow","lightgreen","green","darkgreen")');
spread.resumePaint();