Text Box question

[rrucksdashel]

I have a Text Box floating over a chart to highlight certain data. Is there a way to have a number in a text box reading from another cell? That way I don't have to remember to change the answer in the text box as the cell changes.

Thanks for your help.

[oldchippy]

If you have a number in a cell, draw a Text Box, then click inside the text box to select it, then place the cursor in the formula bar, press = then click the cell you want to refer to.

[rrucksdashel]

If you have a number in a cell, draw a Text Box, then click inside the text box to select it, then place the cursor in the formula bar, press = then click the cell you want to refer to.

FABULOUS. Does that not work the same way for Title Boxes on Charts?

[oldchippy]

Yes, try it