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', );
In Section
Seekers of Perl Wisdom