Column chart

[Claude GUENIFFEY]

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.

[Bansi Shah]

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