• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA code to generate Org Chart using Excel data in Visio

ajoshi76

ajoshi76

Member
I have created an excel file with dummy details..... like:

1. Name of the resource
2. Designation
3. Team Name
4. Name to link to Stencil (this should be used as reference to pick the stencil)
5. Line Manager

I have created multiple stencils based on City, Employee type (this name is the same as point 4.)

I need to color and format boxes based on the below criteria (point no. 4 is referenced to the names below)

1. India_Perms (orange color black outline)
2. India_Contractor (orange color dotted outline)
3. India_Graduate (orange color dash outline)
4. Vacant (white color black outline)
5. UK_Perms (blue color black outline)
6. UK_Contractor (blue color dotted outline)
7. UK_Graduate (blue color dash outline)

Need a macro that will create the org chart depending on point 4 as reference using the stencil corresponding to it and aligning based on line manager.

Please help
 
Hi Joshi ,

Given the complex nature of the problem you have described , it would make it easy for who ever will develop the code , if you upload a file which has data in place i.e. data laid out the way you have described.

If your working file has a lot of data , you can explain with at least one or two examples how you want the org. chart to look.

Narayan
 
Hi Joshi ,

What about the following ?

I have created multiple stencils based on City, Employee type (this name is the same as point 4.)

I need to color and format boxes based on the below criteria (point no. 4 is referenced to the names below)

1. India_Perms (orange color black outline)
2. India_Contractor (orange color dotted outline)
3. India_Graduate (orange color dash outline)
4. Vacant (white color black outline)
5. UK_Perms (blue color black outline)
6. UK_Contractor (blue color dotted outline)
7. UK_Graduate (blue color dash outline)
Click to expand...
Narayan
 
Uploaded the picture of the org chart... Blue with line color black is for the other country but reporting into the line manager
 

Attachments

  • Dummy Org Chart.jpg
    Dummy Org Chart.jpg
    18.2 KB · Views: 69
Hi Joshi ,

Since the code has to integrate Excel data with Visio elements , where is the Visio file with these elements ?

Narayan
 
Visio file would be a blank one... But stencil should be this OR we could use data graphics. I am unable to upload stencil over here.
 
So the macro should use Link from Excel and tag the format as per the stencil... and align as per line manager
 
Hi Joshi ,

I doubt that this is an Excel project ; you would do better to have the entire VBA code in Visio , and retrieve the data from the Excel file.

It requires the coder to be familiar with VBA programming for Visio , which is not usual with those who have worked mostly with Excel.

Narayan
 
when the visio/data files are moved to another location, the linked data no longer works, cause it can’t find the data file. is there any code or solution available for this....any help regrading this will be appreciated
 
You must log in or register to reply here.
Back
Top