Cell referencing on a chart

  • Thread starter Thread starter McDonn3ll
  • Start date Start date
M

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.
 
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
 
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
_______

Bernard said:
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
Click to expand...
 
Back
Top