Generete chart in spreadsheet during runtime

[London123456]

Hi,

I want to generate a chart in the spreadsheet when user click get report button.The excel should be generated durng run time and user can save the file in his local machine.Could you please let me know if this can be acheivable in coldfusion.

Thanks

[-__cfSearching__-]

No you cannot create Excel charts from scratch. What you can do is either

A) Use cfchart to create an image of a chart. Then add the image to the spreadsheet

B) Create a blank chart in Excel. Then use CF to populate the data cells used by the chart