I've added a feature to Spreadsheet::WriteExcel to allow programmatically generated charts to be embedded in worksheets.

Here is an example which will generate something like this: