Automatic update the number in a text box

[Vincdc]

Hello:
I have text boxes in my charts. In that text box, I need to copy a number from another sheet each time I update charts. I am wondering if there is a way that I can update the number automatically.
Thanks in advance!

 

[Jon Peltier]

Is the number in the same cell every time? Here's how to create a new
text box that's linked to a cell (whenever I try linking an existing
text box, Excel just draws a new one on top of the old one).

Select the chart. Press the equals key. Navigate to the other sheet and
select the cell with the mouse. The formula bar reads like:

=Sheet2!$B$2

Press enter.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Vincdc]

Hi Jon:
Thanks for your suggestion!
However, this method only works for 1 number. I always have two numbers to show on each chart. Is there any way to do that?
Thanks again!

 

[Jon Peltier]

(a) Two text boxes
(b) Combine the numbers in another cell, =Sheet1!$A$1&" "&Sheet1!$B$1,
and link the textbox to this cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Hi Jon: Thanks for your suggestion! However, this method only works
for 1 number. I always have two numbers to show on each chart. Is
there any way to do that? Thanks again!


:

e

 

[Jon Peltier]

Then double my previous suggestion. My preference, by the way, would be
to use a separate textbox for each individual number, unless I needed
extra characters in the label.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______