+ Reply to Thread
Results 1 to 4 of 4

tree diagram of categories

  1. #1
    Registered User
    Join Date
    09-08-2012
    Location
    Andover, UK
    MS-Off Ver
    Excel 2010
    Posts
    43

    tree diagram of categories

    Hi,

    I have a structure of 3 catogegories for people to define what issues are in the factory.
    the first being asset which displays the list of the assets on that line. this then branches into components of that asset, and then each of those components branches into possible issues.

    so its like

    Asset Compoonent Issue

    machine1-----infeed------------>Carton Jam
    ----------->damaged part
    ----------->wrong setting

    ------outfeed ------------>Product Jam
    ------------>Breakdown

    --------assembly 1 --------->sensor wrong
    --------->machine not set correctly

    Is there an easy way to get a diagram of this without needing to type it all in manually?
    They are all tables in Access
    so there is a table with assets. there is a field called line 1, and the entries are all the assets. then a table calle dcomponents, in that table there is a field for asset listing the components, then a table called issues, with a field for each component listing the issues.

    What I am looking to create is a tree diagram for each asset that will then show the options people can make.

    Any help is greatly appreciated.

    Alan

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: tree diagram of categories

    .
    You can edit this project to fit your needs. This is only part of the code :

    Please Login or Register  to view this content.
    You can also accomplish your goal by use of PIVOT TABLES. There are examples on the internet.
    Attached Files Attached Files
    Last edited by Logit; 09-24-2019 at 08:47 AM.

  3. #3
    Registered User
    Join Date
    09-08-2012
    Location
    Andover, UK
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: tree diagram of categories

    That's awesome ,

    thank you

    All I need to do is just build a table of each one in the pattern I need and it will draw it exactly.

    Great cheers ;-)

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: tree diagram of categories

    .
    You are welcome.

    Looking around the 'Net there are examples using a Pivot Table. That is another option.

+ 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. Excel table equivalent to tree diagram
    By scottbole in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2019, 09:46 PM
  2. Excel Tree Diagram from Data Using VBA
    By jgray in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2019, 06:13 PM
  3. VBA- Copy cells incl. Diagram and update diagram reference
    By Julian91 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2018, 07:03 PM
  4. Loop excel files and sort it in a tree diagram
    By Afandi1992 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2015, 08:01 AM
  5. [SOLVED] Excel Diagram: bubble diagram with dynamic quadrants
    By meiselsan in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-27-2015, 08:26 AM
  6. Creating a tree diagram from a 5-column matrix
    By phrankndonna in forum Excel General
    Replies: 4
    Last Post: 05-13-2014, 08:59 AM
  7. 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

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