http://www.perlmonks.org?node_id=1004543


in reply to 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', );