I may well be barking up the wrong tree, but would it be possible to make the graph in excel manually and then replace the data as needed using SpreadSheet::WriteExcel??
I have done something similar to this in the past to get round the limitations of the module, although, it is a fantastic module.