Hi there,

Is there any way in Excel to create organisation charts
automatically. Either using the Organisation Chart
function or the Flow Chart diagrams in the drawing toolbar.

Name Reports_to Post Filled

Normally I import a list with the above headings into a
Visio wizard to do this but do not always have access to
it, so am looking at creating a macro or add-in to do this.

Anyone know;

a) Whether you can do it in Excel automatically, ie create
an organisation chart based on a simple list
b) Such an add-in already exists
c) A macro already exists
d) Any tips on writing my own macro...I am good at writing
macros but far from a guru


Any feedback is greatly appreciated.

Regards

Max