If I want to position empty xlXYScatterSmooth charts on a sheet, say 100 of them with a specific size and positioning, how do I do it at one go?
For example, if I want the first chart to be placed in A6 to H26.
The next one to be placed in A30 to A50, etc..
The interval between the end of one range and the start of the next is always constant i.e. 4 rows in this example.
I want these charts to be called "Chart 1", "Chart 2", "Chart 3", etc..
Bookmarks