Re: Multiple 'Connector' Overlapping

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rob van Gelder (newsgroups_at_nojunkmail-vangelder.co.nz)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 20:37:38 +1300

If you're after another graphing solution:
http://www.research.att.com/sw/tools/graphviz/

I've used it with DirectPrecedents to graph very large worksheets, with some
success. 

-- 
Rob van Gelder - http://www.vangelder.co.nz/excel
"Dick Kusleika" <dickk@paragonUNMUNGEconstructioninc.com> wrote in message
news:uL0wYGfBEHA.2768@tk2msftngp13.phx.gbl...
> Tom
>
> I don't think so.  I think each shape has a fixed number of connection
> points and each connector is going to go to one of those points.  Here's a
> couple of options to consider:
>
> You can use lines instead of connectors.  You will, of course, lose the
> advantage of using connectors.
>
> You can adjust the pattern of the line.  Create a line that comes straight
> down from a shape.  Select the line and from the Drawing toolbar, click
> Arrow Style and More Arrows.  In the dialog, go to the Color dropdown and
> select Patterned Lines...  Select a vertical lined pattern and click OK.
>
> Back in the dialog, set your Weight to 9pt for three lines (it appears to
be
> 3pt per line that you want to appear using the vertical pattern that I
> selected - you'll have to experiment).  Then make connectors connect to
the
> bottom of the patterned line.  I wasn't able to get those lines to match
up
> perfectly, which may be a problem.
>
> The only way I could get the lines to match up perfectly is to use lines
> coming away from the shape (not connectors) and attach connectors onto the
> end of those lines.  You can make those lines really short and because the
> connectors attach to the line and not the shape, you can get close
parallel
> connectors.  Making those lines, especially short ones, is tough.  And
> depending on what you want to do with the connectors, you may lose
something
> by not having them connect directly to the shape.
>
> That's all the options I can think of, and they all stink.  Sorry I
couldn't
> be of more help.
>
> -- 
> Dick Kusleika
> MVP - Excel
> www.dicks-clicks.com
> Post all replies to the newsgroup.
>
> "Tom Rudski" <anonymous@discussions.microsoft.com> wrote in message
> news:92f501c4057a$05ef62e0$a001280a@phx.gbl...
> > When using multiple 'Connector' the lines(connectors) all
> > merge on top of one another.  Any way to separate the
> > lines so you can see all of the line (i.e. '| | |')
> > instead of (i.e.'|')? You can control graph separations by
> > controlling an width option.  Anything like that with
> > Connectors?
> >
> > TIA
> >
> >
>
>

Relevant Pages

  • Re: Problem with Connectors
    ... To change the line to solid, select it, go to menu bar> Line Pattern icon> ... multiple parents and need to add a lot of dotted line connectors there is ... Double click the dotted-line report to ... Select the line in the new window, change the line pattern. ...
    (microsoft.public.visio.general)
  • Re: Making the dynamic connector line style appear as double lines
    ... The application of these connectors is to use center-to-center object ... The problem I am having is, especially in the case of the tripple line, the ... center of the pattern is perpendicular to the ... thus clipping the connectors with the ovals themselves. ...
    (microsoft.public.visio.developer.vba)
  • Re: Why do my line jumps dissapear when I use a custom line pattern on dynamic connectors?
    ... I just created a "double-line" pattern in Visio 2003 and applied it to ... connectors. ... Pattern Properties might affect the jumping to some extent - do you ... Does the patter have gaps that happen to appear where the line jumps would ...
    (microsoft.public.visio.general)
  • Re: Can change line color but not ends in Visio 2003
    ... Some of the connectors in the Database Model Diagram template have guards ... against adding a line pattern or end point to them (for example the ...
    (microsoft.public.visio.general)
  • Re: graph layout algorithm
    ... I am representing a process flow using a graph. ... I have the visual representation of nodes and connectors. ...
    (comp.theory)