Need help on "Aligning text boxes in a chart sheet"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use VBA to create XY-scatter graph on a seperate chart sheet and plot data
points. I also create a set of text boxes on both left and right side of the
graph. But, on the right side of the graph, the "left" position of the text
boxes are not uniform ( even though I pass same constant value as left point
og each text box ). The text boxes are misaligned automatically.

Can any of you give me a solution for this ???
 
Just a guess, but perhaps you should set the left position of the textboxes
as the last thing in your macro, after the chart is completely built.

You also might play with the "size with chart" settings of the textboxes and
see if this has an effect (protection tab).

Activechart.Textboxes(1).Placement = xlMoveAndSize ' means size with
chart
ActiveChart.Textboxes(1).Placement = xlMove ' means don't size
with chart
 

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

alignment of SOME text in a textbox 10
charts 1
How do I determine the Left & Top coordinates of a graphed point? 2
Place a cell value on Charts 1
Creating a chart with VBA 1
positioning charts 3
Manipulate Text Boxes on Chart 2
Help with forcing chart axes scale 1

Back
Top