• Excel Video Tutorials

Excel - SmartArt


What is SmartArt in Excel?

Smart graphics range from graphical lists and process diagrams to more complicated graphics like Architecture Layout, Basic Chevron process, Cycle Matrix, Segmented Pyramid, etc. The SmartArt feature in Microsoft Excel quickly develops business processes and Venn diagrams according to the business requirements.

Categories of SmartArt

Various categories of the SmartArt are given below −

  • All
  • List
  • Process
  • Hierarchy
  • Relation
  • Matrix
  • Pyramid
  • Picture

SmartArt Graphic in Excel

You may switch to the Insert tab, expand the Illustrations tile, and select the SmartArt option from the drop-down menu under the Illustrations group.

SmartArt Graphic in Excel

SmartArt Hierarchy in Excel

Below are the steps to add the Smart Art graphics in the Microsoft Excel −

Step 1 − First, create a new worksheet where you wish to insert the SmartArt hierarchy in Microsoft Excel. Then, navigate to the "Insert" tab and select the "SmartArt" options from the Illustrations group.

SmartArt Hierarchy in Excel

Step 2 − After that, another dialog box, "Choose a SmartArt graphic," will open. Select the "Hierarchy" category from the list and choose the Hierarchy option, as highlighted in the image below.

SmartArt Hierarchy in Excel 1

Step 3 − Once you choose the hierarchy graphic option, it will be inserted into Microsoft Excel. Hierarchy graphics generally depict relationships progressing from the top to the bottom.

SmartArt Hierarchy in Excel 2

Now, you can edit the default text of the Hierarchy graphics. For example, the IT company hierarchy is like the CEO, Marketing Manager, and Content Manager on the same horizontal line and the Content Engineers team on the bottom line.

SmartArt Hierarchy in Excel 3

Step 4 − You may change the Formatting of the Hierarchy graphic through the SmartArt design tab. The SmartArt design includes various groups, such as Create Graphics, Layouts, SmartArt Styles, and Reset.

Let's say you want to change the Layout of the Hierarchy graphic. To achieve this, you can select the Hierarchy graphics. In the SmartArt Design tab, select the "Half circle Organization Chart" under the Layouts group.

SmartArt Hierarchy in Excel 4

Step 5 − Select "Brick Scene" under SmartArt Styles to change the default graphics style.

SmartArt Hierarchy in Excel 5

Expand the "Change Color" tile to make it more colorful and select the "Colorful range Accent Colors 3 to 4" option from the drop-down list.

SmartArt Hierarchy in Excel 6

Therefore, we have changed the formatting of the Hierarchy graphics.

Add SmartArt Graphics with Image

SmartArt features allow you to add multiple pictures from various resources. Various steps are depicted below to insert the SmartArt graphics with image options.

Step 1 − Go to the Insert tab, expand the "Illustrations" tile, and select the "SmartArt" option from the drop-down menu.

Add SmartArt Graphics with Image

Step 2 − Afterward, in the "Choose a SmartArt Graphic" dialog box, select the "Picture" category, choose the "Bending Picture Semi-Transparent Text," and click the OK button.

Add SmartArt Graphics with Image 1

Now, the default picture has been added to the worksheet. Double-click on the first image icon.

Add SmartArt Graphics with Image 2

The "Insert Pictures" dialog box will appear. Select Online Pictures from the drop-down list. You may insert pictures through various options, such as "From a file," "Stock Images," "Online Pictures," and "From Icons."

Add SmartArt Graphics with Image 3

Various categories are shown in the "Online Pictures" dialog box. You may choose the "Autumn" category and select the first autumn image.

Add SmartArt Graphics with Image 4

Therefore, the Autumn image has been inserted into the first picture. You can now also write "Autumn" at the bottom of the textbox.

Add SmartArt Graphics with Image 5

Similarly, as in the previous step, you can insert the pictures in the remaining image boxes.

Add SmartArt Graphics with Image 6