Setting minimum value in Google Spreadsheet Chart programmatically

Question

I'm trying to set a fixed minimum value in a chart created programmatically in my Google Spreadsheet. The goal is that I want to create several graphs with the same limits even though their data is wildly different.

For the purposes of this example, I have the following data in my spreadsheet:

Date    Number
05.02.2017  125
06.02.2017  150
16.02.2017  21
05.02.2018  -5.333333333
06.02.2018  -57.33333333
16.02.2018  -109.3333333
05.02.2019  -161.3333333

and the following script:

function update() {
  var title = 'Last updated ' + new Date().toString();

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];

  var chart = sheet.newChart()
     .setChartType(Charts.ChartType.AREA)
     .addRange(sheet.getRange("A1:B8"))
     .setPosition(5, 5, 0, 0)
     .setOption('title', title)
     .setOption('vAxis.minValue', -5000)
     .setOption('vAxis.viewWindow.min', -5000)
     .build();

  sheet.insertChart(chart);
}

... so, in other words, I'm trying to set the minimum value, to -5000. Setting vAxis.minValue and/or vAxis.viewWindow.min accomplishes exactly nothing. (Yes, I know that my code will create a new one every time update() is called, but that's not the point here.)

There is a minimum/maximum value option when the chart is edited. The values there are blank:

What do I do to change these values programmatically?

Full link to sheet here: https://docs.google.com/spreadsheets/d/1dKBG8Nx5mypD2YAfOTCzo2cvIX6C7R18SCIsNB5FsT0/edit?usp=sharing

Setting minimum value in Google Spreadsheet Chart programmatically

1 Answers