CPAN::Forum
Spreadsheet-WriteExcel - Another problem with charts
| Posted on Fri Apr 29 14:47:33 2005 by marfolarfo |
| Another problem with charts |
|
I created a spreadsheet with four data sheets and four chart sheets. The data sheets are named, download, install, rollback, soak. The chart sheets are named downloadChart, installChart, rollbackChart, and soakChart. I run chartex and get the following output.
Extracting "downloadChart" to chart01.bin
Extracting "installChart" to chart02.bin
Extracting "rollbackChart" to chart03.bin
Extracting "soakChart" to chart04.bin
==================================================
Add the following near the start of your program.
Change variable name $worksheet if required.
$worksheet->store_formula("=download!A1");
$worksheet->store_formula("=install!A1");
$worksheet->store_formula("=soak!A1");
$worksheet->store_formula("=rollback!A1");
I then rename
chart01.bin to downloadChart.bin
chart02.bin to installChart.bin
chart03.bin to rollbackChart.bin
chart04.bin to soakChart.bin
I reference them in my perl program using these new names.
My problem is that the soak data is ending up in the rollback chart and the
rollback data is ending up in the soak chart. In order to get it to work correctly
I have to copy
chart03.bin to soakChart.bin
and chart04.bin to rollbackChart.bin
|
| Direct Responses: 399 | Write a response |
(19)
]