below macro, courtesy of ssaqibh from EE, adds the terms 'New grading system' on a new line to all existing chart titles on the active worksheet.
Is it possible to format this new line 'New grading system' different from the rest of the chart title by means of VBA. This line 'New grading system' should have Verdana, 6 pt, bold.
Help is much appreciated. Thank you very much in advance.
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"