I don't know of any examples of using XML to load data for the Visualization API. Basically, you would need to write an AJAX function to get the data, parse it into an XMLDocument object, and then parse the document object to pull out the data and input it into a DataTable. jQuery has a lot of built-in functionality to handle this kind of stuff; I expect other libraries do as well. Here's a basic example that I think should work:
$.ajax({ url: 'myXML.xml', dataType: 'xml', success: function (xml) { var data = new google.visualization.DataTable(); data.addColumn('string', 'Name'); data.addColumn('number', 'Value'); $('row', xml).each(function () { var name = $('name', this).text(); var value = parseInt($('value', this).text()); data.addRow([name, value]); }); var chart = new google.visualization.LineChart(document.querySelector('#chart_div')); chart.draw(data, { height: 400, width: 600 }); } }); given an XML structure like this: <rows> <row> <name>foo</name> <value>5</value> </row> <row> <name>bar</name> <value>7</value> </row> <row> <name>cad</name> <value>4</value> </row> </rows> On Friday, May 16, 2014 1:59:06 AM UTC-4, David Kasabji wrote: > > Hello, > > I am sorting a huge databse into an XML file, and I need to take some data > from that database as INPUT for tha Google Charts (for example for Column > Chart). > I have been struggling to find any good tutorials on how to do this, > ussually people just link some general stuff, but not specificly for Google > Charts. > > So any input, maybe even walkthrough, would be really really appreciated. > > Thanks in advance! > > BR, > David > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.