[visualization-api] word tree is not workin in IE9 and below
Hello, I am facing problem related to word tree. this chart is not working properly in IE8 and Below. Please help me to solve this problem. it is working properly on Chrome, Firefox and IE9 and above. -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] chart.draw giving error - undefined is not a function
Now the page is not getting loaded at all. Before only the respective div
[where the graph is to be displayed] was not getting loaded.
On Tue, Jan 6, 2015 at 5:43 PM, 'Daniel LaLiberte' via Google Visualization
API google-visualization-api@googlegroups.com wrote:
I should have noticed before that your callback property is wrong. The
value must be a function, not a function call. So you should probably wrap
the drawChart call with a function, like this:
callback: function () { drawChart (arg1, arg2) }
On Jan 5, 2015 11:02 PM, Rashmy Samban rashmysam...@gmail.com wrote:
Now I have script language=javascript type=text/javascript src=
https://www.google.com/jsapi;/script in my template file and
function test() {
new Ajax.Request(
'index.php',
{queue: {position: 'end', scope: 'command'},
method: 'post',
postBody:url,
onComplete: function(response){
google.load(visualization, 1, {callback
: drawChart(arg1, arg2)});
}
}
}
in my js file.
Now the control doesn't reach drawChart function [I have put some alerts
inside drawchart]. No error message, and the div is blank.
The graph is to be displayed inside a page to which headers have already
been sent. Does visualization requires that it be a standalone html file?
On Mon, Jan 5, 2015 at 6:26 PM, 'Daniel LaLiberte' via Google
Visualization API google-visualization-api@googlegroups.com wrote:
It's hard to guess what is going on from the description of your code.
It would be much simpler for both of us if you could point to a page that
shows the problem.
But also try this: there should only be one google.load() and no other
call of drawChart, so remove what you have in your challenge.js.
On Mon, Jan 5, 2015 at 5:42 AM, Rashmy Samban rashmysam...@gmail.com
wrote:
Hi Daniel,
I could confirm that the issue is not related to the chart_div being
generated on the fly. I tried using a static div in the template file, then
also it is showing the same error - undefined is not a function.
Best Regards,
Rashmy
On Mon, Jan 5, 2015 at 11:08 AM, Rashmy Samban rashmysam...@gmail.com
wrote:
Hi Daniel,
Thank you for the prompt response.
Tried the same. The result is the same as before, the 'undefined is
not a function' error.
I have called the foll: in my template file.
script type=text/javascript src=http://www.google.com/jsapi
/script
script language=javascript type=text/javascript
src=include/js/challenge.js/script
Inside challenge.js, I have
google.load(visualization, 1, {packages:[corechart]});
Inside another js file, I have my drawChart function, which is to be
called onComplete of the ajax call.
function test() {
new Ajax.Request(
'index.php',
{queue: {position: 'end', scope: 'command'},
method: 'post',
postBody:url,
onComplete: function(response){
google.load(visualization, 1,
{callback : drawChart(arg1, arg2)});
}
}
}
I have put alerts inside drawChart, and all LOC inside drawChart are
being executed. The chart is not getting displayed inside the div, but the
error. Please note that the html for the chart_div is being dynamically
generated. The ajax call onComplete, sets the innerHTML of a div which
includes the chart_div. Hope this doesn't pose any issues. When I alert
typeof(document.getElementById('chart_div')) inside drawChart, it is an
object, so I guess dynamic generation of chart_div is ok.
Any further suggestions, please?
Best Regards,
Rashmy
On Fri, Jan 2, 2015 at 11:43 PM, 'Daniel LaLiberte' via Google
Visualization API google-visualization-api@googlegroups.com wrote:
Another thing that may be going on is that the google.load() call
should happen as the document is loaded, not after it has finished
loading. If you do the latter, then you have to also give it a callback
function directly, like this:
function loadApi() {
google.load(visualization, 1, {callback : pageLoaded});
}
as documented on https://developers.google.com/loader/
In your case, since you also want to wait for your ajax call to
complete, then one way you can do it is to call this loadApi function in
your onComplete handler, and instead of pageLoaded, put your function
that
calls drawChart.
This asynchronous handling is rather complex. There ought to be a
simpler way to chain multiple asynchronous paths particularly when they
join.
On Fri, Jan 2, 2015 at 4:40 AM, Rashmy Samban rashmysam...@gmail.com
wrote:
Hi Daniel,
Thank you for the reply.
I had tried setOnLoadCallback, but then nothing happens. As per the
program logic, it is the response of the ajax call that is to be passed
to
the callback function. So inside a js function,
function test() {
new Ajax.Request(
'index.php',
{queue: {position: 'end', scope: 'command'},
method: 'post',
postBody:url,
onComplete: function(response){
Re: [visualization-api] chart.draw giving error - undefined is not a function
We would need more clues to offer any help on why the page is not getting
loaded. But you should look in your javascript console first to see if
there are any messages that might help you figure out what went wrong. I
would guess that a syntax error has interrupted all further processing.
On Thu, Jan 8, 2015 at 5:20 AM, Rashmy Samban rashmysam...@gmail.com
wrote:
Now the page is not getting loaded at all. Before only the respective div
[where the graph is to be displayed] was not getting loaded.
On Tue, Jan 6, 2015 at 5:43 PM, 'Daniel LaLiberte' via Google
Visualization API google-visualization-api@googlegroups.com wrote:
I should have noticed before that your callback property is wrong. The
value must be a function, not a function call. So you should probably wrap
the drawChart call with a function, like this:
callback: function () { drawChart (arg1, arg2) }
On Jan 5, 2015 11:02 PM, Rashmy Samban rashmysam...@gmail.com wrote:
Now I have script language=javascript type=text/javascript src=
https://www.google.com/jsapi;/script in my template file and
function test() {
new Ajax.Request(
'index.php',
{queue: {position: 'end', scope: 'command'},
method: 'post',
postBody:url,
onComplete: function(response){
google.load(visualization, 1, {callback
: drawChart(arg1, arg2)});
}
}
}
in my js file.
Now the control doesn't reach drawChart function [I have put some alerts
inside drawchart]. No error message, and the div is blank.
The graph is to be displayed inside a page to which headers have already
been sent. Does visualization requires that it be a standalone html file?
On Mon, Jan 5, 2015 at 6:26 PM, 'Daniel LaLiberte' via Google
Visualization API google-visualization-api@googlegroups.com wrote:
It's hard to guess what is going on from the description of your code.
It would be much simpler for both of us if you could point to a page that
shows the problem.
But also try this: there should only be one google.load() and no other
call of drawChart, so remove what you have in your challenge.js.
On Mon, Jan 5, 2015 at 5:42 AM, Rashmy Samban rashmysam...@gmail.com
wrote:
Hi Daniel,
I could confirm that the issue is not related to the chart_div being
generated on the fly. I tried using a static div in the template file,
then
also it is showing the same error - undefined is not a function.
Best Regards,
Rashmy
On Mon, Jan 5, 2015 at 11:08 AM, Rashmy Samban rashmysam...@gmail.com
wrote:
Hi Daniel,
Thank you for the prompt response.
Tried the same. The result is the same as before, the 'undefined is
not a function' error.
I have called the foll: in my template file.
script type=text/javascript src=http://www.google.com/jsapi
/script
script language=javascript type=text/javascript
src=include/js/challenge.js/script
Inside challenge.js, I have
google.load(visualization, 1, {packages:[corechart]});
Inside another js file, I have my drawChart function, which is to be
called onComplete of the ajax call.
function test() {
new Ajax.Request(
'index.php',
{queue: {position: 'end', scope: 'command'},
method: 'post',
postBody:url,
onComplete: function(response){
google.load(visualization, 1,
{callback : drawChart(arg1, arg2)});
}
}
}
I have put alerts inside drawChart, and all LOC inside drawChart are
being executed. The chart is not getting displayed inside the div, but
the
error. Please note that the html for the chart_div is being dynamically
generated. The ajax call onComplete, sets the innerHTML of a div which
includes the chart_div. Hope this doesn't pose any issues. When I alert
typeof(document.getElementById('chart_div')) inside drawChart, it is an
object, so I guess dynamic generation of chart_div is ok.
Any further suggestions, please?
Best Regards,
Rashmy
On Fri, Jan 2, 2015 at 11:43 PM, 'Daniel LaLiberte' via Google
Visualization API google-visualization-api@googlegroups.com wrote:
Another thing that may be going on is that the google.load() call
should happen as the document is loaded, not after it has finished
loading. If you do the latter, then you have to also give it a callback
function directly, like this:
function loadApi() {
google.load(visualization, 1, {callback : pageLoaded});
}
as documented on https://developers.google.com/loader/
In your case, since you also want to wait for your ajax call to
complete, then one way you can do it is to call this loadApi function in
your onComplete handler, and instead of pageLoaded, put your function
that
calls drawChart.
This asynchronous handling is rather complex. There ought to be a
simpler way to chain multiple asynchronous paths particularly when they
join.
On Fri, Jan 2, 2015 at 4:40 AM, Rashmy Samban
rashmysam...@gmail.com wrote:
Hi Daniel,
Thank you for the reply.
I had tried setOnLoadCallback, but
[visualization-api] Format JSON for Bubble Chart From .NET DataTable
Hi I have a VB.NET app that is grabbing data from a source, and returning
it to my handler as a .NET DataTable. I am wondering if anyone has used
any methods to convert that DataTable to JSON that is necessary for the
google bubble chart. I've dug through the api docs for the chart, but
can't seem to figure out exactly how the data should be formatted. I get
one format if i just put straight data in my jQuery not from an external
data source but a different format if i get the data from an external
datasource. Any ideas would be much appreciated.
Code below does dataTable to JSON conversion, but its not in the format
that google charts requires. Or is it and i'm having a different issue?
Public Shared Function GetJSONString(ByVal Dt As DataTable) As String
Dim StrDc As String() = New String(Dt.Columns.Count - 1) {}
Dim HeadStr As String = String.Empty
For i As Integer = 0 To Dt.Columns.Count - 1
StrDc(i) = Dt.Columns(i).Caption
HeadStr += StrDc(i) : StrDc(i)
i.ToString() ¾ ,
Next
HeadStr = HeadStr.Substring(0, HeadStr.Length - 1)
Dim Sb As New StringBuilder()
Sb.Append([)
For i As Integer = 0 To Dt.Rows.Count - 1
Dim TempStr As String = HeadStr
Sb.Append({)
For j As Integer = 0 To Dt.Columns.Count - 1
TempStr = TempStr.Replace(Convert.ToString(Dt.Columns(j))
j.ToString() ¾, Dt.Rows(i)(j).ToString())
Next
Sb.Append(TempStr },)
Next
Sb = New StringBuilder(Sb.ToString().Substring(0,
Sb.ToString().Length - 1))
Sb.Append(])
Return Sb.ToString()
End Function
My JSON is as below
[{ProjectName : PPM Tool,Division :
DOA-IT;DOA-BUDG;DOA-HR;},{ProjectName : Salary Change Order,Division :
DOA-HR;},{ProjectName : MEO Case Management Solution,Division :
MEO;},{ProjectName : HR Professional Development Portal,Division :
DOA-HR;DOA-IT;WCG;},{ProjectName : Workforce Development
Project,Division : DOA-BUDG;DOA-HR;}]
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
[visualization-api] error:All series on a given axis must be of the same data type
I am trying to query a google sheet to populate a column chart, but keep
getting the error '*All series on a given axis must be of the same data
type'*.
Here's my sheet:
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-OBbmDKcxEVanITg/edit#gid=0
I copied the date from a google example:
https://docs.google.com/spreadsheet/ccc?key=0Atw2BTU52lOCdEZpUlVIdmxGOWZBR2tuLXhYN2dQTWcusp=drive_webgid=0#
If I link to the example sheet in the html below everything works fine. I
can't figure out why I can't link to my sheet, which seems identical.
and here's my html:
html
head
script type=text/javascript src=https://www.google.com/jsapi;/script
script type=text/javascript
google.load(visualization, '1', {packages:['corechart']});
google.setOnLoadCallback(drawChart);
function drawChart() {
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-OBbmDKcxEVanITg/edit#gid=0');
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
var data = response.getDataTable();
var chart = new
google.visualization.ColumnChart(document.getElementById('columnchart'));
chart.draw(data, { legend: { position: 'none' } });
}
/script
titleTest chart/title
/head
body
span id='columnchart'/span
/body
/html
Thanks for the any help,
Adam
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] error:All series on a given axis must be of the same data type
Hi,
It looks like you didn't share your sheet. Please do so, so that we may
look at it to see what is going wrong.
On Thu Jan 08 2015 at 1:12:14 PM Adam Laybourn alaybo...@gmail.com wrote:
I am trying to query a google sheet to populate a column chart, but keep
getting the error '*All series on a given axis must be of the same data
type'*.
Here's my sheet:
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-OBbmDKcxEVanITg/edit#gid=0
I copied the date from a google example:
https://docs.google.com/spreadsheet/ccc?key=0Atw2BTU52lOCdEZpUlVIdmxGOWZBR2tuLXhYN2dQTWcusp=drive_webgid=0#
If I link to the example sheet in the html below everything works fine. I
can't figure out why I can't link to my sheet, which seems identical.
and here's my html:
html
head
script type=text/javascript src=https://www.google.com/jsapi
/script
script type=text/javascript
google.load(visualization, '1', {packages:['corechart']});
google.setOnLoadCallback(drawChart);
function drawChart() {
var query = new google.visualization.Query(
'
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-OBbmDKcxEVanITg/edit#gid=0'
);
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
var data = response.getDataTable();
var chart = new
google.visualization.ColumnChart(document.getElementById('columnchart'));
chart.draw(data, { legend: { position: 'none' } });
}
/script
titleTest chart/title
/head
body
span id='columnchart'/span
/body
/html
Thanks for the any help,
Adam
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to
google-visualization-api@googlegroups.com.
Visit this group at
http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] error:All series on a given axis must be of the same data type
Sorry I forgot to share the link:
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-OBbmDKcxEVanITg/edit?usp=sharing
On Thursday, January 8, 2015 at 12:17:35 PM UTC-6, Sergey wrote:
Hi,
It looks like you didn't share your sheet. Please do so, so that we may
look at it to see what is going wrong.
On Thu Jan 08 2015 at 1:12:14 PM Adam Laybourn alay...@gmail.com
javascript: wrote:
I am trying to query a google sheet to populate a column chart, but keep
getting the error '*All series on a given axis must be of the same data
type'*.
Here's my sheet:
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-OBbmDKcxEVanITg/edit#gid=0
I copied the date from a google example:
https://docs.google.com/spreadsheet/ccc?key=0Atw2BTU52lOCdEZpUlVIdmxGOWZBR2tuLXhYN2dQTWcusp=drive_webgid=0#
If I link to the example sheet in the html below everything works fine. I
can't figure out why I can't link to my sheet, which seems identical.
and here's my html:
html
head
script type=text/javascript src=https://www.google.com/jsapi
/script
script type=text/javascript
google.load(visualization, '1', {packages:['corechart']});
google.setOnLoadCallback(drawChart);
function drawChart() {
var query = new google.visualization.Query(
'
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-OBbmDKcxEVanITg/edit#gid=0'
);
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
var data = response.getDataTable();
var chart = new
google.visualization.ColumnChart(document.getElementById('columnchart'));
chart.draw(data, { legend: { position: 'none' } });
}
/script
titleTest chart/title
/head
body
span id='columnchart'/span
/body
/html
Thanks for the any help,
Adam
--
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 google-visualization-api+unsubscr...@googlegroups.com
javascript:.
To post to this group, send email to google-visua...@googlegroups.com
javascript:.
Visit this group at
http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] error:All series on a given axis must be of the same data type
It looks like Sheets is returning more columns than you expected. you can
use query.setQuery('SELECT A, B') to just limit it to the first 2 columns.
Here is an example: http://jsfiddle.net/qgsxhqqa/
On Thu Jan 08 2015 at 1:19:14 PM Adam Laybourn alaybo...@gmail.com wrote:
Sorry I forgot to share the link:
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-OBbmDKcxEVanITg/edit?usp=sharing
On Thursday, January 8, 2015 at 12:17:35 PM UTC-6, Sergey wrote:
Hi,
It looks like you didn't share your sheet. Please do so, so that we may
look at it to see what is going wrong.
On Thu Jan 08 2015 at 1:12:14 PM Adam Laybourn alay...@gmail.com wrote:
I am trying to query a google sheet to populate a column chart, but keep
getting the error '*All series on a given axis must be of the same data
type'*.
Here's my sheet:
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-
OBbmDKcxEVanITg/edit#gid=0
I copied the date from a google example:
https://docs.google.com/spreadsheet/ccc?key=
0Atw2BTU52lOCdEZpUlVIdmxGOWZBR2tuLXhYN2dQTWcusp=drive_webgid=0#
If I link to the example sheet in the html below everything works fine.
I can't figure out why I can't link to my sheet, which seems identical.
and here's my html:
html
head
script type=text/javascript src=https://www.google.com/jsapi
/script
script type=text/javascript
google.load(visualization, '1', {packages:['corechart']});
google.setOnLoadCallback(drawChart);
function drawChart() {
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-
OBbmDKcxEVanITg/edit#gid=0');
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
var data = response.getDataTable();
var chart = new google.visualization.ColumnChart(document.
getElementById('columnchart'));
chart.draw(data, { legend: { position: 'none' } });
}
/script
titleTest chart/title
/head
body
span id='columnchart'/span
/body
/html
Thanks for the any help,
Adam
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/
group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to
google-visualization-api@googlegroups.com.
Visit this group at
http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] error:All series on a given axis must be of the same data type
For debugging purposes, it is a good idea to make sure you are getting the
data you think you should be getting from the spreadsheet, by replacing
ColumnChart with just Table (and also load the package 'table').
On Thu, Jan 8, 2015 at 1:28 PM, 'Sergey Grabkovsky' via Google
Visualization API google-visualization-api@googlegroups.com wrote:
It looks like Sheets is returning more columns than you expected. you can
use query.setQuery('SELECT A, B') to just limit it to the first 2 columns.
Here is an example: http://jsfiddle.net/qgsxhqqa/
On Thu Jan 08 2015 at 1:19:14 PM Adam Laybourn alaybo...@gmail.com
wrote:
Sorry I forgot to share the link:
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-OBbmDKcxEVanITg/edit?usp=sharing
On Thursday, January 8, 2015 at 12:17:35 PM UTC-6, Sergey wrote:
Hi,
It looks like you didn't share your sheet. Please do so, so that we may
look at it to see what is going wrong.
On Thu Jan 08 2015 at 1:12:14 PM Adam Laybourn alay...@gmail.com
wrote:
I am trying to query a google sheet to populate a column chart, but keep
getting the error '*All series on a given axis must be of the same
data type'*.
Here's my sheet:
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-
OBbmDKcxEVanITg/edit#gid=0
I copied the date from a google example:
https://docs.google.com/spreadsheet/ccc?key=
0Atw2BTU52lOCdEZpUlVIdmxGOWZBR2tuLXhYN2dQTWcusp=drive_webgid=0#
If I link to the example sheet in the html below everything works fine.
I can't figure out why I can't link to my sheet, which seems identical.
and here's my html:
html
head
script type=text/javascript src=https://www.google.com/jsapi
/script
script type=text/javascript
google.load(visualization, '1', {packages:['corechart']});
google.setOnLoadCallback(drawChart);
function drawChart() {
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-
OBbmDKcxEVanITg/edit#gid=0');
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
var data = response.getDataTable();
var chart = new google.visualization.ColumnChart(document.
getElementById('columnchart'));
chart.draw(data, { legend: { position: 'none' } });
}
/script
titleTest chart/title
/head
body
span id='columnchart'/span
/body
/html
Thanks for the any help,
Adam
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/
group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to
google-visualization-api@googlegroups.com.
Visit this group at
http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to
google-visualization-api@googlegroups.com.
Visit this group at
http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
--
Daniel LaLiberte https://plus.google.com/100631381223468223275?prsrc=2 -
978-394-1058
dlalibe...@google.com dlalibe...@google.com 5CC, Cambridge MA
daniel.lalibe...@gmail.com daniel.lalibe...@gmail.com 9 Juniper Ridge
Road, Acton MA
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: error:All series on a given axis must be of the same data type
Thank you both for the fix and debugging tips.
Adam
On Thursday, January 8, 2015 at 12:12:12 PM UTC-6, Adam Laybourn wrote:
I am trying to query a google sheet to populate a column chart, but keep
getting the error '*All series on a given axis must be of the same data
type'*.
Here's my sheet:
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-OBbmDKcxEVanITg/edit#gid=0
I copied the date from a google example:
https://docs.google.com/spreadsheet/ccc?key=0Atw2BTU52lOCdEZpUlVIdmxGOWZBR2tuLXhYN2dQTWcusp=drive_webgid=0#
If I link to the example sheet in the html below everything works fine. I
can't figure out why I can't link to my sheet, which seems identical.
and here's my html:
html
head
script type=text/javascript src=https://www.google.com/jsapi
/script
script type=text/javascript
google.load(visualization, '1', {packages:['corechart']});
google.setOnLoadCallback(drawChart);
function drawChart() {
var query = new google.visualization.Query(
'
https://docs.google.com/spreadsheets/d/1zIABnJ54bk7COAtVXJDMidHX5dc-OBbmDKcxEVanITg/edit#gid=0'
);
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
var data = response.getDataTable();
var chart = new
google.visualization.ColumnChart(document.getElementById('columnchart'));
chart.draw(data, { legend: { position: 'none' } });
}
/script
titleTest chart/title
/head
body
span id='columnchart'/span
/body
/html
Thanks for the any help,
Adam
--
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 google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
Re: [visualization-api] Question On Google Map/Geo Charts
Hi Gaurav, Our terms of service applies to all uses of the Google Visualization API. If you use map and geo charts through it, that license applies. If you're talking about other uses of Map and Geo charts, you'll have to check their terms instead. Regards, Jon On Thu, Jan 8, 2015 at 1:56 AM, gauravv Kamth gauravkam...@gmail.com wrote: Hi, I understand Google Charts are free to use. But does the free to use license extend to Map and Geo charts as well? Because I think I saw a non transferable license clause on Maps. Can someone let me know on this? Thanks and regards, Gaurav -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout. -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
