Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function CreateChart() {
- var spreadsheet = SpreadsheetApp.getActive();
- spreadsheet.getRangeList(['A1:C1', 'A2:C4']).activate();
- var sheet = spreadsheet.getActiveSheet();
- var chart = sheet.newChart()
- .asLineChart()
- .addRange(spreadsheet.getRange('A1:C1'))
- .addRange(spreadsheet.getRange('A2:C4'))
- .setMergeStrategy(Charts.ChartMergeStrategy.MERGE_ROWS)
- .setTransposeRowsAndColumns(true)
- .setNumHeaders(-1)
- .setHiddenDimensionStrategy(Charts.ChartHiddenDimensionStrategy.IGNORE_BOTH)
- .setOption('vAxes.0.gridlines.count', 10)
- .useLogScale()
- .setOption('height', 271)
- .setOption('width', 439)
- .setPosition(1, 6, 76, 16)
- .build();
- sheet.insertChart(chart);
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement