+ Reply to Thread
Results 1 to 5 of 5

Organogram Excel relations

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    Munich, Germany
    MS-Off Ver
    Excel 2016
    Posts
    11

    Organogram Excel relations

    Hey there,


    I would like to create a simple organogram. I can’t use the SmartArts in Word because they don’t offer the flexibility I need for this organizational chart.

    So I started this project in Excel by integrating simple text zones. But unfortunately I cannot handle it well.

    E.g. I cannot find any arrows for emphasizing the relation between different people. Making the border lines of the cells bigger does not seem to be a solution because I cannot adapt them properly and every time I move one of these lines, the whole text zones with the people names are also moving (because in reality, I am moving Excel cells and not just lines or arrows).

    Also I would like to put groups of people in “boxes” in order to underline their function (see e.g. “équipe de production” or “support” in the screen shot).

    I attached my attempt and the old organogram(the screen shot) so that you can visualize the problem.


    If you have any ideas how to resolve these problems, I would be quite happy!



    Thanks a lot in advance,
    Simon
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Organogram Excel relations

    How about Visio?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Organogram Excel relations

    what about smart art under insert
    Attached Files Attached Files
    Last edited by martindwilson; 11-11-2013 at 10:31 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Registered User
    Join Date
    10-08-2013
    Location
    Munich, Germany
    MS-Off Ver
    Excel 2016
    Posts
    11

    Re: Organogram Excel relations

    Thanks for your answers!

    I didn't want to use the Smart arts because I could not manage to put the "arrows" in the right position, neither couldn't I change their coulor. And also it was not possible to have severals name beneath another row of names who are part of the same level of hierarchy (because I couldn't remove these lines), like in a sort of box.

    And I unfortunately I don't have Visio.

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Organogram Excel relations

    you can change the colour of the lines add arrows to either end just a question of playing with it, first time i ever saw it was about 1 and 1/2 hours ago add text box all sorts of stuff see attached
    Attached Files Attached Files
    Last edited by martindwilson; 11-11-2013 at 11:05 PM.

+ 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. Creating an add-in: References and Relations
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2012, 04:50 PM
  2. Excel 2007 : Work Sheet-Reference Relations
    By mazda06 in forum Excel General
    Replies: 2
    Last Post: 02-12-2011, 07:20 PM
  3. Data Validation Relations
    By Laurentius in forum Excel General
    Replies: 5
    Last Post: 05-13-2010, 01:38 PM
  4. Macros Relations
    By pierre08 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2010, 04:35 AM
  5. Relations between cells - how to point them?
    By Rinocerinho in forum Excel General
    Replies: 2
    Last Post: 02-13-2010, 05:56 PM

Tags for this Thread

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