Dynamic Powerpivot Chart Title

[peter789]

I am using Excel 2016. I have created a powerpivot chart directly from a table in the Data Model. I would like to link the Chart Title to a cell in the Spread Sheet. If I try e.g. = $A$1 and type enter in the formula bar with the title selected the formula disappears and the title doesn't change. Can anyone help please?

 

[mole999]

are you trying to do that in the text box or the formula bar (with the text box selected), experience says one works, the other doesn't but I can't remember which

 

[peter789]

are you trying to do that in the text box or the formula bar (with the text box selected), experience says one works, the other doesn't but I can't remember which

I've tried both methods. Typing direct in the box just seem to keep the formula as text; selecting the box then typing in the formula bar has no result when I press enter. As a test I have tried creating a normal chart on the same sheet and the formula works fine.