Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Organisation Charts
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Organisation Charts
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 InsertObject... 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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programming Organisation Charts
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. -----Original Message----- 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 InsertObject... 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" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink from Organisation chart box | Excel Discussion (Misc queries) | |||
organisation chart | Charts and Charting in Excel | |||
Programming Charts | Charts and Charting in Excel | |||
organisation charts in excel spreadsheets | Excel Discussion (Misc queries) | |||
Organisation Chart - need to have 2 superiors | Excel Discussion (Misc queries) |