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:
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.
Bookmarks