Help for this page

Select Code to Download

Select or download this

            ### Here we update the graphs sourcedata

...
            $Chart1->SetSourceData({Source => '=Data!\$A\$2:\$A\$295'}
+);

Select or download this

            ### Here we update the graphs sourcedata
            my $Chart1 = $RequestsSheet->ChartObjects("Chart 1");
...
            $Chart1->SetSourceData({Source =>$Chart1Range,PlotBy => xl
+Columns});