Possible to add text from a Cell?
 

I know I can choose a text box to add fixed text in a chart but is
there a way to add text from a cell that can vary directly from the
workbook (e.g. from cell A1)?

Insert your text box, select it, and then in the formula bar type your cell
address e.g. =Sheet1!A1

You can concatenate your own text to it as well such as ="Total: "&A1
--
Thanks,
Christopher

This posting is provided "AS IS" with no warranties, and confers no rights.


" wrote:

I know I can choose a text box to add fixed text in a chart but is
there a way to add text from a cell that can vary directly from the
workbook (e.g. from cell A1)?

Christopher Scott [MSFT] wrote:

Insert your text box, select it, and then in the formula bar type your cell
address e.g. =Sheet1!A1

Even easier: just select the chart, press the equals key, and click on the cell you
wish to link to.

You can concatenate your own text to it as well such as ="Total: "&A1

Such formulas only work in the worksheet. In the link formula of the textbox, you
can't build a formula like this, but only a link to a worksheet range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Yeah, you're right. Thank you for clarifying that. With charts most things
need to be done on the sheet itself.
--
Thanks,
Christopher

This posting is provided "AS IS" with no warranties, and confers no rights.


"Jon Peltier" wrote:


Christopher Scott [MSFT] wrote:

Insert your text box, select it, and then in the formula bar type your cell
address e.g. =Sheet1!A1

Even easier: just select the chart, press the equals key, and click on the cell you
wish to link to.

You can concatenate your own text to it as well such as ="Total: "&A1

Such formulas only work in the worksheet. In the link formula of the textbox, you
can't build a formula like this, but only a link to a worksheet range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______