+ Reply to Thread
Results 1 to 2 of 2

Smart Art Org Chart Add New Root

  1. #1
    Forum Contributor
    Join Date
    08-19-2010
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    151

    Smart Art Org Chart Add New Root

    Hello,

    I have employees table with the following fields (Excel 2010):
    field1, employeeID, ManagerID, field3, field4, field5, EmployeeName.

    The following code generate smart art org chart.
    My problem: If the are more than 1 root it does not add the second root in level 0 (separate tree).

    How can I force new tree for each root ?

    Thank you for your help

    Please Login or Register  to view this content.
    Last edited by Snoopy2003; 01-15-2012 at 05:36 PM. Reason: smart art instead of smart draw

  2. #2
    Registered User
    Join Date
    06-08-2012
    Location
    Ottawa, Ontario
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Smart Art Org Chart Add New Root

    Because your cell 2 needs to be the Parent ID(PID) in your case ManagerID and cell 3 needs to be the Subordinate in your case EmployeeID

    if you change (Line, 2)
    to (Line, 1) =====> Your ManagerID
    you can get rid of field1

    if you change your (Line, 3)
    to (Line, 2) =====> Your EmployeeID

    if you change (Line, 6)
    to (Line, 3)

    You can have all your information side by side and the code will be a bit clearer for you.



    *****I know this is very old but I replied because I found this post recently, used what I needed and thought I would make it easier for others*****
    Last edited by joltjunkie; 03-13-2014 at 10:48 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1