View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Dan Tabla[_2_] Dan Tabla[_2_] is offline
external usenet poster
 
Posts: 51
Default Align a text box paralel to a line

Sorry for ambiguity.
"Paralet" I actualy tryed to type PARALELL.
I have this given pairs of points by A(X1,Y1), B(X2,Y2), C(X3,Y3)
coordinates and electrical cable types that conect the points.
Paralel to the line that conects the points I have to put the cable type
that is diferent from a segment to another.
If is not to detailed, I would appreciate your help.
My question should be: there is any function to rotate my text box for each
cable segment and place the text box paralel and in the middle of the
segment?


"Jon Peltier" wrote:

I presume you mean align the textbox parallel to an inclined (non-horizontal
and non-vertical) line. I would do it using VBA.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dan Tabla" wrote in message
...
I'm using VBA to generate a grafic between pct. A,B,C...
I wonder if there is a way to put paralet to the line that conects
the points, text boxes that should show the distance between
points.