Re^3: OLE - updating a chart in an excel spreadsheet

[Anonymous Monk]

This works for me

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