in reply to Setting axis data range on Excel chart using Win32::OLE

If B1:G2 is the only data in the chart, you can use: 
$sum_sheet->ChartObjects(1)->SetSourceData($sum_sheet->Range("B1:G2"))
+;

[download]

In Section Seekers of Perl Wisdom