|
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.
|