Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.