<?xml version="1.0" encoding="windows-1252"?>
<node id="1004543" title="Re: Excel Chart" created="2012-11-19 09:01:16" updated="2012-11-19 09:01:16">
<type id="11">
note</type>
<author id="847566">
Don Coyote</author>
<data>
<field name="doctext">
&lt;p&gt;For your initial problem, I think you may need to concatenate and interpolate your '$worksheet!' hash values.&lt;/p&gt;
&lt;code&gt;
$chart-&gt;add_series(
        categories =&gt; '='."$worksheet".'!$B$1:$E$1',
        values     =&gt; '='."$worksheet".'!$A$1:$E$1450',
        name       =&gt; 'chart1',
);
&lt;/code&gt;
</field>
<field name="root_node">
1004530</field>
<field name="parent_node">
1004530</field>
</data>
</node>
