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