Hi. In this Excel tutorial, we’ll go over how to make an organizational chart in Excel using SmartArt. Once we’ve made it, we’ll create
links from some of the titles to their team bio. And, by the way, if you enjoy this tutorial, don’t forget to Like the video and subscribe to the
channel for even more tips. In this tab, I’ve already created a list of the positions in 2 departments in an organization. We'll use this
to create the org chart. So, I'm going to highlight and then
right-click so I can copy all of the titles. And then, in a blank spreadsheet, go to the Insert tab, and in the Illustrations section, select
SmartArt Graphics. And, here, we have different categories of Smart Art Graphics to choose from. I'm going to click on Hierarchy.
And this brings up different styles of charts we can select from, including some that can accommodate for
pictures. I just want to talk about this one for a quick second - the Name and Title Organizational Chart.
My own preference, I like to stay away from using this one because you can't fill in the smaller boxes right from the Text Pane, which
is what we're going to be doing in this example. So, you have to go into each one of the little boxes and type the information
manually. And I think that can be a bit more burdensome than some of the other options. So, for this example, we're going to select this
first Organization Chart and click OK. From here, in the Text Pane, I'm just selecting everything and then pasting in the titles that we
copied a moment ago. So, the first thing I want to do is actually drag the Org Chart over and make it bigger so we can see what's
happening. ...I need to expand this a little bit more... So, when we pasted these in, all the positions are at the same level. And, when I
created the list of titles that we pasted here into our Text Pane, I tried to make it so that it was already organized by department and
in hierarchical order. This makes it easier to use tabs to reformat how who reports to whom is displayed. So, now we can use tabs in
our Text Pane to help illustrate which position reports
in to which other position. So, for example, the executive assistant to the president reports in to the president, so we'll
tab over one. The vice president of marketing also reports to the president, so we'll tab over one more time. The executive assistant to
the vice president of marketing will, of course, report in to the vice president of marketing, so
we'll tab over twice - and you see how this is changing our Org Chart here to the right.
The director of marketing reports to the vice president of marketing as well. And there are 2 senior marketing managers, so we can
highlight both of them, and both of those will report in to the director of marketing.
The marketing managers, we can highlight all of those and tab those over together to report under
the senior marketing manager. And then, the admin assistant in marketing,
we'll tab over one more time, and they report in to the marketing managers. The vice president of HR also reports in to the president,
so tab over one - and you see that now aligned beneath the president. The executive assistant to the VP of HR and the director of HR
both report to the vice president of HR, so tab over one more time underneath the vice president, and same thing with the
senior HR managers - they report in to the director of HR.
We can highlight all of the HR managers - this will report there. And the admin assistant in
HR will report to the HR managers. And let's hide this, move this over
so we can see it all together. So, it's likely that, over time, there'll be changes to the positions. And some will need to be moved, deleted
or new ones added. And, we can do that right from the Text Pane. So, we'll open that and let's expand it so we can see it. So, let's say,
for example, we have a third senior HR manager. We can just come to the second senior HR manager on our list and click Enter
and then just type in that
new position. And, let's say we want to move the admin assistant in HR to report to a different manager. So, I've highlighted this
and used the Cut feature. And, then now, we'll move that role underneath the second HR manager, Paste it and then tab over so that
it now changes to reporting in to this individual. Let's close this. So, you may have noticed your
SmartArt Tools options up here. So, we can use this to style and
format how our organizational chart will look. So, for example, we can change this so that it's right-to-left instead of left-to-right.
You can decide to switch to a different layout up here...which we're not going to be doing. We
can change the colors, which I want to change to this color
and then a different style...
let's go with this one. I'm actually going to just bold them so that they look a little bit bigger.
And then in Format, here, you can affect the Shapes that you're using, the fills, what the text looks like and some of the sizing. I'm also
going to come up here to the View tab and get rid of the Grid Lines so that it looks a bit cleaner. So, a couple of things to consider
with using SmartArt for Org Charts is, one, you can't automatically add dotted line reports. To do that
you would have to insert your own line. And you can do that from Shapes.
Select your line and, let's say you want the senior HR manager to have a dotted line report
to the vice president of HR, you would have to do that manually and format it.
You could right-click on it to get to the Format Shape. And then, here, just making sure that you're in the Line section, scroll to your Dash
Type and select a dotted line. Let's close this. And, just keep in mind that if the positions move around, so, for example, if we went to
Design and we want right-to-left, we'd have to make sure to manually move this line.
Let's undo that... So, you also want to avoid dragging and moving the Shapes. So, while this is an option to do, let's say you want to
change the layout of these and you want them to be left-hanging. Notice how all of the Shapes move so that there's still aligned
together, except for the Shape that we just dragged manually and the dotted line that we added manually. So, worst case scenario, let's
say you've saved and closed this document and opened it another time - you can always reset your graphics,
but this also gets rid of any other formatting that you may have done. So, let's undo these.
Now that we've organized our Org Chart the way we want, we can add links to the bios of some of the senior associates. I've already
created bios on this tab and, to make it easier to link, have also created Named Ranges for each. So, coming back to our Org Chart,
simply select the Shape that you want to add a link to, right-click on it, and select Link.
If you want to link it to a web page or a different file, you can select that here, but, for this example, we're going to select Place in
this Document. And you see our Defined Names are already listed here. So, since this is the president, I'm going to click on
PresidentBio and click OK. Now, when you click on president, you automatically jump to their bio.
So, I hope you enjoyed this tutorial on how to create an organizational chart in Microsoft Excel using Smart Art.
If you did, please make sure to Like the video and don’t forget to subscribe to this channel. Thanks!