my @a = (1, 2, 3); my @b = (5, 10, 15); my $a = \@a; my $b = \@b; $xls->ActiveChart->SetSourceData({ Source =>$xls->Sheets('Sheet1')->Range("$a:$b"), PlotBy =>xlColumns, });