I am trying to make a simple line chart using Spreadsheet::WriteExcel. It works great as long as the column range and row are known values, like  values=> '=Sheet1!$B$3:$B$258',. I did a search on the perl monks site and came up with this: 
 $chart->add_series(
    categories => '=Sheet1!$B$1:$E$1',
    values     => "=Sheet1!\$B\$$variable:\$E\$$variable"
    );

[download]
For my app the columns are the variable and I haven't been able to properly transpose the above code to make the columns variable. I have read that in some instances you can simply use numbers for row and column but that also does not work. Ideally I need something like this: 
 $chart1->add_series
   (
    values => "=Sheet1!\$B$6:\$$column_count$6",  
    name   => 'Test data series 1',
  );

[download]
I know the starting point is B6, and the ending point for the chart is going to be $column_count$6 but nothing I have tried seems to work and I'm basically guessing at this point. Can anyone help?

In reply to Excel chart for dynamic data by mark4444az

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.