Spreadsheet-WriteExcel - Help with Multiple charts using chartex

Posted on Wed Apr 13 16:28:52 2005 by marfolarfo
Help with Multiple charts using chartex
I am using the chartex command to generate three different binary chart templates for use with the spreadsheet Perl modules. I am using the following code segment inside a loop to generate three different chart sheets based on the data in three different work sheets.
$workbook->add_chart_ext($majPhase . 'chart01.bin', $majPhase . 'chart' ); # Link the chart to the worksheet data using a dummy formula. $worksheet->store_formula('=' . $majPhase . '!I2');
This is working nicely except for one rather nasty problem. All three charts are the same. They all are using the teplate and data from the first generated chart sheet. I have read all the documentation I can find and tried various thing, all to know avail. Can anyone tell me what I am doing wrong.
Direct Responses: 332 | Write a response