Definitely read the article that moonie suggested.

The way I approach problems like this when I have Excel on the box (which I don't right now -- sorry) is to record a Macro in Excel, then go through the steps to create and format the chart. The resulting Macro is in Visual Basic, but it's usually possible to reverse engineer it and convert it to Perl.