Code to format all graphs to position and size all charts

Hi everyone!

I've been trying to work on a code to help me size and position my charts as done in the attached Excel file.

Some steps I want to be done is to make all charts 10cm (height) by 15cm (width), place them in rows 8, 13 and 18 (if needed for more rows) and in alternating columns, e.g. B, D, F. I also want the charts to be exactly the length of in between columns apart e.g. C, E, G which is set at Column Width 2.

I have found a code off vbaexpress.com that uses MsgBox to prompt how many columns and rows to format the charts in but it does not give me the spacing between charts that I want.

This is the code:

Please Login or Register  to view this content.

Many thanks in advance!!