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