{"id":1744,"date":"2015-10-16T19:06:59","date_gmt":"2015-10-16T17:06:59","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1744"},"modified":"2023-11-30T21:52:30","modified_gmt":"2023-11-30T20:52:30","slug":"organizational-charts-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/organizational-charts-in-excel\/","title":{"rendered":"Organizational Charts in Excel"},"content":{"rendered":"<p>Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt.<\/p>\n<p>To create an Organizational Chart in Excel you have to go to the ribbon menu and select <em>Insert &gt; SmartArt &gt; Hierarchy &gt; Organizational Chart<\/em>.<\/p>\n<p>These charts are very intuitive and you can click inside each shape to add your organizational titles.<\/p>\n<p>When you click on the Organizational Chart it opens up the <em>SmartArt Tools<\/em> menu and in the <em>Design<\/em> tab you have an array of options in the <em>Create Graphic<\/em> group, which is loacted on the far left hand side of the ribbon.\u00a0 You can:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>ADD A SHAPE AFTER\/BEFORE:<\/strong><\/span> This adds another shape to the right\/left of the selected shape<\/p>\n<p><span style=\"color: #ff0000;\"><strong>ADD A SHAPE ABOVE\/BELOW:<\/strong><\/span> This adds another shape one level above\/below the selected shape E.g. Adds Managers after the VP<\/p>\n<p><span style=\"color: #ff0000;\"><strong>ADD AN ASSISTANT:<\/strong><\/span> This adds an assistant below the selected shape<\/p>\n<p><span style=\"color: #ff0000;\"><strong>RIGHT TO LEFT:<\/strong><\/span> This switches the layout of the selected hierarchy to the Left or to the Right of the Organizational Chart<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PROMOTE\/DEMOTE:<\/strong><\/span> This increases\/decreases the level of the selected shape E.g. You can select a Manager and promote him\/her to a VP<\/p>\n<p><span style=\"color: #ff0000;\"><strong>MOVE UP\/DOWN:<\/strong><\/span> Moves the selected shape forward or backward in the sequence E.g. Swap the Managers around<\/p>\n<p><span style=\"color: #ff0000;\"><strong>CHANGE THE DESIGN:<\/strong><\/span> Click in the Organizational Chart and go to <em>SmartArt Tools<\/em> in the ribbon menu and choose the <em>Design<\/em> tab.\u00a0 From the drop down box you can choose a variety of designs.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>CHANGE THE COLORS:<\/strong><\/span> Click in the Organizational Chart and go to <em>SmartArt Tools<\/em> in the ribbon menu and choose the <em>Design<\/em> tab.\u00a0 Click on the Change Colors button to change the color variation of your Organizational Chart.<\/p>\n<p><strong>P.S<\/strong>. You can also change shapes by Right Clicking on a shape and selecting the <em>Change Shape<\/em> option.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/mbrlB4DKFV4?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"text-decoration: underline; color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Organizational-Chart.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Organizational-Chart.xlsx<\/span><\/a><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.e-junkie.com\/ecom\/gb.php?cl=211017&amp;c=ib&amp;aff=277028\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"MATCH Function Intro\"  class=\"alignnone wp-image-1416 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/hmb_logo_01Lg.png\" alt=\"MATCH Function Intro\" width=\"286\" height=\"124\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt. To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert &gt; SmartArt &gt; Hierarchy &gt; Organizational Chart. These charts are very intuitive and you can click [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17461,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,110],"tags":[94,109],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1744"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1744"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1744\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17461"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}