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

I've also tried to get this type of thing working previously and given up in disgust! I would try just setting the X Axis values directly after the Paste: 
$sum_sheet->ActiveChart->SeriesCollection(1)->{XValues} "='Summary!'$B
+$1:$G$1";

[download]

In Section Seekers of Perl Wisdom