61 Excel Charts Examples!
August 28, 2020
Imagine you have a lot of shapes in your Excel file and the shapes are all over the place!
You want to organize the shapes but it seems a pain to move them one by one!
What would you do?
Thankfully, Excel allows you to distribute and align shapes!
This is our initial layout of shapes:
STEP 1: Hold the CTRL key and select all of the shapes you want to move:
STEP 2: Go to Format > Arrange > Align > Align Bottom
You can Align the shapes to the direction that you want (i.e. Left, Center, Right, Top, Middle, Bottom)
STEP 3: Go to Format > Arrange > Align > Distribute Horizontally
You can Distribute the shapes either Horizontally or Vertically.
This will ensure the distance between the shapes are equally distributed.
Your shapes are now in good shape! (Pun intended)
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
August 28, 2020
February 9, 2018
March 5, 2016
November 20, 2015
November 5, 2015
October 16, 2015