Linking a chart title to a cell

[Helen]

Is it possible to link a chart title to a cell, so when the cell changes so does the chart title?

Thanks for your help
Helen

 

[gnaga]

Possible try the the following code

Private Sub Worksheet_Change(ByVal Target As Range)
ThisWorkbook.Worksheets("Sheet1").Activate
Charts(1).ChartTitle.Caption = Range("A1")

End Sub

Assuming you have cahrt as object in your Sheet1 and the charttitle in Cell A1

GNaga

 

[Sir Vili]

Hello Helen.

Manually You can do this way:

Draw a TextBox on sheet. When You have activated that TextBox, then on Formula Bar give formula =A1. Then place TextBox on chart.

By changing text in A1, changes also contents of TextBox. Of course You can format that TextBox also.

Best Regards Sir Vili.

 

[Mark W.]

See the Excel Help topic for "Link a chart title or text box to a worksheet cell".

 

[Helen]

Cheers everybody!