Unfortunately, SpreadSheet::WriteExcel has not any functions available of that caliber, it has, however, functionalities that try to as closely as possible mimic excel environment and it provides excel with a sort of a programming interface that offers to employ many excel features in its methods. You can add externally created charts to SpreadSheet::WriteExcel, hope I am giving you good tidings. Check this page for some Perl examples of different SpreadSheet::WriteExcel programs
http://www.koders.com/info.aspx?c=ProjectInfo&pid=WZKBNF1X3ERMTDSA4BGQNFCQSF
another thing, there could be other Statistical packages in the CPAN, they give some chart capabilities but I haven't used any of them to suggest something. Take a look at the CPAN
Excellence is an Endeavor of Persistence.
Chance Favors a Prepared Mind