Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to right-align text and numbers? | Excel Discussion (Misc queries) | |||
Align Line Charts By Milestone Dates? | Charts and Charting in Excel | |||
Need to align text around a symbol??? | Excel Worksheet Functions | |||
How to align text boxes? | Excel Discussion (Misc queries) | |||
How do I align cells in Excel onto one line? | Excel Worksheet Functions |