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";
In Section
Seekers of Perl Wisdom