Hello,

I would like to create macro which will autofill organization tree/
diagram.

I have database of Employees:

Name | Surename | Job
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
John | Smith | Manager
Eve | Brown | Process Engineer
Joe | Locke | Product Engineer
....
....
....

I need to build organization tree/diagram in Excel. You can insert
that object from Menu.

It looks something like that:

_____________________
| PRODUCT MANAGER |
| John Smith |
-------------------------------------
|

----------------------------------------------------

| |
______|______________ _____________________
| PROCES ENGINEER | | PRODUCT ENGINEER |
| Eve Brown | | Joe
Locke |
-------------------------------------
--------------------------------------

People from all departmens will have to update those diagrams. Some
departments have abot 50 empleeys. I would like to make it easier, and
faster to operate for all people who will be using this file.

I would like that data will be put into the diagram only by clicking
on the name in the database's table and then on Object. Something on
the "drag and drop" basis.

Anyone have an idea how do it?

Thank you for all advices.

Best regards,
Bartosz Dlugokêcki

Graphics are much better in Power point. Any particular reason why Excel is
being used.

"Bartosz Długokęcki" wrote:

Hello,

I would like to create macro which will autofill organization tree/
diagram.

I have database of Employees:

Name | Surename | Job
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
John | Smith | Manager
Eve | Brown | Process Engineer
Joe | Locke | Product Engineer
....
....
....

I need to build organization tree/diagram in Excel. You can insert
that object from Menu.

It looks something like that:

_____________________
| PRODUCT MANAGER |
| John Smith |
-------------------------------------
|

----------------------------------------------------

| |
______|______________ _____________________
| PROCES ENGINEER | | PRODUCT ENGINEER |
| Eve Brown | | Joe
Locke |
-------------------------------------
--------------------------------------

People from all departmens will have to update those diagrams. Some
departments have abot 50 empleeys. I would like to make it easier, and
faster to operate for all people who will be using this file.

I would like that data will be put into the diagram only by clicking
on the name in the database's table and then on Object. Something on
the "drag and drop" basis.

Anyone have an idea how do it?

Thank you for all advices.

Best regards,
Bartosz Dlugokęcki

I whant to create easy tool to creating and updating organization tree
in each department.

I want to use excel's list with 700 eployees who are working in 16
departments and one person in each department will be responsible for
this file.

Both Excel and PowerPoint use the same tool to draw organization
diagrams.

When you have about 80 emplyees in department and you have to create
this diagram It's much easier to drag&drop Name and Job into diagram,
then retype each from the list.

Any ideas?

On 22 Sty, 18:12, JLGWhiz wrote:
Graphics are much better in Power point. Â*Any particular reason why Excel is
being used.

"Bartosz Długokęcki" wrote:
Hello,

I would like to create macro which will autofill organization tree/
diagram.

I have database of Employees:

Name | Surename | Job
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
John Â* | Smith Â* Â* Â* | Manager
Eve Â* Â*| Brown Â* Â* Â* | Process Engineer
Joe Â* Â*| Locke Â* Â* Â* Â*| Product Engineer
....
....
....

I need to build organization tree/diagram in Excel. You can insert
that object from Menu.

It looks something like that:

Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*_____________________
Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*| PRODUCT MANAGER |
Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*| Â* Â* Â* Â* Â*John Smith Â* Â* Â* Â* |
Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*-------------------------------------
Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â*|

----------------------------------------------------

| Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* Â* |
Â* Â* Â* Â* Â* ______|______________ Â* Â* Â* Â* Â* Â* Â* Â* Â*_____________________
Â* Â* Â* Â* Â* | PROCES ENGINEER Â* | Â* Â* Â* Â* Â* Â* Â* Â*| Â*PRODUCT ENGINEER |
Â* Â* Â* Â* Â* | Â* Â* Â*Eve Brown Â* Â* Â* Â* Â* Â* Â*| Â* Â* Â* Â* Â* Â* Â* Â*| Â* Joe
Locke Â* Â* Â* Â* Â* Â* Â* Â* Â* |
Â* Â* Â* Â* Â* -------------------------------------
--------------------------------------

People from all departmens will have to update those diagrams. Some
departments have abot 50 empleeys. I would like to make it easier, and
faster to operate for all people who will be using this file.

I would like that data will be put into the diagram only by clicking
on the name in the database's table and then on Object. Something on
the "drag and drop" basis.

Anyone have an idea how do it?

Thank you for all advices.

Best regards,
Bartosz Dlugokęcki