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


good chemistry is complicated, and a little bit messy -LW
	PerlMonks

by satyas (Novice)

on Apr 04, 2012 at 19:44 UTC ( [id://963519]=perlquestion: print w/replies, xml )

Need Help??

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]

Domain Nodelet^?

Node Status^?

node history
Node Type: perlquestion [id://963519]
Approved by Old_Gray_Bear
Front-paged by Corion
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others about the Monastery: (5)

As of 2024-04-25 08:55 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found