How to Make an Organizational Chart in Excel - Tutorial

Excel tutorial on how to make an organizational chart in Excel using SmartArt. We’ll also create a link from some positions in the org chart to a team bio.
SmartArt works something like a "wizard" for Shapes in Excel and other programs. It helps you create more visually appealing graphics faster through the use of preset styles and formatting.
In this tutorial, you'll see how to create an organizational chart from a list of job titles using SmartArt shapes.
Click here to read our step-by-step article on this: yacostasolutions.com/organiza...
And make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends - it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials

[@lillianhackathorn9158]

This was a huge help! The end result looks great and very professional. I am definitely subscribing to your page. Thank you!
Now, I hope it prints out as nice as it looks online.

[@lampsizgod]

Crisp and to the point. This tutorial is an absolute pleasure!

[@YAcostaSolutions]

Thanks so much! I’m happy you liked this 🙂

[@ImranKhanLifeisbeautiful]

This is an awesome tutorial. I have always associated org structure with power-point, not realising that it can be done so effortlessly in excel. It makes life so simple. Thanks a ton

[@YAcostaSolutions]

Awesome, Imran Khan! I'm happy this helped you find a new solution to make org charts 🙂

[@aquamelina]

I cannot express how incredibly helpful this tutorial was for me. Thank you so very much. Whew! I was in a bind at work to produce an org chart, and, well you saved me.

[@YAcostaSolutions]

Hi, l.m. tisdale. That's awesome! Great job on getting your org chart done 🏆 I'm happy my tutorial was able to help you with it 🙂

[@monicastackpole9653]

You’re awesome, thank you so much! I don’t think many people are aware Excel is capable of this, I created a beautiful org chart with pictures and color coded it. Thank you! 🙏

[@YAcostaSolutions]

Hi, Monica. That's great!!! 🏆 I agree, Excel can do sooo much more than just calculations.

[@rickstirling7045]

Thank you! You made my day. I've been an Excel user for years and didn't know about this capability. I like your clear and precise presentation. Well Done!

[@YAcostaSolutions]

Thank you so much, Rick! I’m happy I helped show you something new 🙂

[@carlynn1956]

Great tutorial. So clear and concise and very helpful! Thank you!

[@YAcostaSolutions]

Thank you, Carlynn. I'm happy this was helpful for you 🙂

[@amossnongalo8077]

Many Thanks!! Very insightful video & an applause for your teaching style. Now empowered...Keep up the Great Work. From South Africa!

[@YAcostaSolutions]

Thank you, Amoss. I'm happy you enjoyed it and thank you for the kind comment 🙂

[@ramaseshukittursrinivasan1788]

Great tutorial. I have struggled with shapes and connectors to create organization charts and I have always found them cumbersome. I did not know that it was so easy. A thousand more thanks for this.

[@YAcostaSolutions]

That’s awesome! I’m so happy this helped you learn a new Excel trick! 🙂

[@dge2270]

THANK YOU!!! You made creating an org chart from scratch so simple.

[@YAcostaSolutions]

Thank you, D. Edwards! I'm happy this was able to help you 🙂

[@anthonyalexander3561]

This was such a helpful, easy to understand tutorial. I cannot thank you enough!

[@YAcostaSolutions]

Thanks so much, Anthony! I’m so glad you liked this 🙂

[@anasjh4239]

Thank you so much. I have been looking on how to do these charts. Your video is simple, easy and right to the point.

[@YAcostaSolutions]

Thank you 🙂 I'm so happy this was helpful for you!

[@karennesbitt9655]

This is an excellent video. Thank you very much!

[@allabout1135]

Thanks! Again something new. I like Your teaching style. You are gifted mentor.

[@YAcostaSolutions]

Thank you so much! That really means a lot to me 🙂

[@danggurae1776]

I never thought that it could be done that way... trying to figure out for hours... Thank you for this

[@YAcostaSolutions]

That's great, Dianne! I'm happy this was so helpful to you 🙂

[@unnikrishnanchackyaramveet9048]

Best tutorial ever. Thanks heaps. Easy and to the point.

[@YAcostaSolutions]

