You can create Organizational Charts in Excel using SmartArt which I go through in this post here:   Organizational Charts in Excel

You can also extend this concept to create a Dotted Line Organizational Chart but we need to think outside the square a little bit to make this happen.  Follow these steps:

STEP 1: To insert an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational Chart;

STEP 2: You can add organizational titles to each shape by clicking on each shape and manually entering the title you desire;

STEP 3: We then need to insert an extra line by going to Insert > Shapes > Lines > Elbow Connector;

STEP 4: To make the line thicker you need to click on the line and go to the Drawing Tools Format > Shape Outline > Weight > 3pt

STEP 5: To add a dotted line you need to click on the line and go to the Drawing Tools Format > Shape Outline > Dashes

DOWNLOAD WORKBOOK

Dotted Line Chart

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Create a Histogram Chart With Excel 2016 Histogram Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you the distribution of numerical data, like seeing which numerical ranges are the most common.In this example I show you how easy it is to insert a His...
Create a Treemap Chart With Excel 2016  Treemap Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you patterns, like based on your summary of sales grouped by month.The tree branches are represented by rectangles, wherein each rectangle's siz...
Create a Sunburst Chart With Excel 2016 Sunburst Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you hierarchical data, like having a table with different levels of categorization:Each hierarchy is drawn by one ring in the sunburst chart. The inn...
Clustered Column Chart: 12 Month Trend An Clustered Column chart is used in Excel whenever you want to show a periodic trend that has around 12 data points.To create the Clustered Column you have to set our your data with the first column showing the periods and the second column showing the values.Below I sho...