Setting size of chart through Excel::Writer::XLSX

satyas has asked for the wisdom of the Perl Monks concerning the following question:

HI, Is there a way to set the size of chart through Excel::Writer::XLSX module? Or can i create bigger charts through any of the 42 styles? Thanks.

Comment on Setting size of chart through Excel::Writer::XLSX

Replies are listed 'Best First'.
Re: Setting size of chart through Excel::Writer::XLSX by jmcnamara (Monsignor) on Apr 04, 2012 at 21:53 UTC
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] See the insert_chart() section of the documentation. -- John.	[reply] [d/l]