Moving Text Box with Data

[Greg White]

I have an excel chart that is updated with two new data points per day. On
the chart I have text boxes indicating points of interest for a particular
day. As data is added to the chart, the text box stays in the same location
and eventually need to be manually moved back to the correct date.

Is there any way to link the text box (or a comment) to a particular point
on a chart, such that it moves with the data?

Thanks in advance.

 

[Greg White]

Anyone? Can it be done?

 

[joshuadonner]

Jwalk Chart tools allows you to label an item on a chart with cel
values.

http://www.j-walk.com/ss/excel/files/charttools.htm

You could put the text you want in the text box in a cell on you
worksheet, using a concatenate function to include the cell values tha
change. Then use Jwalk to create the labels, and move and format th
label how you want the text box to look.

I'm sure there is an easier way, but this is what i thought of first.

good luck

 

[Yasmin]

ANother suggestion for keeping the data current ... though I cant think of
one to move it just yet. would be to use the "camera" function. See TOOLS /
Customize / Tools / Camera. This way using range references etc. you can have
it taking a picture of your latest information each time and by pasting the
picture on top of the chart it will remain current.