To change chart default title, set the Text property of the ChartTitle object, which represents the chart title : Chart Title « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Chart Title

To change chart default title, set the Text property of the ChartTitle object, which represents the chart title

 
Sub charTitleText()
    ActiveChart.ChartTitle.Text = "Industrial Disease in North Dakota"
End Sub








Related examples in the same category

1.Adding a Chart Title
2.To position the title, set its Top property (specifying the number of points from the top edge of the worksheet) and its Left property (specifying the number of points from the left edge of the worksheet)
3.To format the text of the title, work with its Font object
4.Seaching for Charts Using the Chart Title