Referencing a cell within a chart-title

[Es123]

Hello,

I'm trying to reference a value from a cell or just like the current date to be shown within a chart, actually a very simple thing.
There are solutions on the net one would think of but hey don't work. I have Excel365.

using ="Some text " & I91 as a chart title should actually work just like "=Today()" as text within a Label added to the chart. Solutions on the net tell its working but my Excel just shows the typed text not the date or referenced cell value. I didn't see any configuration to tell Excel not to resolve the typed text. What do I miss here?

Thanks for any hint

 

[RoryA]

It looks like you entered that text in the chart title itself, not in the formula bar. You can link to cells by selecting the chart title (not entering the text edit mode of the title, just select the edge of it) then click in the formula bar, type = and select the cell you want.
I do not believe you can combine text and a cell reference at the same time in the formula link. You either need to have another cell that produces the actual result you want, then link to that, or you need to use a defined name.

 

[Es123]

It looks like you entered that text in the chart title itself, not in the formula bar. You can link to cells by selecting the chart title (not entering the text edit mode of the title, just select the edge of it) then click in the formula bar, type = and select the cell you want.
I do not believe you can combine text and a cell reference at the same time in the formula link. You either need to have another cell that produces the actual result you want, then link to that, or you need to use a defined name.

Selecting the edge of the chart-title and entering the text in the formula bar as suggested gives me this.

 

[Es123]

ok, adding the sheet-name it works (=CL!$I$91)

Thank You

 

[RoryA]

The reference needs to include the sheet name, which is why I suggested you select the cell.