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/-/QYNtk36UmvkJ. 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.