Thank you, Unnikrishnan Chackyaram Veettil! I'm happy this was helpful for you 🙂

[@thespiritofyou1836]

OMG! You are a blessing. Thank you for sharing. This is most helpful.

[@YAcostaSolutions]

This is so sweet of you to mention 😊 I'm happy this was so helpful for you!

[@bryandavies4662]

Thank you for posting this!!! Huge help!

[@YAcostaSolutions]

Thanks so much, Bryan! Happy this helped you 🙂

[@franknguma7212]

For sure this video give me enough knowledge thank you so much from east africa Tanzania

[@YAcostaSolutions]

Thank you, Frank. That's kind of you to mention. Happy this was helpful for you 🙂

[@sajjadal-lawati3133]

Fantastic Explanation, easy and to the point ...Thank you

[@YAcostaSolutions]

Thank you, Sajjad. I really appreciate your kind words 🙂

[@vintageroseandlace]

Fantastic tutorial, clearly and simply explained. Thank you

[@YAcostaSolutions]

Thanks so much! I'm so happy you liked this 🙂

[@harrisireful]

You absolutely 100% helped me ace my project! Thank you so much!

[@YAcostaSolutions]

That's awesome, Nikki! I'm happy this helped you and thanks so much for sharing your success! 🏆

[@macdonaldmabambe917]

this just made my day today, it makes this so simple

[@YAcostaSolutions]

That’s great, Macdonald! Thank you so much for the nice feedback 🙂

[@emanemy6468]

This was very helpful, thanks for the knowledge sharing. Greetings from Iraq

[@YAcostaSolutions]

Thank you, Eman 🙂 I really appreciate the compliment. I'm happy you found this helpful.

[@pianopearlpianopearl1928]

This is my Go To for a reminder when I’m called on to magic up a new Org Chart 😊

[@YAcostaSolutions]

That's awesome! I'm so happy this has been so useful for you. Thanks so much for sharing this with me 🙂

[@javiernajera2948]

Great tutorial, thank you for helping out to discover the best way to use the available tools

[@YAcostaSolutions]

Thank you, Javier. I’m happy this helped you learn a new way to use Excel 🙂

[@bw5762]

This was a great video. I really enjoyed it . Also, I took great notes so I can go back over the tutorial using my notes to further enhance my knowledge and to add more to my Excel skills. Thanks for your help.

[@YAcostaSolutions]

That's excellent, BW! There are so many ways to use Excel and studying it is the best way to learn.
When I first began using Excel, I would study the formulas that my coworkers used, breaking them down piece by piece and studying how each affected the results. Understanding how formulas and other features work will give you a much deeper understanding than just memorizing.
I'm really excited for you! Great job!

[@bw5762]

@@YAcostaSolutions Thanks for replying back to my post and continue to give me suggestions as to how I can continue enhance my skills

[@user-sz6pp8nw9v]

Your video was very detailed! Thank you for your help!

[@YAcostaSolutions]

Thank you! So glad it was helpful 🙂

[@funshomaryonabajo6318]

This is incredible, thank you and God blessed. I really enjoyed every bit of it.

[@YAcostaSolutions]

That’s great! I’m so happy this helped you 🙂

[@lisaclarke6994]

This video tutorial was a tremendous help! thanks

[@YAcostaSolutions]

So glad it was helpful for you, Lisa! Thanks 🙂

[@alinoor6293]

I was in two minds with subscribing but after the tutorial I was more than impressed So clear and concise thank you so much for your help

[@YAcostaSolutions]

Thanks so much! I’m happy this helped you learn a little something new 🙂 And thanks for subscribing!

[@jabumidzi]

Many Thanks. Lots of love and light to you.

[@YAcostaSolutions]

Thanks so much, Jabulani. I'm happy this helped you 🙂

[@jamaludin-vb3fy]

An excellent tutorial. Must watch and learn a lot.

[@YAcostaSolutions]

Thank you, Jamal. That's kind of you to comment 😊 I'm happy this was helpful to you!

[@samtaufao]

A most useful and practical tutorial. Thank you for sharing.

[@YAcostaSolutions]

