Spreadsheet::WriteExcel has the ability to insert charts created in Excel into spreadsheets. Unfortunately at the moment it is somewhat limited because the chart has to be created in Excel, and then extracted with an external utility. Once extracted you can't change much about the chart including the data range selections of the series, which is a fairly major limitation.

I am currently working on a module to be used in combination with Spreadsheet::WriteExcel to generate Excel (actually they will be more like oocalc) charts dynamically and allow many (hopefully eventually most) of the properties of the chart to be changed on the fly.

Right now it is partially working for some of the simple types of charts (Column, Bar & Line), but it still has a lot of bugs and a lot of things aren't implemented yet. Unfortunately Pie charts are one of the types I have spent little to no time working on so far. I've got limited time to work on it at the moment, so if anyone is interested in helping with development/testing, that'd be great...

I've been in contact with John M., the maintainer of Spreadsheet::WriteExcel, and it is possible that some of my code may eventually be integrated into that module, but probably not anytime soon.

In reply to Re: Spreadsheet::WriteExcel, draw circles or a pie chart? by softwarejanitor
in thread Spreadsheet::WriteExcel, draw circles or a pie chart? by sushi2k

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.