Plot Area Help

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!

Thanks. That's down the right "alley" of what I'm doing. The problem is that my data isn't that variable or easily classified (I'm looking at chemical constituents at different locations), nor do I want to introduce a million calculations to the raw data (it's getting printed and used for reporting as well- adding a bunch of calculations and rows to hide will just create more problems down the road). If the plots were being printed to a sheet of paper 40 feet long and 60 feet high, I could easily show it all on a single scatter plot. But: as it sits, I need each location to have its own plot. The single axis on the bottom plot just clears some of the clutter from the page.