Text Boxes and cell references

Question

Is there anyway to use cell referencing in a text box.  For instance, I want to add a text onto a chart that can be updated whena change to the excel spreadsheet occurs.  A text box that says "Size of test group = 'A1'"  where A1 is a cell reference.  Change the number in cell A1 and that changes the data that is displayed on the chart, but how do I show the change (with additional text like "Size of test group =") elsewhere on the chart.

Answer 1

You can link chart text items, such as title, axis title or data labels to cells.

http://www.andypope.info/tips/tip001.htm

The same approach can be used to link autoshape textboxes to a cell.

You will need to use a helper cell to build the text and value parts. So assuming the value is in A1 you could use the following in B1 and link that cell to the textbox

B1: ="Size of text group = " & A1

---

Cheers   www.andypope.info