Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Solved
Add a term to all titles of all the charts on the active worksheet
Posted on 2012-12-29
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
3 Comments
Active today
Sub chttitles()
For Each shp In ActiveSheet.Shapes
If shp.Type = 3 Then
shp.Chart.HasTitle = True
shp.Chart.ChartTitle.Text = shp.Chart.ChartTitle.Text & Chr(10) & "New grading system"
End If
Next shp
End Sub
For Each shp In ActiveSheet.Shapes
If shp.Type = 3 Then
shp.Chart.HasTitle = True
shp.Chart.ChartTitle.Text = shp.Chart.ChartTitle.Text & Chr(10) & "New grading system"
End If
Next shp
End Sub
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…
Suggested Courses
Course of the Month9 days, 16 hours left to enroll
610 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.