[visualization-api] json data treated differently in-line than when ajax-fetched

2013-05-31 Thread Galten FS Gymnastik
Hi, I am playing around with a simple line-chart that I cannot make work correctly when fetching a json-string from my server. When I put the string returned by the server in-line in the html-page, everything is fine. I have tried all (I think) combinations of string-delimiters (none, , and ')

[visualization-api] Percentage around slices in google pie chart

2013-05-31 Thread Ashu Bhatia
Hello, Is it possible to show percentage around slices in google pie chart. Thanx -- 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

[visualization-api] Re: How do I select the last x rows of a Google preadsheet

2013-05-31 Thread mikesearchstar
Your a Star! thank you On Thursday, 30 May 2013 19:45:57 UTC+1, mikesea...@gmail.com wrote: Hi am trying to display the data of a Google Spreadsheet in a table with the below code that I have pieced together from the tutorials. The Google Spreadsheet is updated every day and I only want

[visualization-api] Min/Max/Avg Bar chart

2013-05-31 Thread Christian Lipp
Hello! I would like to ask if it is possible to display a series of Min/Max/Avg values as a bar chart, in which - Min and Max values are stacked - Avg is displayed as a vertical line inside the bar I have a similar question on stackoverflow with pictures so that it is easier to understand me,

[visualization-api] Interval role i-lines are not displayed in Google line chart

2013-05-31 Thread A. Farber
Hello, I am trying to add min and max limits to a Google chart, which I generate using a Perl script from CSV data - by using the interval rolehttps://developers.google.com/chart/interactive/docs/rolesfor these 2 values. Unfortunately the I-lines are not displayed at my line chart, even

[visualization-api] Re: json data treated differently in-line than when ajax-fetched

2013-05-31 Thread asgallant
Replace the alert(jsonData); with console.log(jsonData); open the page in Chrome and view the developer's console (ctrl+shift+j to open). Post whatever is printed there here. On Friday, May 31, 2013 2:17:20 AM UTC-4, Galten FS Gymnastik wrote: Hi, I am playing around with a simple

[visualization-api] Re: Percentage around slices in google pie chart

2013-05-31 Thread asgallant
If you set the pieSliceText option to percentage, it will label your slices with percents. On Friday, May 31, 2013 2:21:01 AM UTC-4, Ashu Bhatia wrote: Hello, Is it possible to show percentage around slices in google pie chart. Thanx -- You received this message because you are

[visualization-api] Re: Min/Max/Avg Bar chart

2013-05-31 Thread asgallant
Sorry, there is nothing in the API that can do this for you. It might be possible to achieve a similar effect using a ComboChart with columns instead of a BarChart, but that changes the orientation of the chart. On Friday, May 31, 2013 5:17:40 AM UTC-4, Christian Lipp wrote: Hello! I would

[visualization-api] Re: Interval role i-lines are not displayed in Google line chart

2013-05-31 Thread asgallant
The problem is that you have your data and interval columns backwards - the data column has to come immediately before the interval columns. Switch those around and it should work. Also, you should input all your numbers as numbers, not strings, as inputting them as strings can cause problems

Re: [visualization-api] Re: Interval role i-lines are not displayed in Google line chart

2013-05-31 Thread Alexander Farber
Thank you, yes, switching the columns has helped me and now in fact I'm struggling with the quotes: http://stackoverflow.com/questions/16859776/how-to-avoid-putting-quotes-around-numbers-with-perl-json-module It seems to me that it is a bug in Google charts: why do they misinterpret my numeric

[visualization-api] Display data - Column Charts

2013-05-31 Thread Olivier Doutriaux
Hi, Are there still no way to display the data value at the top of the column in Column Chart? Thank's in advance. -- 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,

Re: [visualization-api] Re: Interval role i-lines are not displayed in Google line chart

2013-05-31 Thread asgallant
Most charts don't have a problem with it, but there are some that do. It is something the visualization team could certainly correct for, but technically you are breaking the specifications by inputting the numbers as strings. As the stockoverflow post says, you can fix the problem by using

[visualization-api] Re: Display data - Column Charts

2013-05-31 Thread asgallant
I wrote a hack that uses a ComboChart to get around the problem: http://jsfiddle.net/asgallant/QjQNX/ On Friday, May 31, 2013 10:40:54 AM UTC-4, Olivier Doutriaux wrote: Hi, Are there still no way to display the data value at the top of the column in Column Chart? Thank's in advance.

Re: [visualization-api] Re: Interval role i-lines are not displayed in Google line chart

2013-05-31 Thread Alexander Farber
Yes, thank you, but this still doesn't work for float numbers :-( On Fri, May 31, 2013 at 4:52 PM, asgallant drew_gall...@abtassoc.com wrote: Most charts don't have a problem with it, but there are some that do. It is something the visualization team could certainly correct for, but

[visualization-api] Re: Display data - Column Charts

2013-05-31 Thread Olivier Doutriaux
Thank's a lot. But I forgot to mention i use a chart with two colums like this: https://lh5.googleusercontent.com/-TSWpKHsuR20/UajAtQWjq2I/ABY/TsQlG2s9b60/s1600/Capture.PNG Can I write the value on the top of each column ? I tried and the value is display in the middle on the 2 columns

[visualization-api] Re: Display data - Column Charts

2013-05-31 Thread Olivier Doutriaux
Thank's a lot but I forgot to mention i use two columns like this: https://lh6.googleusercontent.com/-haU_LNQp41k/UajBQoLTrDI/ABg/cQ3l87ljong/s1600/Capture.PNG Can i display the value on the top of each column? i tried and the value is just in the middle of the two columns. Le vendredi

Re: [visualization-api] Re: Interval role i-lines are not displayed in Google line chart

2013-05-31 Thread asgallant
There is a javascript solution: for (var i = 0; i x.getNumberOfColumns(); i++) { if (x.getColumnType() == 'number') { for (var j = 0; j x.getNumberOfRows(); j++) { x.setValue(j, i, x.getValue(j, i) * 1); x.setFormattedValue(j, i, '' + x.getValue(j, i));

[visualization-api] Re: Display data - Column Charts

2013-05-31 Thread asgallant
No, this hack does not work with multiple columns. It is conceivable that you could make it work if the columns were stacked, but not side-by-side. On Friday, May 31, 2013 11:27:33 AM UTC-4, Olivier Doutriaux wrote: Thank's a lot but I forgot to mention i use two columns like this:

[visualization-api] Re: Display data - Column Charts

2013-05-31 Thread Olivier Doutriaux
Ok, at worst i can display the value in the same color that the column like this: https://lh4.googleusercontent.com/-wXOSY2cXsXg/UajEA44cu8I/ABw/cO8t4mbuo6w/s1600/Capture.PNG Thank you Le vendredi 31 mai 2013 17:36:26 UTC+2, asgallant a écrit : No, this hack does not work with

Re: [visualization-api] Re: Interval role i-lines are not displayed in Google line chart

2013-05-31 Thread Alexander Farber
Thank you! On Fri, May 31, 2013 at 5:34 PM, asgallant drew_gall...@abtassoc.com wrote: There is a javascript solution: for (var i = 0; i x.getNumberOfColumns(); i++) { if (x.getColumnType() == 'number') { for (var j = 0; j x.getNumberOfRows(); j++) { x.setValue(j,

[visualization-api] Re: json data treated differently in-line than when ajax-fetched

2013-05-31 Thread Galten FS Gymnastik
Hi. Thanks for the quick reply. The console shows: {cols: [{label:Time, type:date},{label:Dataseries 0, type:number},{label:Dataseries 1, type:number}], rows: [{c:[{v:Date(2013,05,29,06,29,00), f:2013-05-29 06:29:00}, {v:186,f:Value=186},{v:null, f:null}]}, {c:[{v:Date(2013,05,29,06,29,00),