Advanced Excel - Organization Chart

Advanced Excel – Organization Chart

You’ll be able to illustrate the reporting relationships in your workforce or group utilizing a corporation chart. In Excel, you should use a SmartArt graphic that makes use of a corporation chart format.

What’s an Group Chart?

An Group chart graphically represents the administration construction of a corporation, comparable to division managers and the corresponding reporting workers inside the group. Additional, there may be assistants for the highest managers and they’re additionally depicted within the Group chart.

An Group chart in Excel shall be as proven beneath.

Organization Chart

Preparation of Information

Following are steps to organize the information for an Group chart −

Step 1 − Collate the details about the totally different roles within the group as given beneath.

Collate Information

Step 2 − Determine the reporting relationships within the hierarchy.

Identify Reporting Relationships

You’ll use this data to create the Group chart.

Creating an Group Chart

Following are the steps to create the Group chart.

Step 1 − Click on the INSERT tab on the Ribbon.

Step 2 − Click on the Sensible Artwork Graphic icon within the Illustrations group.

Step 3Select a Sensible Artwork Graphic dialog field seems.

Choose SmartArt Graphic

Step 4 − Choose Hierarchy from the left pane.

Step 5 − Click on on an Group Chart.

Step 6 − A preview of the Group Chart seems. Click on OK.

Organization Chart Preview

The Group chart template seems in your worksheet.

Organization Chart Template

As you may observe, you may enter the textual content within the left pane and it seems instantly on the chart on the best. The field that has a bullet with line hooked up within the left pane signifies that it’s Assistant field within the chart. The packing containers with bullets within the left pane point out they’re a part of hanging format within the chart.

Step 7 − Enter the knowledge within the Textual content pane.

Step 8 − Demote if there’s reporting relationship.


Step 9 − Click on exterior the chart. Your Group chart is prepared.

Formatting the Group Chart

You’ll be able to format the Group chart to present it a designer look. Comply with the steps given beneath −

  • Click on on the chart.
  • Click on the DESIGN tab on the Ribbon.
  • Choose Polished from the Sensible Artwork Kinds group.
  • Change the colours of the packing containers.
  • Change the font shade.
  • Modify the dimensions of the packing containers.
  • Modify the widths of the strains.

Organization Chart

Your Group chart is prepared.