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