Pinterest Pixel

Dotted Line Organizational Charts

John Michaloudis
You can create Organizational Charts in Excel using SmartArt which I go through in this post here:   Organizational Charts in Excel.
Dotted Line Organizational Charts | MyExcelOnline Dotted Line Organizational Charts | MyExcelOnline

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

Dotted Line Organizational Charts | MyExcelOnline
Download workbookDotted-Line-Chart.xlsx

 

Excel Chart Layouts

If you like this Excel tip, please share it
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Project Milestone Chart Using Excel

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...