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

Reversing Dates Sequence along X axis in a chart 3
How can I add a 3rd axis to my chart? 3
Unevenly spaced x axis on chart 1
problem with an Excel chart 1
Coordinate secondary y axis to primary y axis 2
Bar Chart With Custom Labels On X and Y? 0
Question regarding a line chart y axis value. 6
Chart question - how to display 3 series as a bar chart and oneseries as a line 1

Top