MS Office – Organization Chart

This is a old feature of MS office tools like (word/powerpoint/outlook/excel) which I recently shared with my colleagues. Thought of registering it here as well.

If you want to include a Hierarchical chart into your office documents (like Organization Chart) you have this feature called “SmartArt”.

Step 1 – From any office application

Step 1 – From any office application

Step 2 - Choose  Hierarchical Charts

Step 2 – Choose Hierarchical Charts

At this stage, you can type your content onto the text area on the left-hand side. In my case, I had to include the organization chart of a particular department. Therefore, I executed the below query in our ERP system to retrieve the same information.

select replace(LPAD ( ' ', LEVEL), ' ', chr(9)) || emp_name ename
from employees
START WITH posn_reports is null
CONNECT BY posn_reports = PRIOR position_no;

smartArt3

Step 4 - Copy paste the query output the text area on the left-hand side.

Step 4 – Copy paste the query output the text area on the left-hand side.

smartArt5

That is it. Now you can change the Layout and style of your need.

Leave a Reply

Your email address will not be published. Required fields are marked *