How to control routing of Elbow Connector?

I'm trying to use Elbow connectors (in Excel 2003) to show how one row of a spreadsheet is re-directed to another. I want the connector to run horizontally for a short bit, then go vertically for a longer span to another row, then have a short horizontal segment with an arrow pointing into the new row.

When I place the elbow connector in a more vertical aspect ratio, it configures itself to have a long vertical run, a short horizontal run, then a long vertical run. This doesn't work since "ends" that are supposed to show the connection to spreadsheet rows are vertical.

How can I configure the elbow connector to remain in the horizontal-vertical-horizontal configuration regardless of the aspect ratio of the endpoints? Format Autoshape offers no help. Rotation is grayed out.

What you need is a right brack rather than an elbow.

This code will add and format a bracket between 2 cells.

Please Login or Register  to view this content.

Andy,

Thanks for the macro code. It works, but the shape is not what I'm looking for. It goes right, down, left. (like the "]" character). I want a shape that goes right, down, right. (More like a "Z" with the diagonal stroke straightened)

Here is an ASCII version of the shape I'm trying to get:

--
|
|
|
|
|
-->

Can a bracket be adjusted to have one end point left of the vertical while the the other end points right?

I see what you mean now.

The direction of the horizontal/vertical line is dependent upon the ratio of the H/V lengths. If you make the shape wide enough the lines will flip.

Try using a freeform shape.

Please Login or Register  to view this content.

If you release the mouse between points when using freeform you will get the straight lines. If you keep the mouse button pressed it acts more like the scribble tool.