I would like to have a shape object, a "double arrow" (Arrow Style 7) which I will place in a horizontal direction on my worksheet parallel to a defined axis.
I would like to configure the following dimensions of the double arrow by cell input:
1. length of double arrow (e.g. in pixels)
2. horizontal position along axis (e.g. in pixels)
Example: The horizontal axis represents 0 - 720 degrees (720 pixels either represented by one cell width or a number or cells in a row)
1. length of double arrow is 100 degrees (100 pixels)
2. horizontal position is offset 600 degrees (600 pixels) from axis start position at 0 degress i.e. double arrow of length 100 degrees would occupy 600 - 700 degree position
I intend to add a number of such horizontal double arrows at different positions parallel to each other...( a separate row for each maybe)
But first... any ideas on how this can be done... ideally directy on the worksheet (not by chart)
Let me know if you have any questions.
I don't know if there is a simple way to do this without VBA but wouldn't know how at the moment... I think it can definately be achieved with VBA just don't know how
Bookmarks