Chart title

O

OO7_neverdie

Can someone show me how to insert (using VBA) Chart title after created
a chart

Thank you very much
 
K

Kieran

007_neverdie

Something like :

Sub AddTitleToChart()
'
ActiveChart.PlotArea.Select
With ActiveChart
HasTitle = True
ChartTitle.Characters.Text = "the title"
End With
End Sub
 
Top