I have a workbook with 1000 scatter plots showing different data. I am trying to line up a "column" of charts such that the Category axis (x) will only be displayed on the bottom one. I've got everything looking good and pretty except that the plot area on these bottom charts will not line up correctly without manually moving each one.

I have some VBA code which will resize the plot area, and this is not a problem. However, I don't have a way to determine the plot area of the other scatter plots so that I know what to set my Left, Top, Width, and Height to. If somebody could provide a way for me to find this that would be great.

Thank you!