In previous versions of Excel I could create a textbox on my chart and have it reference a value in a certain cell.
In the text box I would type ='Sheet1'!$AT$4. The data from this cell would show up in the box.

I now have Excel 2010 and I am trying to do this and it will not work.

Is there a way in Excel 2010 to still do this?

Thank you