Cell referencing on a chart

[McDonn3ll]

I would like to be able to reference a cell in a textbox on a chart.
Ex.
Cell A1 value = "12"

Text box on chart = "12"

I need to be able to change cell A1 and have the textbox change with
it.

Please give me advice on how to do this. Thanks.

 

[Bernard Liengme]

1) Click on chart to activate it
2)In formula bar, type =
3) Use mouse to point to a cell (formula now reads =Sheet1!A1
4) Click green check mark in Formula Bar to complete
5) Drag resulting text box to required position, format to taste

Best wishes
Bernard

 

[Jon Peltier]

FYI, Bernard's technique also works with chart titles, axis titles, and
data labels on a data point. Select the text item, then press = and
click on the cell with the mouse.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

1) Click on chart to activate it
2)In formula bar, type =
3) Use mouse to point to a cell (formula now reads =Sheet1!A1
4) Click green check mark in Formula Bar to complete
5) Drag resulting text box to required position, format to taste

Best wishes
Bernard