Graph each xml file in Document Library

Mar 13, 2012 at 8:34 PM

Hi,

I have an InfoPath form that saves data as xml to a document library in sharepoint, and I want a chart from each xml document. I would prefer to show the chart in the "View Properties" page of each document (Forms/DispForm.aspx) or something similar. (What I don't want is a page full of dozens of graphs.)

I can get the form to produce xml in a format similar to http://docs.fusioncharts.com/free/Contents/ChartSS/XML_Column2D.html save for xml prefixes.

Example output data: 

<?xml version="1.0" encoding="UTF-8"?>
    <?mso-infoPathSolution solutionVersion="1.0.0.2" productVersion="12.0.0" PIVersion="1.0.0.0" href="http://companyweb/mydoclib/Forms/template.xsn" ?><?mso-application progid="InfoPath.Document" versionProgid="InfoPath.Document.2"?>
<my:graph my:caption="Decline in net interest margins of asian banks (1995-2001)" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-03-13T19:48:42" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xml:lang="en-us">
	<my:set my:name="taiwan" my:value="-0.33"></my:set>
    <my:set my:name="malaysia" my:value="-0.27"></my:set>
    <my:set my:name="hong kong" my:value="0.40"></my:set>
    <my:set my:name="philippines" my:value="0.6"></my:set>
    <my:set my:name="singapore" my:value="-0.8"></my:set>
    <my:set my:name="thailand" my:value="-2.2"></my:set>
    <my:set my:name="india" my:value="1.2"></my:set>
</my:graph>

Any ideas how I can do this?