Autopopulate OrgChart

Started by Michael M, February 17, 2011, 12:31:49 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

Michael M

February 17, 2011, 12:31:49 AM
Hi All
I've googled everywhere for a solution, but I'm beginning to wonder if I can actually do it...
I have created an OrgChart in Excel 2003, by using Insert / Diagram / Org chart.
It only has about 6 boxes at the moment but will expand significantly.
What I am trying to do is have a range of cells with employee details AND the shape No on the worksheet.
When the employee details change it automatically updates the text in the shapes using a macro...is this even possible.
I note that the shape No's are different to normal shapes inasmuch as they are numbered like _s1025, _s1026, etc.

Name   Position           Shape Name
Bob   Manager              _s1025
Ted   Assistant Manager  _s1026
Bill   Salesman              _s1027
Alice   Admin               _s1028
ANY assistance would be appreciated

Regards
Michael M
Print
Go Up Pages1
User actions
Browser ID: smf (is_webkit)
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: 147 (show)
Files included: 34 - 1321KB. (show)
Memory used: 1094KB.
Tokens: post-login.
Cache hits: 13: 0.00298s for 26,582 bytes (show)
Cache misses: 2: (show)
Queries used: 15.

[Show Queries]