Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Create Visual Hierarchy similar to an org chart

  1. #1
    Join Date
    7th November 2005
    Posts
    5

    Create Visual Hierarchy similar to an org chart

    Hi

    I would like to convert data in two columns, which lists an item and it's parent, into a visual hierarchy showing the relationship between products, similar to an organisation structure.

    I am finding this quite hard to explain. Please see the attached xls as this shows what i am trying to do.

    Please could someone give me some ideas about how to proceed.

    cheers

    Ed
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    16th June 2004
    Location
    Canada Quebec
    Posts
    260

    Re: Create Visual Hierarchy similar to an org chart

    Hi

    I would use a pivot table, see attachement
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    7th November 2005
    Posts
    5

    Re: Create Visual Hierarchy similar to an org chart

    Thanks for the reply, I hadn't thought of pivot tables. However I realise that i didn't post enough sample data, as i expect to have more than two levels of hierarchy, would i be able to this still with a pivot table.

    eg
    Foodstuffs>Fruit>Apples>Braeburns

    Ed

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    16th June 2004
    Location
    Canada Quebec
    Posts
    260

    Re: Create Visual Hierarchy similar to an org chart

    Hi ed

    Yes you will be able to use a pivot table. In doubt post a larger sample of the work sheet and we will have a look at it.

    Thanks
    Denis

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    10th February 2003
    Location
    Palm Beach, Florida
    Posts
    1,590

    Re: Create Visual Hierarchy similar to an org chart

    How's this?

    Making it work for any number of hierarchy levels was a real bear. I had to use a recursive subroutine and I think I might've hurt my brain in the process.

    It's not exactly what you asked for, but it's pretty darn close! For each item listed it recursively traces thru the parents in the heirarchy and lists them.

    If you try to modify it and/or can't get it to work outside of my example, you might just be on your own. I think I'm gonna go sit in the corner now and tremble for awhile...
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Sub All_Macros(Optional control As Variant)

  6. #6
    Join Date
    7th November 2005
    Posts
    5

    Re: Create Visual Hierarchy similar to an org chart

    aaron, if there wasn't an ocean between us, i'd come over and hug you now. This does exactly what i wanted. Cheers you've saved my weekend.

    Ed

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. ACC: How to Create Custom Domain Function Similar to DCount()
    By Dave Hawley in forum Excel Formulas (No Questions)
    Replies: 0
    Last Post: June 21st, 2008, 02:50
  2. Create Parent Child Relationship From Hierarchy
    By gtg688h in forum EXCEL HELP
    Replies: 6
    Last Post: February 7th, 2008, 21:44
  3. Replies: 8
    Last Post: October 26th, 2005, 03:13
  4. Create A Macro in Visual Basics VBAProject
    By Stapuff in forum EXCEL HELP
    Replies: 3
    Last Post: December 24th, 2004, 16:01

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
  •  
porno