Line to move based on a value????

Try this for "Rectangle 1"
Place the denominator 2,3 or 4 etc. in "A1"

Please Login or Register  to view this content.

Ohh that works very nice. I'll play around with it but it should do the job. My alternative was to setup a chart and move it to the back, but this is much more elegant. Thanks a million. Just for interest its for working with labels. And determining the space you can give to the front or the back.

May I ask one more thing, would there be a code for a button to clear the line? - I apologies this is not the exact forum but certainly follows the thread.

Thanks again!!!!

I just realized that my last request my not be so easy as each time you draw a line it gets a new name. So no problem if its not going to work using a button. Maybe just good old select and delete is what should happen. Anyway love to hear your thoughts. Thanks.

Something like this seems to work:-

Please Login or Register  to view this content.