Creating Organisation Chart in Excel from Employee List

[damonew]

I am trying to automatically generate an organisation chart in excel from a dynamic list of employees. in column 'A' will be the "manager's name", column 'B" will be the "employee name", column 'C' will be the "employee number" & column 'D' will be the "employee days" number (an potentially a few more employee attributes)

Ideally I would like a printable org chart that is created on another tab which is generated from this list, ideally with the "employee name" and their other attributes shown in the chart.

Does anyone know how this can be done in excel, maybe VBA?

(I have no idea what I'm doing with VBA)

 

[John Davis]

Does this help?

http://office.microsoft.com/en-us/v...nerate-an-organization-chart-HP083350072.aspx

 

[damonew]

Hi, unfortunately that article does not help much as it is referring to MS Visio, I am using MS Excel 2003 and MS Excel 2010..

 

[shg]

There's a random example at http://msdn.microsoft.com/en-us/library/aa195802(v=office.11).aspx

If you're new to VBA, this would be jumping in at the deep end.