Axis scale in google charts (from google spreadsheets)

google-docs google-sheets google-visualization
zacheusz picture zacheusz · Jul 25, 2011 · Viewed 92k times · Source

I've generated chart form google spreadsheets. In my report for horizontal axis I have values: 1 ,2 ,3 ,4 ,5 ,10 ,20 ,30 ,40 ,50 ,100 ,200 ,300 ,400 ,500 ,600 ,700 ,800 ,900 ,1000. Chart interprets them as a labels, not a number:

enter image description here

So the distance between 1 and 4 is the same as between 20 and 50. How to change it? (Maybe I have to transform input data - how?)

Here is my spreadsheet with input data, query and the chart.

I want to embed it in a webpage with such script:

    <script type="text/javascript" src="//ajax.googleapis.com/ajax/static/modules/gviz/1.0/chart.js"> 
{"dataSourceUrl":"//spreadsheets.google.com/spreadsheet/tq?key=0AtdHElsKyNw9dERVZ1lZRVNmYmRqSlVVbWszd3BVdGc&transpose=0&headers=1&range=F1%3AI21&gid=0&pub=1",
"options":{
    "reverseCategories":false,"titleX":"thousand objects","backgroundColor":"#FFFFFF","pointSize":0,
    "width":510,
    "vAxis":{"format":"#0.##########"},
    "smoothLine":true,"lineWidth":2,"logScale":false,"hasLabelsColumn":true,
    "hAxis":{"maxAlternation":1},
    "vAxes":[{"min":null,"title":"ms","max":null,"maxValue":null}],
    "title":"Performance of exposing previous value in AspectJ set-pointcut",
    "height":400,"interpolateNulls":false,"legend":"bottom","reverseAxis":false
},
"state":{},
"chartType":"LineChart",
"chartName":"Performance test"
} </script>

Answer

Josh Koenig picture Josh Koenig · Jan 25, 2013

You can do this by configuring the vertical axis in the Advanced Settings area.

enter image description here

I just did and it worked like a charm. :)

Related questions

Count number of cells with any value (string or number) in a column in Google Docs Spreadsheet

I have several columns in Google Spreadsheet. I would like to count how many cells have a value (number or string) and display that number at the top of the column. For example: Hello World 123 Some string The above column …

Read More
How to define global variable in Google Apps Script

I see most examples from Google is they use only functions in a single giant script. e.g. https://developers.google.com/apps-script/quickstart/macros But in our style, we usually write all functions under a single namespace, such as …

Read More
Get first item from Split()

I use the SPLIT function to split a string which looks something like 1.23/1.15. Right now it yields two cells, as it should. But how do I get a certain element from the result? I would like to do something like …

Read More