Add a term to all titles of all the charts on the active worksheet
Posted on 2012-12-29
I got more than 50 bar charts on the active worksheet (Excel 2010)
Is it possible by means of macro to alter the titles of these charts as follows:
- Go to the end of each title
- press Shift + Enter to enter a manual line break
- add the following term - New Grading System -
So, for example if one of the titles reads: 'Sales force Appraisal'
After running the macro it should read:
Sales force Appraisal
New Grading System
Help is much appreciated. Thank you very much in advance.