I’m glad this was helpful for you, Samuelu! Thanks 🙂

[@shelbypearson3721]

I spent hours and hours trying different websites to create my org chart for a school project. I FINALLY stumbled upon your video and got in done in minutes. Thank you!

[@YAcostaSolutions]

Fantastic! Thanks so much for letting me know 🙂

[@HullioGQ]

I was looking for a way to create a sitemap for a website in OneNote then I found this. Wow, it definitely fits into my needs. Thank you!

[@timothyhiggins5560]

Thank you so much! I was stressing about trying to paint and open text boxes in word. I'm really not good with computers!

[@YAcostaSolutions]

I'm glad this was able to help you! 🙂

[@ligiapearson8439]

Great tutorial, thank you!!

[@YAcostaSolutions]

Thanks, Ligia. I’m happy you liked this 🙂

[@sofiadalagan6481]

Thank you so much for sharing on how to make organizational chart in Excel using SmartArt. This is very informative and useful in performing my work. More power. God bless you.

[@YAcostaSolutions]

Thank you so much, Sofia! That's really kind of you to mention 😊 I'm happy this helped you.

[@fernandobe3330]

Awesome...!! I hope you continue to upload more useful videos 👍🏻👍🏻

[@YAcostaSolutions]

Thanks, Fernando BE. That’s nice of you 🙂 I try to do a video a week...stay tuned!

[@carlorodrigues1600]

This tutorial is really FANTASTIC and extremely well explained. As a student I need to know how to do often this sort of thing. Thanks

[@YAcostaSolutions]

Thanks so much, Carlo 🙂 I'm happy this helped you!

[@rajagopalan73]

Excellent. I needed this only. Thank you very much...

[@YAcostaSolutions]

Thank you so much! I'm happy this helped you 🙂

[@banditoc1376]

Thankyou! Your voice makes me learn faster!

[@YAcostaSolutions]

Thanks so much 😊 I'm happy to be helping you learn!

[@vijaychandermelwani734]

Wow, super explanation and very easy to learn. thanks a lots

[@YAcostaSolutions]

Thank you, Vijay! I really appreciate the kind feedback. I’m happy this was helpful to you 🙂

[@morenofranco9235]

Ms Y Acosta, You are a *LIFE-SAVER*. This is going to save me so much time. Thank you.

[@YAcostaSolutions]

That's great! I'm so happy this helped you so much! Thanks 🙂

[@frankdeslou]

Hello! Awesome video. Didn't know that Excel is capable of that. That would help in my work as I plan to help a client develop their organizational chart. Thanks again!

[@YAcostaSolutions]

Thank you, Farkhad! I'm happy this was able to help you 🙂

[@farji2008]

You are amazing. You show so much easy methods. Thanks

[@YAcostaSolutions]

Thanks so much, Farzan 😊 So glad you liked this!

[@davidthan5146]

Thanks for uploaded for user around the world. God bless you more.

[@YAcostaSolutions]

Thank you, Maung Than! Happy my video was helpful for you 🙂

[@yahayaaminu8975]

Wow, you are amazing, thank you so much for this!

[@YAcostaSolutions]

Thank you so much 🙂 Glad you enjoyed it!

[@laverndg]

Love this...so helpful

[@YAcostaSolutions]

Thank you, laverndg! Happy that this was helpful for you 🙂

[@waeltaha8706]

Thank you, really useful tutorial

[@YAcostaSolutions]

Thank you, Wael. I really appreciate the kind feedback. Happy this was helpful for you 🙂

[@jg6159]

Love this thank you so much!

[@YAcostaSolutions]

Thanks so much! I’m happy you liked this 🙂

[@mistermannan]

So helpful. Thank you.

[@YAcostaSolutions]

Thank you so much, mistermannan! I'm happy this helped you 🙂

[@howardhofer8233]

So helpful!! Thanks!!!

[@YAcostaSolutions]

Thank you, Howard! I’m happy this helped you 🙂

[@ElementzzOfStyle]

Thank you! Very Very Very Helpful!

[@YAcostaSolutions]

Thanks, Chris. Glad it helped you 🙂

[@Type_Run]

This really is a great tutorial - thank you

