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