Dynamic textbox

[Zurn]

In a textbox, added to a chart, I want to put values and text fro
cells. Is this possible?

For example:

cell: hair color:_____

In the textbox in a chart: Girl has _____ as hair color

 

[Tom Ogilvy]

If the text you show is in a cell, you can add a textbox from the drawing
toolbar. then with that textbox selected, go to the formula bar and enter
=Sheet1!A1

and the textbox should be linked to the text in A1 of Sheet1. You can not
put in a formula like

="Hair color:" & Sheet1!A1

directly in the textbox (using the formula bar or otherwise). So all the
text you want to display would have to be displayed in Sheet1!A1 (in the
example).