月スパークラインの作成

MonthSparklineの数式とセル値を使用して、月スパークラインを作成できます。

月スパークラインは、6*7個の四角形で構成されます。水平方向は月の週数を（左から右に向かって第1週～第6週）、垂直方向は曜日を（上から下に向かって日曜日～月曜日）それぞれ表します。

月スパークラインの数式には、次のオプションを使用できます。

オプション	説明
year	4桁の年（「2017」など）
month	月の番号（「3」など）。1を基準とした番号です（1月 = 1）。
dataRange	1列目が日付を、2列目が数値を表すセル範囲の参照（「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)

コードの使用

次のサンプルコードは、月スパークラインを作成します。

JavaScript	コードのコピー
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();

JavaScript

コードのコピー

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();