See how to create Scatter Charts with ExcelApplication.
Text from the 'Technical Overview' section
Insert code from sample stored in SVN here
Any template files Sample output file