Regarding the idea of adding a timeline to your geochart, you might get some ideas from this page: http://www.chrisdblumberg.com/unemployment/animated.html They are using geocharts, and the "Update Values" button starts updating values automatically like a Play button of a timeline.
dan On Tue, Oct 9, 2012 at 10:10 AM, Sergey Grabkovsky <[email protected]> wrote: > Hi UI, > > There is a very easy way to import data from an excel sheet. The solution is > to use Google Docs to import your spreadsheet and then to get data from it > using a query. You may have to share the spreadsheet in order for other > people to see it. > > - Sergey > > > On Saturday, October 6, 2012 11:29:32 PM UTC-4, UI wrote: >> >> Many thanks. My next challenge will be to add a timeline (1990-2011). >> Also currently I am inputting manually which takes time for large data sets. >> Hope to find a quick solution to import data from an excel sheet. >> >> On Sunday, October 7, 2012 9:24:38 AM UTC+8, Daniel LaLiberte wrote: >>> >>> You can specify the "formatted" value for each province, as you can >>> see in this example: http://jsfiddle.net/dlaliberte/SSCLx/6/ >>> >>> To do so, you have to create your datatable using the addColumn() and >>> addRows() mechanism, like this: >>> >>> var data = new google.visualization.DataTable(); >>> data.addColumn('string', 'Province'); >>> data.addColumn('number', 'Popularity'); >>> >>> data.addRows([ >>> [{v:"CN-11", f:"province 11"}, 600], >>> [{v:"CN-50", f:"province 50"}, 595], >>> [{v:"CN-31", f:"province 31"}, 700], >>> [{v:"CN-53", f:"province 53"}, 500] >>> ]); >>> >>> >>> On Fri, Oct 5, 2012 at 4:23 AM, UI <[email protected]> wrote: >>> > Can I rename a GEO-CODE manually. I do not want the label to be a >>> > number. >>> > In this case I am mapping regions in China and only the codes function. >>> > Goal is to rename the code to the actual province name. >>> > >>> > Thanks >>> > >>> > _______________ >>> > <html xmlns="http://www.w3.org/1999/xhtml";> >>> > <head> >>> > <meta http-equiv="content-type" content="text/html; charset=utf-8" /> >>> > <title>Google Visualization API Sample</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 data = google.visualization.arrayToDataTable([ >>> > ['Provinces', 'Popularity'], >>> > ['CN-11', 600], >>> > ['CN-50', 595], >>> > ['CN-31', 700], >>> > ['CN-53', 500] >>> > ]); >>> > >>> > var geochart = new google.visualization.GeoChart( >>> > document.getElementById('visualization')); >>> > geochart.draw(data, {width: 556, height: 347, region:"CN", >>> > resolution:"provinces"}); >>> > } >>> > >>> > google.setOnLoadCallback(drawVisualization); >>> > </script> >>> > </head> >>> > >>> > -- >>> > You received this message because you are subscribed to the Google >>> > Groups >>> > "Google Chart API" group. >>> > To view this discussion on the web visit >>> > https://groups.google.com/d/msg/google-chart-api/-/qNr3iQY87soJ. >>> > 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-chart-api?hl=en. >>> >>> >>> >>> -- >>> Daniel LaLiberte - 978-394-1058 >>> [email protected] 562D 5CC, Cambridge MA >>> [email protected] 9 Juniper Ridge Road, Acton MA > > -- > You received this message because you are subscribed to the Google Groups > "Google Chart API" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/google-chart-api/-/fbvespXvf0gJ. > > 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-chart-api?hl=en. -- Daniel LaLiberte - 978-394-1058 [email protected] 562D 5CC, Cambridge MA [email protected] 9 Juniper Ridge Road, Acton MA -- You received this message because you are subscribed to the Google Groups "Google Chart API" group. 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-chart-api?hl=en.
