How to change or standardize size and position of plot areas

It's frustrating that you can't easily change the size and position of the plot area in Excel. I've read in some places that you can accomplish this with macro (of which I have no knowledge), so I'm posting here for some help on how to do so.

I have several scatter plots in Excel whose total chart areas are defined (2.6" tall by 3.3" wide). Within that chart area, I would like to maximize the plot area and make it the same for all graphs. I originally started from the same graph, copied and pasted, removed the old data and added the new data (by special pasting formulas only) whilst changing the axes bounds appropriately. This works pretty well, but when changing the axis bounds, it seems to change the plot area ever so slightly. Also, some axes have units with more digits than others, so the numbers are touching the y-axis label, so I'd like to resize the plot areas to make them narrower, leaving the right edge of the plot stationary and only moving the left.

Any ideas on how to accomplish this? Also, is there a way to define axis bounds to be different from the actual axis units displayed. For example, have an x-axis bounded from -5 to 105, but have it labeled from 0 to 100?

I took a quick look using the old record what you want done and see in the VBA can be fixed to do exactly what you want. I adjusted a plot area and got this:

Please Login or Register  to view this content.

So you can adjust plot area in VBA. And I'll be doing so myself when I get some more time.

I align my charts (ivba) and plot areas (manuall for now) to row and column boundaries. This allows transparent chart and plot areas to have cell interior colours show through (and other stuff).
To do alignment this way you need to know that rows ahve .height and .top properties; columns have .width and .left. Find the rows and columns by tedious but simple code and Bob's your uncle.