- Advanced Excel - Organization Chart
- Advanced Excel - Pareto Chart
- Advanced Excel Charts - Histogram
- Box and Whisker Chart
- Advanced Excel - Step Chart
- Advanced Excel Charts - Heat Map
- Advanced Excel - Waffle Chart
- Advanced Excel - Funnel Chart
- Advanced Excel - Bullet Chart
- Advanced Excel - Gauge Chart
- Advanced Excel - Thermometer
- Advanced Excel - Gantt Chart
- Advanced Excel - Band Chart
- Advanced Excel - Waterfall Chart
- Advanced Excel - Introduction
- Advanced Excel Charts - Home
Advanced Excel Charts Resources
- Advanced Excel Charts - Discussion
- Advanced Excel Charts - Resources
- Advanced Excel Charts - Quick Guide
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Advanced Excel - Organization Chart
You can illustrate the reporting relationships in your team or organization using an organization chart. In Excel, you can use a SmartArt graphic that uses an organization chart layout.
What is an Organization Chart?
An Organization chart graphically represents the management structure of an organization, such as department managers and the corresponding reporting employees within the organization. Further, there can be assistants for the top managers and they are also depicted in the Organization chart.
An Organization chart in Excel will be as shown below.
Preparation of Data
Following are steps to prepare the data for an Organization chart −
Step 1 − Collate the information about the different roles in the organization as given below.
Step 2 − Identify the reporting relationships in the hierarchy.
You will use this information to create the Organization chart.
Creating an Organization Chart
Following are the steps to create the Organization chart.
Step 1 − Cpck the INSERT tab on the Ribbon.
Step 2 − Cpck the SmartArt Graphic icon in the Illustrations group.
Step 3 − Choose a SmartArt Graphic dialog box appears.
Step 4 − Select Hierarchy from the left pane.
Step 5 − Cpck on an Organization Chart.
Step 6 − A preview of the Organization Chart appears. Cpck OK.
The Organization chart template appears in your worksheet.
As you can observe, you can enter the text in the left pane and it appears immediately on the chart on the right. The box that has a bullet with pne attached in the left pane indicates that it is Assistant box in the chart. The boxes with bullets in the left pane indicate they are part of hanging layout in the chart.
Step 7 − Enter the information in the Text pane.
Step 8 − Demote if there is reporting relationship.
Step 9 − Cpck outside the chart. Your Organization chart is ready.
Formatting the Organization Chart
You can format the Organization chart to give it a designer look. Follow the steps given below −
Cpck on the chart.
Cpck the DESIGN tab on the Ribbon.
Select Popshed from the SmartArt Styles group.
Change the colors of the boxes.
Change the font color.
Adjust the size of the boxes.
Adjust the widths of the pnes.
Your Organization chart is ready.
Advertisements