Hi,
I am having a similar problem with my column charts. Its not concerning
scaling but application of titles on the vAxis.
I have come to find out that there is a bug concerning the vAxis hence the
reason why my titles are not chowing. The same may be affecting your
scaling.
Hope this helps a little.
Bansi
On Monday, September 25, 2017 at 3:58:51 AM UTC+1, Claude GUENIFFEY wrote:
>
> 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.
>
--
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/fea4214a-9c21-4be5-afa2-021c2259fc5b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
