Hi,
I am trying to use vba to automatically create charts. But, I can't get the chart shapes such as plot area and legend sized or moved properly that is uniform accross all different screen sizes/resolution. For example, if I were to set the sizes according to a 1280x1048 screen, running the same code on a 1680x1280 screen would totally distort it...it would keep the plot size small and only adjust the chart size. So the actual chart size gets adjusted, but the shapes inside it do not do not.
I am using Excel 2003 and the code I am using to size is the following:
Any advice would be appreciated.
Thanks.
Bookmarks