Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

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


  7. #7
    Join Date
    2nd May 2014
    Posts
    1

    Re: Create Visual Hierarchy similar to an org chart

    Hi guys, I have similar but different issue.

    I am making organisational chart. And I was thinking of pivot, however my input data sem not to be enough for what I want. I have column: Name Column2: Reports to and Column 3: Completion ratio of trainings.

    Now when I make a pivot out of it, I fail to make subgroups, for example click on CEO I get VPs, when I click VPs I see senior managers. In my view, everything is separate. Here the simple example.

    I really hope I dont need to manually insert 3-4 new columns with who reports further to whom, when it is already in table. org chart.xlsx

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,489

    Re: Create Visual Hierarchy similar to an org chart

    Hi mashnica - You are welcome to the forum, but please start a new thread for your problem ....

    This is what the two previous posts to yours was referring to ("thread hijack"), and it also applies to you

    Cheers
    Ger
    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont.

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

    The BEST Lookup function of all time

    Dynamic Named Ranges are your bestest friend

    _______________________________________________

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