Which of the following steps will you take to demote a shape on your spreadsheet?

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default Excel Functions that we can use to create formulas. Many educational institutions and business companies use excel files to store valuable data. Sometimes, charts or graphs help us to realize certain data effectively. SmartArt Hierarchy charts are useful to represent the organizational structure, reporting, or the hierarchy that is present in every organization. This article will show you the step-by-step procedures to create and use SmartArt Hierarchy in Excel.

Inhaltsverzeichnis Show

Download Practice Workbook
Step by Step Procedures to Use SmartArt Hierarchy in Excel
STEP 1: Insert SmartArt Hierarchy Chart
STEP 2: Input Data
STEP 3: Modify Chart
Final Output
Related Articles
Which of these series of clicks will you select to add text to a smart art?
How can you remove split panes in a worksheet you are working on?
How can you add a new picture to a SmartArt graphic?
Which of the following can you apply to change the way a SmartArt graphic looks?

Download Practice Workbook

Download the following workbook to practice by yourself.

Step by Step Procedures to Use SmartArt Hierarchy in Excel

Excel charts and graphs facilitate the analysis of survey results. Viewers can easily understand the information through these graphs. Similarly, the hierarchy charts are effective in presenting the organizational structure of a business or company. In this article, we’ll show how to insert a SmartArt Hierarchy chart into an excel worksheet. Then, we’ll show how to use the chart. For instance, we’ll consider a company where the CEO is the head, followed by the Project Manager. Under him, the Team Leader is in power. Lastly, 3 Writers work under the leader. Therefore, go through the following steps carefully to perform the task.

STEP 1: Insert SmartArt Hierarchy Chart

First, we need to insert our desired hierarchy chart.
For that purpose, select Insert ➤ Illustrations ➤ SmartArt.

Consequently, a dialog box will pop out.
There, go to the Hierarchy tab.
Then, choose the Organization Chart.

As a result, you’ll get the following chart.
You can input desired texts in the shapes by typing there.
Moreover, you can click the marked icon in the picture below.

As a result, a small dialog box will appear beside the chart.
You can also type your desired texts there.
The texts will automatically get inserted into the shapes.

Read More: How to Make Hierarchy Chart in Excel (3 Easy Ways)

STEP 2: Input Data

Now, we’ll type the post names in the shapes.
In this regard, we’ll type the CEO and Project Manager respectively in the first two shapes.
See the below picture to understand better.

Afterward, delete the three shapes that are below the Project Manager.
Next, select the Project Manager shape.
Then, choose SmartArt Design ➤ Add Shape ➤ Add Shape Below.

Hence, it’ll return a shape under the Project Manager.
Type Team Leader there.

Follow the above step to insert 3 shapes below the Team Leader.
Rename the shapes as Writer – 1, Writer – 2, Writer – 3.
Look at the following chart where the outcome is demonstrated.

STEP 3: Modify Chart

In this step, we’ll show how to change the layout style and make other necessary changes to meet our required standards. So, learn the process.

Firstly, click the chart.
After that, choose SmartArt Design ➤ Change Layout ➤ Labeled Hierarchy.

Moreover, go to the Change Colors section and pick your desired one.
In this example, we pick a color so that viewers can understand the distinct job positions.

The below figure is our outcome.

However, you can modify other settings too as per your liking.

Again, you may need to move certain shapes to represent the promotion or demotion.
Similarly, you can swap positions between the shapes at the same level.
To do that, click the shape.
Then, go to the Create Graphic section in the SmartArt Design tab.
There, you’ll find the options to undertake necessary operations.

Read More: How to Create Multi Level Hierarchy in Excel (2 Easy Ways)

Final Output

After you’re done making your required changes, the chart is ready to be presented. The following SmartArt Hierarchy chart is our final output.

Read More: How to Create Hierarchy in Excel (3 Easy Ways)

Conclusion

Henceforth, you will be able to use SmartArt Hierarchy in Excel following the above-described procedures. Keep using them and let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

How to Create Hierarchy in Excel Pivot Table (with Easy Steps)
Create Date Hierarchy in Excel Pivot Table (with Easy Steps)
How to Add Row Hierarchy in Excel (2 Easy Methods)

Which of these series of clicks will you select to add text to a smart art?

On the Insert tab, in the Illustrations group, click SmartArt. In the menu of types that appears, point at the type you want and then select a layout. Enter your text by doing one of the following: Click [Text] in the Text pane, and then type your text.

How can you remove split panes in a worksheet you are working on?

Select below the row where you want the split, or the column to the right of where you want the split. On the View tab, in the Window group, click Split. To remove the split panes, click Split again.

How can you add a new picture to a SmartArt graphic?

Insert pictures in SmartArt Select More SmartArt Graphics and then select Picture. Select the SmartArt you want and select OK. To insert a picture, select the picture icon, go to where your picture is located, and then select it. Select Insert.

Which of the following can you apply to change the way a SmartArt graphic looks?

You can change the look of your SmartArt graphic by changing the fill of its shape or text; by adding effects, such as shadows, reflections, glows, or soft edges; or by adding three-dimensional (3-D) effects, such as bevels or rotations.