Excel automatic organizational chart maker through VBA

[mankardam]

I'm new to VBA and wanted to know if someone can help me create an organizational chart like the person in this youtube video (

https://www.youtube.com/watch?v=KsNGST-w27c).

I don't need to create my org. chart to the extent of what the person created with all the extra color options (e.g. border color, line color, and text color). I just want a basic layout where I can just create the chart with the "Generate Chart" option and, also, have the options to chose the type of hierarchy chart, adjust text size, and add department name and title.

Thank you for your help/advice!

 

[dhookom]

This is amazing. As I am posting this reply, there is an ad between this reply box and the question pushing a "Free Org Chart Maker"

Duane
Hook'D on Access
MS Access MVP

 

[combo]

There was a similar topic here some time ago:

http://www.tek-tips.com/viewthread.cfm?qid=1709060

, it could be helpful if you have basic understanding of vba.

combo

 

[mintjulep]

Visio has an org chart wizard that does exactly this (I think).

https://support.office.com/en-us/ar...t-Wizard-307787a4-bc21-4fa1-8ffd-7e98ba15ae3f

 

[mankardam]

mintjulep,

That is perfect. I believe our company has visio, so I will definitely try this out.