Programming Organisation Charts

[Max Power]

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

 

[Bob Phillips]

Max,

Not used it myself but apparently Excel already has such an add-in. It's
called MS Organization Chart 2.0 and accessible via Insert>Object...

If you don't find it in the dialog box list, install it from the Office CD.


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Max Power]

I've used MS Organization Chart 2.0 but it doesn't allow
you to link to cells or generate a chart from a list -
thanks anyway.