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

[Rom399]

Most of the time i don't get a error or error message. I get a compile crash when it get's to the sourceData update.. Also tryed using this but more perl interpreter crashes :(

            ### Here we update the graphs sourcedata
            my $Chart1 = $RequestsSheet->ChartObjects("Chart 1");
            my $sourceRange = "A1:A295,G1:G295";
            my $Chart1Range = $DataSheet->Range($sourceRange);
            $Chart1->SetSourceData({Source =>$Chart1Range,PlotBy => xl
+Columns});