$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 ),
      );