asked on Add a term to all titles of all the charts on the active worksheet
Dear Experts:
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.
Regards, Andreas
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.
Regards, Andreas
Microsoft Excel
Last Comment
Andreas Hermle
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi ssagibh:
great job. Thank you very much! Works great.
Regards, Andreas
great job. Thank you very much! Works great.
Regards, Andreas
thank you very much for your great and professional help. Works like a charm.
Regards, Andreas