Embed a Control Textbox into a Chart

Describe the "series of cells".

I'm trying to link data from the spreadsheet into the text box. For example if you create a simple textbox from the drawing menu and type in the formula bar =a1:a2 the value in cell a1 will appear in the text box (but not the value in cell a2). If however you create a text box from the control toolbox menu and do the same thing (replace the Embed("Forms.TextBox.1","") with a1:a2) the values and formats of those multiple cells become linked to this text box. This is exactly what I need EXCEPT I can't lind the control toolbox created textbox to a Chart. Does this make sense or did I confuse the issue even more?

Check this suggestion:
http://www.mrexcel.com/board2/viewtopic.php?t=254375
I think it will do what you want.

If you want a range comprised of several cells in a single row or a single column, copy the range, then hold Shift while clicking on the Edit menu, and select Paste Picture Link. This pastes a linked picture of the range in the worksheet. Copy this linked picture, select the chart, and paste. This unlinks the picture but places it into the chart. Now select this pasted picture (the one in the chart), click in the formula bar, and restore the formula link, including the sheet name:

=Sheet1!$A$1:$A$2

The end result is similar to that of using the camera tool, but I find camera tool objects on charts sometimes behave a little flaky. This procedure takes a couple of extra steps, but seems more robust.

This looks like it'll work perfectly. Thanks for the input!