Hello,
I have a worksheet with a lot of charts (~32). I have written a code to size these charts to have the same dimensions and align them with 3 charts in each row.
My problem is that i want to setup a macro to size the charts so i can print 6 charts (2 rows with 3 charts) on a page (page setup should be Landscape)
How will i go about setting the right size of the charts? And how to set the margins etc for the page?
Thanks in advance
//Rasmus
I have a worksheet with a lot of charts (~32). I have written a code to size these charts to have the same dimensions and align them with 3 charts in each row.
My problem is that i want to setup a macro to size the charts so i can print 6 charts (2 rows with 3 charts) on a page (page setup should be Landscape)
How will i go about setting the right size of the charts? And how to set the margins etc for the page?
Thanks in advance
//Rasmus