Google Chart Data to be Drawn from the XML as the Data Source.

See more:

Javascript

XML

Google

JSON

Hi All,

I have the following URL is being used as the DataSource of to a Google Charts.

<a href="https://spreadsheets.google.com/tq?key=pCQbetd-CptHnwJEfo8tALA">https://spreadsheets.google.com/tq?key=pCQbetd-CptHnwJEfo8tALA</a>[<a href="https://spreadsheets.google.com/tq?key=pCQbetd-CptHnwJEfo8tALA" target="_blank" title="New Window">^</a>

The Data within the location of that URL is as the below

// Data table response
google.visualization.Query.setResponse({"version":"0.6","status":"ok","sig":"598319012","table":{"cols":[{"id":"A","label":"Element","type":"string","pattern":""},{"id":"B","label":"Percent","type":"number","pattern":"#0.###############"}],"rows":[{"c":[{"v":"iron"},{"v":32.1,"f":"32.1"}]},{"c":[{"v":"oxygen"},{"v":30.1,"f":"30.1"}]},{"c":[{"v":"silicon"},{"v":15.1,"f":"15.1"}]},{"c":[{"v":"magnesium"},{"v":13.9,"f":"13.9"}]},{"c":[{"v":"sulfur"},{"v":2.9,"f":"2.9"}]},{"c":[{"v":"nickel"},{"v":1.8,"f":"1.8"}]},{"c":[{"v":"calcium"},{"v":1.5,"f":"1.5"}]},{"c":[{"v":"aluminium"},{"v":1.4,"f":"1.4"}]}]}});

Now what I want is this data to be in an XML file that locally resides and retrieve from there to draw the Google Chart.

So what can I do to this to solve my problem? Please could you someone help me to solve this matter?

Thanks and regards,
Chiranthaka