Hello,

I am just finishing a wxperl-based app that goes through an excel file that tracks the progress of jobs and draws a bar chart (like a gantt chart with no vertical connectors) for 7 business days. Each bar is colored by department with a stipple over the color for whether it is done or not, and a line of text providing owner, client and other information is drawn above each bar.

Spreadsheet::ParseExcel to read the sheets (slightly modified to update a progress bar and abort on a button click). After looking around a bit, I settled on using plain GD for drawing and am quite happy with it. Of course you are telling it where to plot each line, but if you just want the commonest graph types GD::Graph I believe. Of course if you are just automating Excel graph creation go for it. But mine draws graphs Excel doesn't have and works cross-platform. There is a PHP based graph drawing system out there called JpGraph but I decided I really didn't want to use PHP. But it can do pies etc.

As it is the GD drawing is fast, the problem is the Spreadsheet module which takes 1 minute to go through a megabyte-sized file. (I think about 200 rows by 15 columns). Which is okay but a little slow (of course this is on an old Win 98 machine not your screaming multi-gigahertz box).

In reply to Re: Building Charts (PIE) by mattr
in thread Building Charts (PIE) by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.