in reply to Spreadsheet::WriteExcel, draw circles or a pie chart?

Spreadsheet::WriteExcel has the ability to insert charts created in Excel into spreadsheets. Unfortunately at the moment it is somewhat limited because the chart has to be created in Excel, and then extracted with an external utility. Once extracted you can't change much about the chart including the data range selections of the series, which is a fairly major limitation.

I am currently working on a module to be used in combination with Spreadsheet::WriteExcel to generate Excel (actually they will be more like oocalc) charts dynamically and allow many (hopefully eventually most) of the properties of the chart to be changed on the fly.

Right now it is partially working for some of the simple types of charts (Column, Bar & Line), but it still has a lot of bugs and a lot of things aren't implemented yet. Unfortunately Pie charts are one of the types I have spent little to no time working on so far. I've got limited time to work on it at the moment, so if anyone is interested in helping with development/testing, that'd be great...

I've been in contact with John M., the maintainer of Spreadsheet::WriteExcel, and it is possible that some of my code may eventually be integrated into that module, but probably not anytime soon.

  • Comment on Re: Spreadsheet::WriteExcel, draw circles or a pie chart?