I would like a text box to remain at a particlar location on a chart in
terms of the scale of the chart. So, if new data causes the X-axis or
Y-axis to rescale, the text box remains at the same X-Y coordinate. This
does not seem to be the default behavior, and i cannot find a way to
accomplish it. Please let me know if there is a way. Much thanks!

You could always try recalculating what the new position should be from
the max and min values of the axes and then setting top and left
parameters of your text box accordingly.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=548126