How may I scale the vertical axis of a coluim graph from 0 to 100 even if
my datas are between 50 and 60.
My code is :
var sheet = SpreadsheetApp.getActiveSheet();
var chart = sheet.newChart()
.setPosition(9, 1, 0, 0)
.setChartType(Charts.ChartType.COLUMN)
.addRange(sheet.getRange("A2:C7"))
.setOption('width', 850)
.setOption('height',500)
.build();
sheet.insertChart(chart);
I have tried :
.setOption('vAxis.maxValue',100)
.setOption('vAxis.minValue',0)
and also :
.setRange(0,100)
But it doesn't work.
--
--------------------------------------------------------------------------------------------
This e-mail transmission (message and any attached files) may contain
information that is proprietary, privileged and/or confidential to Veolia
Environnement and/or its affiliates and is intended exclusively for the
person(s) to whom it is addressed. If you are not the intended recipient,
please notify the sender by return e-mail and delete all copies of this
e-mail, including all attachments. Unless expressly authorized, any use,
disclosure, publication, retransmission or dissemination of this e-mail
and/or of its attachments is strictly prohibited.
Ce message electronique et ses fichiers attaches sont strictement
confidentiels et peuvent contenir des elements dont Veolia Environnement
et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc
destines a l'usage de leurs seuls destinataires. Si vous avez recu ce
message par erreur, merci de le retourner a son emetteur et de le detruire
ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la
publication, la distribution, ou la reproduction non expressement
autorisees de ce message et de ses pieces attachees sont interdites.
--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/4094c8a0-4ff7-4808-af2e-ec7375bae82d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
