| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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)? |
|
#2
|
|||
|
|||
|
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)? |
|
#3
|
|||
|
|||
|
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/ _______ |
|
#4
|
|||
|
|||
|
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/ _______ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
| Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) | |||
| Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
| Moving text from one cell to another. | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
