{"id":630,"date":"2013-04-03T02:05:26","date_gmt":"2013-04-03T02:05:26","guid":{"rendered":"http:\/\/www.thestupidbox.com\/blog\/?p=630"},"modified":"2021-06-25T04:07:15","modified_gmt":"2021-06-25T04:07:15","slug":"ms-office-organization-chart","status":"publish","type":"post","link":"http:\/\/thestupidbox.com\/blog\/ms-office-organization-chart\/","title":{"rendered":"MS Office – Organization Chart"},"content":{"rendered":"

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.<\/p>\n

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

\"Step<\/a>

Step 1 \u2013 From any office application<\/p><\/div>\n

\"Step<\/a>

Step 2 – Choose Hierarchical Charts<\/p><\/div>\n

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.<\/p>\n

select replace(LPAD ( ' ', LEVEL), ' ', chr(9)) || emp_name ename
\nfrom employees
\nSTART WITH posn_reports is null
\nCONNECT BY posn_reports = PRIOR position_no;
\n<\/code><\/p>\n

\"smartArt3\"<\/a><\/p>\n

\"Step<\/a>

Step 4 – Copy paste the query output the text area on the left-hand side.<\/p><\/div>\n

\"smartArt5\"<\/a><\/p>\n

That is it. Now you can change the Layout and style of your need.<\/p>\n","protected":false},"excerpt":{"rendered":"

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)… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58],"tags":[193,196,189,188,198,187,192,191,197,195,194,190],"class_list":["post-630","post","type-post","status-publish","format-standard","hentry","category-technical","tag-excel","tag-hierarchical-chart","tag-microsoft-office","tag-ms-office","tag-org-chart","tag-organization-chart","tag-outlook","tag-powerpoint","tag-query-for-org-chart","tag-smart-art","tag-smartart","tag-word"],"_links":{"self":[{"href":"http:\/\/thestupidbox.com\/blog\/wp-json\/wp\/v2\/posts\/630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/thestupidbox.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/thestupidbox.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/thestupidbox.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/thestupidbox.com\/blog\/wp-json\/wp\/v2\/comments?post=630"}],"version-history":[{"count":13,"href":"http:\/\/thestupidbox.com\/blog\/wp-json\/wp\/v2\/posts\/630\/revisions"}],"predecessor-version":[{"id":732,"href":"http:\/\/thestupidbox.com\/blog\/wp-json\/wp\/v2\/posts\/630\/revisions\/732"}],"wp:attachment":[{"href":"http:\/\/thestupidbox.com\/blog\/wp-json\/wp\/v2\/media?parent=630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/thestupidbox.com\/blog\/wp-json\/wp\/v2\/categories?post=630"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/thestupidbox.com\/blog\/wp-json\/wp\/v2\/tags?post=630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}