Help for this page

Select Code to Download


  1. or download this
    my $newworksheet = $activeWorkbook->Worksheets->Add({Before=>$activeWo
+rkbook->Worksheets(1)})  or die $!;
$newworksheet -> {Name} = "Chart$Tester";
#the sheet is created -> switch off the gridlines
$newworksheet -> DisplayGridlines = 'False';
  2. or download this
    my $Chart = $ChartSheet->ChartObjects->Add(@Position)->Chart; 
$Chart->{ChartType} = xlColumnClustered;
...
 ShowValue=>'True',
 ShowPercentage=>'False',
 ShowBubbleSize=>'False');