+ Reply to Thread
Results 1 to 3 of 3

Create Org Chart Mgmt Levels from Table

  1. #1
    Registered User
    Join Date
    02-07-2011
    Location
    Colorado
    MS-Off Ver
    Excel 2013
    Posts
    1

    Question Create Org Chart Mgmt Levels from Table

    I have a listing of 500 employees with one data field that gives the next reporting manager by name but not employee number. Ultimately there are up to six levels of management to get to the Regional manager. What query or structure could I use to create a management hierarchy which will identify the Regional Mgr as Level 1 and all subsequent managers perhaps down to level 6 for every single employee in separate fields. Some intermediate management will obviously only have a few names and not all the way down to Level 6.

    Example below is what i would like where only the first three columns plus last field for immediate reporting mgr is the data i start with but want to add data fields called Level1, Level2, Level3...etc.

    Can't share data due to confidentiality.

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: Create Org Chart Mgmt Levels from Table

    You can use the table and export the data to Microsoft Org. ,or Excel org charts.
    Each person has a Manager field. Then you loop thru the list ,blank managers are on top.
    Then those with that manager are put beneath him., etc.

    It's been a while since I've built it,but I will look for the code.

  3. #3
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: Create Org Chart Mgmt Levels from Table

    You can use the table and export the data to Microsoft Org. ,or Excel org charts.
    Each person has a Manager field. Then you loop thru the list ,blank managers are on top.
    Then those with that manager are put beneath him., etc.

    It's been a while since I've built it,but I will look for the code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create a chart using only certain data from a table
    By ziiviator in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-08-2016, 11:11 PM
  2. Create Levels in Excel table
    By CatharinaCatharina in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-17-2014, 08:46 AM
  3. How to create various circle packing levels
    By ioncila in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2014, 06:33 AM
  4. How to Create Chart on Pivot table.
    By naveen4pundir in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-31-2013, 05:20 AM
  5. Replies: 0
    Last Post: 09-01-2011, 12:07 PM
  6. How do I create a formula for multiple levels of discounts?
    By bearkm02 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2006, 05:15 PM
  7. Can I create a dimension with undefined multiple levels, pivot table.
    By Roberto Hernández in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2006, 02:40 AM

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