Unanswered: How to dynamically generate barcharts of data in excel
I have data in a flat file which I display in a PERL page. I want this displayed data to be viewed in an Excel sheet. I also want to dynamically generate barcharts according to the data. How can such barcharts be created in Excel or MSWord.
To create the barchart in excel you will have to just place the information you pull out of the flat file into excel cells. Then , in excel you will have to create the 'chart' using the fields from the cells you just entered the data in. This will randomly generate the excel charts each time you open the page.