Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. function CreateChart() {
  2. var spreadsheet = SpreadsheetApp.getActive();
  3. spreadsheet.getRangeList(['A1:C1', 'A2:C4']).activate();
  4. var sheet = spreadsheet.getActiveSheet();
  5. var chart = sheet.newChart()
  6. .asLineChart()
  7. .addRange(spreadsheet.getRange('A1:C1'))
  8. .addRange(spreadsheet.getRange('A2:C4'))
  9. .setMergeStrategy(Charts.ChartMergeStrategy.MERGE_ROWS)
  10. .setTransposeRowsAndColumns(true)
  11. .setNumHeaders(-1)
  12. .setHiddenDimensionStrategy(Charts.ChartHiddenDimensionStrategy.IGNORE_BOTH)
  13. .setOption('vAxes.0.gridlines.count', 10)
  14. .useLogScale()
  15. .setOption('height', 271)
  16. .setOption('width', 439)
  17. .setPosition(1, 6, 76, 16)
  18. .build();
  19. sheet.insertChart(chart);
  20. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement