You can set the size of an embedded chart in Excel::Writer::XLSX by adjusting the x/y scales in insert_chart():

    # Scale the width by 120% and the height by 150%
    $worksheet->insert_chart( 'E2', $chart, 0, 0, 1.2, 1.5 );
[download]

--
John.