Welcome to yEd Q&A!
Here you can ask questions and receive answers from other members of the community and yEd developers. And you can tell us your most wanted feature requests.


hierarchical layout - child node ordering when importing from excel

0 votes
Dear support team,

Is there a way to influence child node ordering (e.g. alphabetically sorted by Label text) when importing a graph from excel? Even a workaround would be welcome (but manually repositioning edges and modifying constraints is too cumbersome).

thanks in advance

in Help by

1 Answer

0 votes

Unfortunately, there is no way to influence the left-to-right ordering of nodes in a top-to-bottom or bottom-to-top hierarchical layout when importing a graph from Excel.

The only workaround available is using a two-pass approach (which does need some manual repositioning of nodes in step 2):

  1. Import your data from Excel with "Layout" set to "Hierarchical" on tab presentation.
  2. Right after importing, reorder the nodes manually. You need to make sure the nodes do not overlap, but otherwise it suffices to place them at roughly the desired location (no need for pixel-perfect placement).
  3. Run the Hierarchic Layout once more but with option "Use Drawing As Sketch" on tab "General" enabled. (Note, you may not have this option enabled when initially importing data from Excel.)
by [yWorks] (151k points)
Legal Disclosure | Privacy Policy