In Firefox and Chrome the chart display normally but in IE the red error message is loaded 4 times before the chart appear. I use IE9. Firefox 16.0.2 and Chrome 22.0.1229.94 m. Here is the url of the spreadsheet, https://docs.google.com/spreadsheet/ccc?key=0Ai9V1GjfC6zfdG9ZOE9sTU9qN3Jnd1RmZzlCVjhOMkE
On Thursday, November 1, 2012 12:42:19 AM UTC+7, asgallant wrote: > > The only problem I see in your code is that you have two charts trying to > draw in the same div (visualization and geochart), but that wouldn't cause > the error you are seeing. I would expect that error if the query failed, > but then the error handler should catch that and spawn the alert statement. > > You said this error comes up in IE, what version of IE? Do things work > correctly in Firefox and Chrome? > > Also, it would help to have the spreadsheet url to test with, if you can > share it. > > On Tuesday, October 30, 2012 11:25:54 PM UTC-4, QSint wrote: >> >> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" >> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";;> >> <html xmlns="http://www.w3.org/1999/xhtml";;> >> <head> >> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> >> <title>MAP TEST</title> >> <script type="text/javascript" src="http://www.google.com/jsapi >> ";></script> >> <script type="text/javascript"> >> google.load('visualization', '1', {packages: ['geochart']}); >> >> function drawVisualization() { >> var query = new >> google.visualization.Query('I PUT MY GOOGLE DOC FILE URL HERE'); >> query.send(handleQueryResponse); >> } >> >> function handleQueryResponse(response) { >> if (response.isError()) { >> alert('Error in query: ' + response.getMessage() + ' ' + >> response.getDetailedMessage()); >> return; >> } >> >> var data = response.getDataTable(); >> visualization = new google.visualization.GeoChart(document. >> getElementById('visualization')); >> visualization.draw(data, null); >> >> var geochart = new >> google.visualization.GeoChart(document.getElementById('visualization')); >> google.visualization.events.addListener(geochart, 'select', >> function() { >> var selectionIdx = geochart.getSelection()[0].row; >> var countryName = data.getValue(selectionIdx, 0); >> window.open('I PUT THE URL I WANT HERE'); >> }); >> >> geochart.draw(data, { >> width: 1000, >> height: 550 >> }); >> } >> >> google.setOnLoadCallback(drawVisualization); >> </script> >> </head> >> <body style="font-family: Arial;border: 0 none;"> >> <div align="center" id="visualization"></div> >> </body> >> </html> >> >> On Tuesday, October 30, 2012 10:57:06 PM UTC+7, asgallant wrote: >>> >>> Post the code you are using and I'll take a look. >>> >>> On Monday, October 29, 2012 10:21:45 PM UTC-4, QSint wrote: >>>> >>>> Thank you so much. I tried this way but when I open the page on >>>> Explorer, there's an error saying, Unable to set value of the property >>>> 'data': object is null or undefined >>>> On Firefox and Chrome, I don't see this message. Do you have any ideas, >>>> how should I fix this? >>>> >>>> On Friday, October 26, 2012 10:03:28 PM UTC+7, asgallant wrote: >>>>> >>>>> The easy way is to upload the spreadsheet to google docs and use a >>>>> query to read the contents. >>>>> >>>>> On Thursday, October 25, 2012 10:35:23 PM UTC-4, Fiorella wrote: >>>>>> >>>>>> Is there the way to get data from table in excel spreadsheet to >>>>>> display on Geochart and put the link for each country to specific url we >>>>>> want? >>>>>> >>>>>> On Friday, September 7, 2012 8:54:34 PM UTC+7, asgallant wrote: >>>>>>> >>>>>>> I don't know how Sharepoint works, so I can't help you set it up, >>>>>>> but yes, you should be able to use it as a data source. There are >>>>>>> other >>>>>>> threads on this forum that deal with Sharepoint, perhaps one of them >>>>>>> will >>>>>>> help (search "Sharepoint"). If not, try >>>>>>> stackoverflow<http://stackoverflow.com/> >>>>>>> . >>>>>>> >>>>>>> On Friday, September 7, 2012 3:56:07 AM UTC-4, Kate wrote: >>>>>>>> >>>>>>>> I have one more question :D >>>>>>>> Is it possible to get data column from external data source? >>>>>>>> I use SharePoint Online and I put this map on my SharePoint Site >>>>>>>> and I'm just thinking it would be great if the map can get data from >>>>>>>> SharePoint list column to display on the map. >>>>>>>> Do you have any suggestions for this? >>>>>>>> >>>>>>>> On Tuesday, September 4, 2012 10:44:42 PM UTC+7, asgallant wrote: >>>>>>>>> >>>>>>>>> You're welcome. >>>>>>>>> >>>>>>>>> On Tuesday, September 4, 2012 3:07:42 AM UTC-4, Kate wrote: >>>>>>>>>> >>>>>>>>>> Thank you so much for your help. I really really appreciate this >>>>>>>>>> and this is inspiring me for learning ^_^ >>>>>>>>>> >>>>>>>>>> On Tuesday, September 4, 2012 10:55:22 AM UTC+7, asgallant wrote: >>>>>>>>>>> >>>>>>>>>>> You add the extra column in the chart the exact same way you >>>>>>>>>>> added the other columns to the chart. You use a DataView (or the >>>>>>>>>>> view >>>>>>>>>>> property of a ChartWrapper) to select which columns should be used >>>>>>>>>>> to draw >>>>>>>>>>> a chart. See an example here: >>>>>>>>>>> http://jsfiddle.net/asgallant/9BLSc/ >>>>>>>>>>> >>>>>>>>>>> On Monday, September 3, 2012 10:30:25 PM UTC-4, Kate wrote: >>>>>>>>>>>> >>>>>>>>>>>> asgallant: Yes the urls are in this form and thank you very >>>>>>>>>>>> very much for the solution. It works well now and I'm so happy ^_^ >>>>>>>>>>>> However I still want to know another solution you mentioned. >>>>>>>>>>>> Could you please show me by code example how to add an extra >>>>>>>>>>>> column in the >>>>>>>>>>>> DataTable and how to hide the column from the chart? >>>>>>>>>>>> >>>>>>>>>>>> On Tuesday, September 4, 2012 6:46:05 AM UTC+7, asgallant wrote: >>>>>>>>>>>>> >>>>>>>>>>>>> Are the urls for the countries in the form >>>>>>>>>>>>> "mainUrl/countryName.aspx"? If so, then just add ".aspx" to the >>>>>>>>>>>>> end of the >>>>>>>>>>>>> string in the window.open call: >>>>>>>>>>>>> >>>>>>>>>>>>> window.open('main url' + countryName + '.aspx'); >>>>>>>>>>>>> >>>>>>>>>>>>> If the url's aren't formulaic like that, then you can add them >>>>>>>>>>>>> as an extra column in the DataTable and hide that column from the >>>>>>>>>>>>> chart. >>>>>>>>>>>>> You can then reference the DataTable to get the url in the >>>>>>>>>>>>> "select" event >>>>>>>>>>>>> handler. >>>>>>>>>>>>> >>>>>>>>>>>>> On Sunday, September 2, 2012 11:10:38 PM UTC-4, Kate wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>> Marc: I tried window.open('main url' + countryName) but it >>>>>>>>>>>>>> doesn't work for my site as all pages end with .aspx. Could you >>>>>>>>>>>>>> please give >>>>>>>>>>>>>> me suggestion how to make this make this work or is there any >>>>>>>>>>>>>> way that I >>>>>>>>>>>>>> can put individual url for each region manually? >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Tuesday, June 26, 2012 6:44:45 AM UTC+7, Marc Lucchini >>>>>>>>>>>>>> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> You'll have to listen to the >>>>>>>>>>>>>>> "select<https://developers.google.com/chart/interactive/docs/gallery/geochart#Events>" >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> or the >>>>>>>>>>>>>>> "regionClick<https://developers.google.com/chart/interactive/docs/gallery/geochart#Events>" >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> event. >>>>>>>>>>>>>>> An example using the select event: http://jsfiddle.net/dz2xS >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> If your country pages already exist and you can't or don't >>>>>>>>>>>>>>> want to change their URLs, you may have to put these URLs in >>>>>>>>>>>>>>> your datatable >>>>>>>>>>>>>>> and pass a dataview to the geochart. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Le lundi 25 juin 2012 23:25:41 UTC+2, Susanna Murley a >>>>>>>>>>>>>>> écrit : >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> I want to create a geochart that allows me to set urls for >>>>>>>>>>>>>>>> regions. For example, if someone clicks on California in my >>>>>>>>>>>>>>>> map, I want it >>>>>>>>>>>>>>>> to link to a separate page on my site. How do I do this? >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/WaePd7zI6p0J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
