Author Topic: Autopopulate OrgChart  (Read 2831 times)

0 Members and 1 Guest are viewing this topic.

Michael M

  • Newbie
  • *
  • Posts: 1
Autopopulate OrgChart
« on: February 16, 2011, 07:31:49 PM »
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

aledlund

  • Hero Member
  • *****
  • Posts: 1412
Re: Autopopulate OrgChart
« Reply #1 on: February 18, 2011, 07:41:36 PM »