Re: Excel Chart

For your initial problem, I think you may need to concatenate and interpolate your '$worksheet!' hash values.

$chart->add_series(
        categories => '='."$worksheet".'!$B$1:$E$1',
        values     => '='."$worksheet".'!$A$1:$E$1450',
        name       => 'chart1',
);
[download]

Comment on Re: Excel Chart Download Code

Replies are listed 'Best First'.
Re^2: Excel Chart by Anonymous Monk on May 31, 2016 at 08:11 UTC
Instead of hard coding as " categories => '='."$worksheet".'!$B$1:$E$1' ", Can we make it dynamic to select the range of cells to plot the chart? Any idea how to make it dynamic?	[reply]
Re^3: Excel Chart by Corion (Patriarch) on May 31, 2016 at 08:20 UTC
Making the range dynamic is as easy as constructing the appropriate string for the range.	[reply]
Re^3: Excel Chart by davies (Prior) on May 31, 2016 at 10:55 UTC
Have a look at Re^3: Win32::Ole excel external data range, in which I show the use of dynamic ranges. It does other things too (it's answering a different question), but I think it's reasonably clear. Regards, John Davies	[reply]

In Section Seekers of Perl Wisdom