Below code formats the plot area for the selected chart.
I would like to run this code not only on the active chart but on all the charts of the active worksheet named
as follows "MyChart##", ## stands for '0-9', i.e., e.g. MyChart01, MyChart02, MyChart04, MyChart10, MyChart23, MyChart99 etc.
Help is much appreciated. Thank you very much in advance.
'Formatting the plot area for the selected chart
.PlotArea.Left = (.ChartArea.Width - .PlotArea.Width) / 2
.PlotArea.Top = Application.CentimetersToPoints(1.8)