sub chart_me {
my( $row, $name ) = @_;
my $chart = $workbookout->add_chart( type => 'line', name => $name );
$chart->set_title( name => $name );
foreach my $i ( 1 .. 6 ) {
my $rowi = $row + $i - 1;
$chart->add_series(
name => $header[ $i ],
catagories => xl_range_formula( 'Sheet1', 1, 1, 2, $maxcol ),
values => xl_range_formula( 'Sheet1', $rowi, $rowi, 2, $maxcol ),
);
}
}
####
$chart->add_series(
name => $header[ $i ],
catagories => xl_range_formula( 'Sheet1', 0, 0, 1, $maxcol ),
values => xl_range_formula( 'Sheet1', $rowi, $rowi, 1, $maxcol ),
);
####
$chart->add_series(
name => $header[ $i ],
name_formula => '=Sheet1!' . xl_rowcol_to_cell( $rowi, 0, 1, 1 ),
catagories => xl_range_formula( 'Sheet1', 0, 0, 1, $maxcol ),
values => xl_range_formula( 'Sheet1', $rowi, $rowi, 1, $maxcol ),
);