See how to create Scatter Charts with ExcelApplication.
Demonstrates how to create a Scatter chart with ExcelApplication.
Insert code from sample stored in SVN here
Any template files Sample output file