News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Combining Data for Org Chart

Started by grunt, September 20, 2010, 05:42:50 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

grunt

Hi. I'm new to Visio and finding it a very powerful tool, but also overwhelming. I'm trying to make an organization chart where multiple positions of the same classification reporting to the same supervisor can be combined in one box. For example:

Building Supervisor
06-922  Ed Doe

Building Inspesctor II
01-298  John Doe
02-459  Jane Doe

Building Inspector 1
06-238  Jack Doe
01-299  Judy Doe
03-412  Jason Doe

I would also like to total the postions in each classification within the page somewhere ideally at the bottom. For example:

1- Building Supervsor
2- Building Inspector II
3- Building Inspector I

I'm pulling from an Excel file where the fields from left-to-right are Position Title, Employee Name, Position Number, and Reports To, and using the org chart wizard in Visio. My research so far has found nothing on point and would appreciate any help.

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 131 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1049KB.
Tokens: post-login.
Cache hits: 14: 0.00203s for 26,733 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]