How to create Macro of Organisation Chart

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.

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:
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.

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.