[@YAcostaSolutions]

Thank you so much! I'm happy you liked this 🙂

[@hrd3120]

It is awesome and really thankful to you. I was facing a lot of problem for creating organogram you solved my problem.

[@YAcostaSolutions]

That’s great, HR D! I’m glad this was able to help you 🙂

[@sandeepsukumaran4475]

Thank you this was helpful and simple.

[@YAcostaSolutions]

Glad it was helpful, Sandeep! Thanks so much 🙂

[@mattquinn8022]

thank you for this excellent video!

[@YAcostaSolutions]

Thank you, Matt! I really appreciate your feedback 🙂

[@hdurvasula]

Very Useful! Thanks.

[@YAcostaSolutions]

Thank you, Hemanth. Happy this helped you 🙂

[@srinivasannarayanaswami5378]

Simply Superb. Very useful. Thanks a lot!

[@YAcostaSolutions]

Thank you so much! Glad it was helpful for you 🙂

[@riseofasia7683]

Thanks for the free tutorial.

[@YAcostaSolutions]

You're very welcome! I'm happy you liked it 🙂

[@Christina-kn7wk]

Super helpful and brief! Thank you so much :-)

[@YAcostaSolutions]

Thank you, Christina. Happy this helped you 🙂

[@quocnguyen1200]

Y. Acosta, your video is awesome ! Thank you very much.

[@YAcostaSolutions]

Glad you liked it! Thank you so much 🙂

[@shwetagehlot2697]

Thankyou for teaching this. It was really helpful. I am an HR Person and I have to work on org charts quite frequently. Everytime my boss used to ask me to share the revised org chart - it used to give me jitters - until I saw your video and you solved all the problems. Never knew its that easy. Tthanks a ton :)

[@YAcostaSolutions]

That anxiety can be the worst! I’m happy this was able to help you, Shweta. Please let me know if you ever have questions I can try to be of help with 🙂

[@moonbloomsdesign311]

This was very helpful. Thank you so much

[@YAcostaSolutions]

Thank you, Moon & Bloom Designs! Glad this was helpful for you 🙂

[@twinkyjoseph3679]

Thank you so much..awesome tutorial

[@YAcostaSolutions]

Glad it was helpful! 🙂

[@tetchmorales84]

Awesome tutorial on Org. Charts using Excel!

[@YAcostaSolutions]

Glad you like it! Thanks so much 🙂

[@NagaKitchen]

thank you so much for the chart tutorial. I have learned to make a org. chart from you.

[@YAcostaSolutions]

Thanks, Naga Kitchen! I'm happy this taught you something new 🙂

[@sandeepsandy6705]

Thank you. It helped me a lot and saved my time

[@YAcostaSolutions]

Awesome, Sandeep! Happy this helped you 🙂

[@makhliyoshodieva7375]

Thank you for this!

[@YAcostaSolutions]

Thank you! I'm so glad this helped you 🙂

[@karenclark5457]

Hi ... This was great, thank you very much, had no idea you could do all of this in excel, much easier than PowerPoint.

[@YAcostaSolutions]

Thank you, Karen. I’m happy I was able to help you learn something new 🙂
Btw, the dog in your profile pic is very cute!

[@sandeeprazdan641]

Great Video... Very helpful. Thanks

[@YAcostaSolutions]

Glad it was helpful!

[@awt-ry7nf]

Excellent very clear and concise 👍

[@YAcostaSolutions]

I'm so glad you thought so! Thanks so much and am happy this helped you 🙂

[@32cant]

GREAT JOB! Thanks!

[@YAcostaSolutions]

Glad it was helpful! Thanks so much 🙂

[@robbiem7630]

Thanks, very helpful!

[@YAcostaSolutions]

Thanks so much! I’m glad you found this helpful 🙂

[@ValueInvestment]

Superb. you made it Extremely simple and clear. thank you for the video tutorial. appreciate.

[@YAcostaSolutions]

So happy this helped you! Thanks 🙂

[@hamimuidrisa6390]

Wow thank you, very helpful

[@YAcostaSolutions]

Thanks so much, Hamimu Idrisa! I'm happy you found this helpful 🙂

