Change Graph Title via VBA

[Bazman76]

Hi there,

I want to set the graph title to the string stored in a given cell (the cells and strings will change)

I tired this but is just isn't working

ActiveChart.ChartArea.Select
With ActiveChart
.HasTitle = True
.ChartTitle.Characters.Text = Cells(3, 10)
End With

 

[njimack]

Sub Title()
ActiveChart.HasTitle = True
ActiveChart.ChartTitle.Text = ActiveSheet.Cells(3, 10)
End Sub

 

[Bazman76]

The cells I need are on a different worksheet "sheet2" can I switch sheets midway through updating the graph?

 

[njimack]

The cells I need are on a different worksheet "sheet2" can I switch sheets midway through updating the graph?

Just change ActiveSheet to Sheets("Sheet2")

 

[Bazman76]

Just change ActiveSheet to Sheets("Sheet2")

Perfect thats it thank you