How to create Macro of Organisation Chart

Hi,
I have a spread sheet with information of Line Manager and Associates names.
Could you please help to create a Oragnaistion Chart using Macro.
When i run the Macro it should draw the Organisation Chart automatically and and result (Org Charts) should be displayed in Microsoft Visio.
Thank you for your kind help.
Suchitra.

Dummy-Headcount.xls
Suchitrabasavaraj2009Asked:
Who is Participating?
 
Scott HelmersConnect With a Mentor Visio Consultant, Trainer, Author, and DeveloperCommented:
You shouldn't need a macro to create a Visio org chart because Visio includes a built-in wizard to do this for you. See this topic in the Visio help:
   http://office.microsoft.com/en-us/visio/HA101057641033.aspx?pid=CH100985551033
In particular, look for this heading:
   Automatically create an organization chart by using an existing  data source

Let me know if you need additional assistance.

Scott
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.