Align a text box paralel to a line
 

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.

Align a text box paralel to a line
 

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.

Align a text box paralel to a line
 

Hi,

What exactly is a "paralet"?

And you want a text box that displays the distance between what points? If
you want the linear distance between the plotted points you would run a
calculation in the spreadsheet. For example suppose two point represent
distance in Light Years, do you want to know that distance or are you asking
for the physical distance on the chart? if so, when the chart or plot area
is changed or numbers changed or added the distance will/may change. And if
so do you want the distance in Excel pixels, inches, cm, or what?


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Dan Tabla" wrote:

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.

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?

"Shane Devenshire" wrote:

Hi,

What exactly is a "paralet"?

And you want a text box that displays the distance between what points? If
you want the linear distance between the plotted points you would run a
calculation in the spreadsheet. For example suppose two point represent
distance in Light Years, do you want to know that distance or are you asking
for the physical distance on the chart? if so, when the chart or plot area
is changed or numbers changed or added the distance will/may change. And if
so do you want the distance in Excel pixels, inches, cm, or what?


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Dan Tabla" wrote:

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.

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.