PDA

View Full Version : How to dynamically generate barcharts of data in excel

Kumar Saurabh
02-14-03, 01:32
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.
Cobbyness
05-07-03, 14:11
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.

Hope that helps you out some.......
hernst
05-08-03, 03:32
Have a look at http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/ which generates real excel-files, but I don't know if it is possible to create charts with that class, but if it is possible I would like to know.

Jürgen
JonathanB
05-09-03, 12:57
You could just output the data in CSV format....