[@sajithakis01]

Thanks a bunch, this was awesome

[@YAcostaSolutions]

Glad you enjoyed it! Thanks so much, Sajitha 🙂

[@omarjaldin6334]

Great video, helped me a lot

[@YAcostaSolutions]

Awesome, Omar! I’m happy this helped you 🙂

[@spuneet156]

Literally helpful, thanks

[@YAcostaSolutions]

Thank you, demon is watching. Happy you found it helpful 🙂

[@spuneet156]

@@YAcostaSolutions for sure it is helpful, thanks you noticed my words.

[@SaSaRush]

Thanks! really helpful

[@YAcostaSolutions]

Thanks so much! So happy this was helpful for you 🙂

[@asalimi]

Thank you, very helpful

[@YAcostaSolutions]

Thanks so much! I’m happy you found this helpful 🙂

[@UBislive]

This Is Owsm ,
each and every thing is clear.

[@YAcostaSolutions]

Thanks so much! I’m happy you liked this 🙂

[@nurizzati5373]

Thanks. You help me alot 🧡

[@YAcostaSolutions]

Thank you, Nur, that's very sweet of you to say! I'm happy you've found this helpful 😊

[@RaviShankar-de2yj]

Thank you so much.... It's really very helpful ❤

[@YAcostaSolutions]

Thanks so much, Ravi! I’m happy this was helpful for you 🙂

[@gauripawarmagar2043]

Owsm tutorial, Org charts created in a breeze! Thank you so much:-)

[@YAcostaSolutions]

That's great! I'm so happy this helped you 🙂

[@mercymupanganyama9404]

the most helpful video i have seen in 2021

[@rajaramkhadka7305]

Great Job. Thanks a lot.

[@YAcostaSolutions]

Thanks 🙂 I’m happy you enjoyed this!

[@impulmediavilla286]

Thank you so much for this tutorial 😘😘😘 ill definitely subscribe.🥰🥰🥰

[@YAcostaSolutions]

Yay!!! Thanks so much for subscribing and I’m happy this helped you 🙂

[@dyannebryle9291]

This saved my time. Thank you.

[@YAcostaSolutions]

That’s great, Dyanne! I’m happy this helped you 🙂

[@gilesloch]

Very helpful and clear thank you for This I needed create chart like this for ages and been altering an old one manual made and drove me mad!! Thanks I gona do this later

[@YAcostaSolutions]

That's great, Giles! Please let me know if you come across any questions. Thanks 🙂

[@marblenare154]

Thank you very much very informative

[@YAcostaSolutions]

Happy this was helpful for you 🙂 Thanks!

[@abigaill7671]

Thank you so much. This saved me!!!

[@YAcostaSolutions]

That’s great, Abigail! I’m happy this helped you out 🙂

[@SupriyaJha__]

Best video on org chart I watched. Thanks a lot!

[@YAcostaSolutions]

Oh wow! What generous feedback, Supriya! Thank you! I’m happy this was helpful for you 🙂

[@zamenmohamed3816]

you're a life saver thanks a lot

[@YAcostaSolutions]

I'm so happy this helped you. Thanks 🙂

[@francisadeogun5382]

Thanks, I love the video because it solved my challenge.

[@YAcostaSolutions]

Excellent, Francis! I’m happy this was able to help you 🙂

[@mimstdunt7335]

Amazing advice

[@YAcostaSolutions]

Thanks so much! I’m so happy you liked this 🙂

[@alexchen2408]

I don't understand the dislikes on this video!! By far the best tutorial on organsational charts on excel! Thank you so much! so helpful :)

[@YAcostaSolutions]

Thank you, Alex 😊 I really appreciate the comment. Happy this helped you!

[@SheikhAbdelHamid]

You are my Hero. God bless you!

[@YAcostaSolutions]

Wow - a hero! 😍 Thanks so much. I’m happy this helped you 🙂

[@SheikhAbdelHamid]

@@YAcostaSolutions there is one thing stop me in this video when I tried to put the manger under the president. You said in the video press tab and when I did it did not work at my end. I still need your help. Sorry for any inconvenience.