run macro on selected charts (resizing the chart area as well as data labels)
Posted on 2014-01-20
for the selected charts on the active worksheet I would like to run the following VBA macro:
- Resize the charts to Width of 5 cm and Height of 9 cm
- Increase the size of the chart labels (all of them are pie charts) to 10 pt and font type 'Times New Roman'
Help is much appreciated. Thank you very much in advance.