Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Posts
    2

    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.

  2. #2
    Join Date
    Mar 2003
    Posts
    8
    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.......

  3. #3
    Join Date
    Feb 2003
    Location
    Germany
    Posts
    20
    Have a look at http://www.bettina-attack.de/jonny/v...hp_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

  4. #4
    Join Date
    Feb 2002
    Location
    North Wales, UK
    Posts
    114
    You could just output the data in CSV format....
    J^ - web | email
    newsASP Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •