FusionCharts with MS Excel as the data source

[machinma]

Hi there

 

 

 

I can see in the documentation that you can have a query in an mdb as the data source for fusion charts, so surely you must also be able to pick up a Defined Range within an Excel Workbook too?

[FusionCharts Support]

Hi,

I am afraid, FusionCharts does not directly pick data from database. It can only accepts XML. An intermediate script uses the SQL, builds the XML and passes the XML to the chart. For an Excel Datasource the processes involved would be same.

[machinma]

Thanks. Where I can learn how to create the script that will build the XML from Excel?

[Pallav]

You can use the GUI at www.fusioncharts.com/demos/GUI to do so.