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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

100% Stacked Column Chart: Percentage Contribution... The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total. For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then thi...
Stacked Column Chart: Compare Contributions The Stacked Column chart is used in Excel to compare the contribution of a value to a Total. For example, if you want to show the North & South sales for the last 5 years then this is the chart for you as I explain below. NB: If you are using Years as your first column ...
Line Chart: Trend with lots of data A Line Chart is used in Excel when you have lots of data points and want to show a periodic trend. An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I ...
100% Stacked Bar Chart A 100% Stacked Bar Chart is a great way to compare a percentage that each value contributes to its total. So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year. DOWNL...