+ Reply to Thread
Results 1 to 5 of 5

Creating a tree diagram from a 5-column matrix

  1. #1
    Registered User
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    82

    Creating a tree diagram from a 5-column matrix

    Matrix to Tree Diagram.xlsx

    Hi. I'm hoping someone can help me with figuring out how to convert a 5-column matrix spreadsheet into a tree diagram. I've attached an example of the format for our spreadsheet. There is a main category and 4 potential sub-categories. I've looked into this, and it seems to be along the lines of an org chart type thing, but I can't seem to figure out how to set up the spreadsheet, or if I can just take what's there and do what I need. This spreadsheet will be updated fairly often, so I'll want to be able to convert it to a tree diagram pretty much at will. Is there an embedded Excel feature that might do this that I'm not aware of, or would this possibly take a VBA approach to complete? Thanks for any advice.

    Frank

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Creating a tree diagram from a 5-column matrix

    Create another sheet called "Diagram" and run the following code. It should work with any number of category columns.
    Please Login or Register  to view this content.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

  3. #3
    Registered User
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: Creating a tree diagram from a 5-column matrix

    Hi! Thank you for this! It does indeed work to put the data into a heirarchial format within Excel. However, what I'm trying to achieve is the ability to take this data and turn it into a more graphical 'organizational chart' type tree diagram. From what I've been able to find, I can do this using Visio with an Excel workbook, but the data needs to be formatted just so. Please see attached. Our data starts out in the format that I attached in my initial posting. So, is there a way to do a graphical tree diagram presentation in Excel using the data in its initial format?

    Thanks.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Creating a tree diagram from a 5-column matrix

    I don't think I can help you in that direction. I'm sure code could be written to use borders to create the lines and boxes, but it would take more time than I have available. Maybe someone else knows of some tools available. Sorry.

  5. #5
    Registered User
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: Creating a tree diagram from a 5-column matrix

    No worries at all. I greatly appreciate the time you have already taken. And, this may very well still be a workable approach. Thank you!

+ 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. Populate a 'Tree diagram' with x variables quickly.
    By alkj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2013, 11:28 AM
  2. Creating a diagram
    By ecawilkinson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2010, 06:59 AM
  3. Creating a diagram
    By nicodam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-18-2009, 11:31 PM
  4. Creating a tree
    By mitelkm in forum Excel General
    Replies: 1
    Last Post: 10-08-2007, 02:56 PM
  5. [SOLVED] Need a Matrix diagram - Please help
    By DTTODGG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2006, 10:15 PM

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