in reply to Re: Re: OLE - updating a chart in an excel spreadsheet
in thread OLE - updating a chart in an excel spreadsheet

This works for me

my $Chart1Range = $DataSheet->Range("A1:A295,G1:G295");
$Chart1->SetSourceData($Chart1Range,xlColumns);

[download]

In Section Seekers of Perl Wisdom