Position chart text with code?

[m_woolf]

I know that when you insert Text in a chart, you can hold down Ctrl+Shift and drag the text to the desired postion.

Is it possible to write a mcro to position the text?

[disqr_rm]

Interesting!!! What could be usage of this requirement? Just curious, I guess.

Another option you can have a drawing a separate textbox overlaying on top of the chart. This might be easier in macros rather than manipulating text in a chart.

[m_woolf]

The charts are resized with code. When they are enlarged, the text in chart needs to move to a new location ( and possible be enlarged as well).

I may solve this by having two charts. A small version and a large version and then show or hide them as required.

Thanks for your reply.