Can a text box on a chart be locked to an X-Y coordinate location on the chart?

T

THOMAS CONLON

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!
 
M

mrice

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart x axis Col A, Y axis Col b 0
Move Chart with Text 0
Possible? Variable X and Y data sources and Auto Charting 0
Reversing Dates Sequence along X axis in a chart 3
Automatic Way to have Equal Scales on X-Y Plots ? 0
Word OLE to check spelling in text box 1
Bar Chart With Custom Labels On X and Y? 0
Scatter chart with categories on x-Axis 2

Top