I tested it here: http://jsfiddle.net/asgallant/wJbmx/, and it works in all the browsers I have access to at home (FF, Chrome, IE10). If that doesn't work for you, then I'll test it in IE 9 tomorrow.
On Wednesday, October 31, 2012 10:42:51 PM UTC-4, QSint wrote: > > 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/-/nv5dMOUKknIJ. 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.
