graphically scaling dimensional arrows
Posted by Jason on July 18, 2000 11:38 AM
I have written (with some great pieces of advice from ryan) a pretty complex excel setup that automatically determines optimum layouts for circuit boards and then draws them out by manipulating the cell sizes. It is working great with one exception, I cannot get the drawings (made by expanding/shrinking a cell and applying borders) to show dimensions. I have tried concatenating the value I need between the Symbol font's characters of the left and right arrow. But I can't get it to appropriatly scale. For any set of steps it would highlight a calculated number of cells in a row, merge them into one large cell, place hard borders on the left and right sides, and ideally fill in the value with arrows stretched until they touch the side borders.
Currently, mine will do this:
| <- 35.43 -> |
But I am looking for something closer to this:
|<------ 35.43 -------->|
The sizes of the cells change pretty dramatically, and my first idea of having the value and one arrow on each side and a huge font size and telling the cell to scale to fit looks ridiculous when the cell is large.
Any ideas would be greatly appreciated.