You're welcome. On Thursday, November 1, 2012 3:09:31 AM UTC-4, QSint wrote: > > With your example, I don't have problem with the error anymore. Thank you > so much for your kindness and your time to help me with this. > > On Thursday, November 1, 2012 11:46:29 AM UTC+7, asgallant wrote: >> >> 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/-/AJjDoRC39fkJ. 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.
