Rob,
You asked several questions which I am not qualified to answer having only used Win32::OLE a few times. I can tell you that support for charts in Spreadsheet::WriteExcel is experimental and can't be generated ad hoc at runtime. You are required to create which ever charts you want ahead of time, extract the binary representation, and then change the data set it is bound to at runtime.