<!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/-/SvYl_eEh4DkJ.
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.
