Macro to accommodate the chart size

Is there a way where macro can determine the chart size to accommodate it in the page setup area.
Like, If it where table I could find the last column and accordingly determine its page area but what to do in case of charts?
Any thoughts?
Thanks

Hi,

you can query the chart height and width by using

ActiveSheet.Shapes("Chart 1").Height

or

ActiveSheet.Shapes("Chart 1").Width

respectively. You can set the chart height and width by using code like the following. Just substitute the values with the ones you need

Please Login or Register  to view this content.

regards,