質問編集履歴
2
誤字修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -114,7 +114,7 @@
|
|
|
114
114
|
.addToUi();
|
|
115
115
|
}
|
|
116
116
|
```
|
|
117
|
-
|
|
117
|
+
|
|
118
118
|
|
|
119
119
|
|
|
120
120
|
上のスクリプトでは、sheet1.getRangeで('A' + firstRow + ':B' + lastRow);
|
1
抜けを修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -58,10 +58,10 @@
|
|
|
58
58
|
|
|
59
59
|
```Google Apps Script
|
|
60
60
|
|
|
61
|
-
function update
|
|
61
|
+
function updateChartRange() {
|
|
62
62
|
const ss = SpreadsheetApp.getActiveSpreadsheet();
|
|
63
63
|
const sheet1 = ss.getSheetByName('シート1');
|
|
64
|
-
const sheet2 = ss.getSheetByName('
|
|
64
|
+
const sheet2 = ss.getSheetByName('シート2');
|
|
65
65
|
const lastRow = sheet1.getLastRow();
|
|
66
66
|
const firstRow = lastRow <= 360 ? 1 : lastRow - 360;
|
|
67
67
|
const range0Add = sheet1.getRange('A' + firstRow + ':B' + lastRow);
|
|
@@ -106,7 +106,14 @@
|
|
|
106
106
|
sheet2.updateChart(chart3);
|
|
107
107
|
|
|
108
108
|
}
|
|
109
|
-
|
|
109
|
+
// ファイルを開いたときにメニューを追加
|
|
110
|
+
function onOpen() {
|
|
111
|
+
SpreadsheetApp.getUi()
|
|
112
|
+
.createMenu('グラフ')
|
|
113
|
+
.addItem('更新', 'updateChartRange')
|
|
114
|
+
.addToUi();
|
|
115
|
+
}
|
|
116
|
+
```
|
|
110
117
|
```
|
|
111
118
|
|
|
112
119
|
|