Does anyone have any experience building an organizational chart in EXCEL. Yes, I know Powerpoint is the preferred way but that is not an option this time.
Does anyone have any experience building an organizational chart in EXCEL. Yes, I know Powerpoint is the preferred way but that is not an option this time.
Peace of mind is found in some of the strangest places.
I have done workflows in Excel and I am sure at one time or another I have done an organizational chart... Can you tell us what you are having trouble with and then we can try and help you find a possible solution...
thanks
Life is like a jar of jalepenos... What you do with it today might burn your butt tomorrow....
Just need a basic way to get started. If you have an example file could you post it? Thanks
Peace of mind is found in some of the strangest places.
In XP, start by clicking Insert->Picture->Organization Chart. Autoshapes can work too eh.
Regards,
Nate Oliver
i have done them using the autoshapes... Of course - i just got Visio, but havent had the chance to stop and look at it yet to see how it works...
Life is like a jar of jalepenos... What you do with it today might burn your butt tomorrow....
Or Insert --> Diagam ..
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Sorry been away for a while. What I wanted to do is find a way to populate the org chart programatically from a list of names in another workbook. It would be broken down as ex. John Smith President, where the name and title are in seperate cells A1, B1. The same would hold true for managers, subs and so forth. Sorry for the confusion.
Peace of mind is found in some of the strangest places.
austenr,
Here is something that I did a while back, it is not to fancy, but once you set it up for your or. the names can be easily updated.
Anything can be done if we are willing to spend the time to create it.
Hope this get you started.
ETracker
ET