Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 5th 06, 06:21 PM posted to microsoft.public.excel.misc
shellshock
 
Posts: n/a
Default Add-in for crossconnects on drawings?


Hi everyone.

Is it possible to improve the drawing facility in Excel with an Add-In
to make it so that crossconnects are possible?

So for example, if you draw a line, and then a draw another line that
crosses the first line, it automatically shows a crossconnect, or a
break, or something to indicate that the lines are not actually
intended to be joined?

This is the kind of thing that Visio makes possible, but it would be
nice if it could be done in Excel as well.

Thanks for reading!


--
shellshock
------------------------------------------------------------------------
shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=548655


  #2   Report Post  
Old June 5th 06, 07:55 PM posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Add-in for crossconnects on drawings?

You can "fake" it by using a small object, such as a circle placed at the
intersection and arrange the ORDER so the circle is in front of one line but
behind the other and use "no line" on the circle.....

hth
Vaya con Dios,
Chuck, CABGx3



"shellshock" wrote:


Hi everyone.

Is it possible to improve the drawing facility in Excel with an Add-In
to make it so that crossconnects are possible?

So for example, if you draw a line, and then a draw another line that
crosses the first line, it automatically shows a crossconnect, or a
break, or something to indicate that the lines are not actually
intended to be joined?

This is the kind of thing that Visio makes possible, but it would be
nice if it could be done in Excel as well.

Thanks for reading!


--
shellshock
------------------------------------------------------------------------
shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=548655


  #3   Report Post  
Old June 5th 06, 08:53 PM posted to microsoft.public.excel.misc
shellshock
 
Posts: n/a
Default Add-in for crossconnects on drawings?


Thanks for your reply.

I know you can fake it, but that would make things even more
complicated if I need to move things around!

What I'm after is something that will automatically crossconnect, so
that if I move one of the lines, the crossconnect goes with it.

I'm guessing this is simply not possible in Excel; that's what real
drawing programs like Visio are for. It would just be nice to have
some of that functionality in Excel too.


--
shellshock
------------------------------------------------------------------------
shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=548655

  #4   Report Post  
Old June 6th 06, 12:48 AM posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Add-in for crossconnects on drawings?

Well, untill something comes along, you can create an "Intersection" and
"group" the three components and then just use it like any other drawing
object.........moving it around at will.......the three grouped objects will
stay together............

Vaya con Dios,
Chuck, CABGx3


"shellshock" wrote
in message ...

Thanks for your reply.

I know you can fake it, but that would make things even more
complicated if I need to move things around!

What I'm after is something that will automatically crossconnect, so
that if I move one of the lines, the crossconnect goes with it.

I'm guessing this is simply not possible in Excel; that's what real
drawing programs like Visio are for. It would just be nice to have
some of that functionality in Excel too.


--
shellshock
------------------------------------------------------------------------
shellshock's Profile:

http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=548655



  #5   Report Post  
Old June 6th 06, 02:44 PM posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Add-in for crossconnects on drawings?

You're welcome, happy to help.........as you say, Excel is not really a
"drawing tool" as such....but with a few tricks, one can produce some really
amazing results, and the conditional formatting can make things REALLY
interesting. Oh yeah, besides the "broken intersection" another neat
thing to make is the one where one line "jumps over" the other, with a
little
arc. Come back again, we don't often get the opportunity to discuss the
drawing-characteristics of Excel here.

Vaya con Dios,
Chuck, CABGx3



"shellshock" wrote:


Thanks for your reply.

I know you can fake it, but that would make things even more
complicated if I need to move things around!

What I'm after is something that will automatically crossconnect, so
that if I move one of the lines, the crossconnect goes with it.

I'm guessing this is simply not possible in Excel; that's what real
drawing programs like Visio are for. It would just be nice to have
some of that functionality in Excel too.


--
shellshock
------------------------------------------------------------------------
shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=548655




  #6   Report Post  
Old June 7th 06, 06:23 PM posted to microsoft.public.excel.misc
shellshock
 
Posts: n/a
Default Add-in for crossconnects on drawings?


The idea of "grouping" objects so they stay together is not something
that's ever occurred to me; thanks for suggesting it. I'll definitely
give that a try.


--
shellshock
------------------------------------------------------------------------
shellshock's Profile: http://www.excelforum.com/member.php...o&userid=24935
View this thread: http://www.excelforum.com/showthread...hreadid=548655



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel drawings with Hyperlink D.Parker Excel Discussion (Misc queries) 2 May 4th 05 12:06 AM
Drawings move during printing 00xPhoenix Excel Discussion (Misc queries) 3 April 19th 05 11:23 AM
HOW CAN I MAKE THE DRAWINGS IN AUTOCAD 1:1 SCALE IN EXCEL-----UP Im not Melvin Excel Discussion (Misc queries) 1 February 18th 05 05:55 PM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017