I've released a new version of Excel::Writer::XLSX to CPAN with support for charts.
The output looks something like this:
The example program that generated it is here.
I'll be adding more features in the near future such as chart sub-types, formatting, hi-lo bars and droplines.
If you are already using the Spreadsheet::WriteExcel charting features, or are interested in using this feature, try it out and let me know what you think.