Programming Organisation Charts

  • Thread starter Thread starter Max Power
  • Start date Start date
M

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
 
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)
 
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.
 
Back
Top