30 Advanced Excel Tips for 2026

Excel Champs / Advanced Excel / How to use Smart Art in Excel
By Puneet Gogia (Microsoft MVP)

How to use Smart Art in Excel

Go to Insert ? Illustrations ? SmartArt, pick a category on the left, such as Process, Hierarchy or Cycle, choose a layout and click OK.

Type into the shapes directly, or open the Text Pane with the small arrow on the left edge of the graphic. In the Text Pane, press Enter to add a shape, Tab to move a line down a level and Shift + Tab to move it back up.

With the graphic selected, the SmartArt Design tab has Add Shape, Promote, Demote, Change Colors and the style gallery, and the Format tab changes individual shapes. To remove a shape, click its border and press Delete.

For a layout with photos, choose the Picture category and click the image icon in each shape to add one.

SmartArt text cannot be linked to cells, so it does not update when your data changes. For a diagram that shows live values, use ordinary shapes instead: select a shape, type =B2 in the formula bar and press Enter. Convert to Shapes on the SmartArt Design tab turns the graphic into separate shapes, but you can no longer switch layouts afterwards.

Smart Art (SmartArt) is a feature in Excel used to effectively represent your information, messages, and ideas with the help of visual graphics.

With Smart Art graphics, you can insert different types of graphics as per your need, and you can add text and images to them.

A Smart Art graphic can be used to represent information in the form of an organizational chart (Hierarchy), process flows, lists, repetitive or cyclic information, a matrix, pictures, and so on.

Steps to Insert Smart Art Graphics

  1. First, go to the “Insert” tab and click on the “SmartArt” icon in the “Illustrations” group, and the “Choose a SmartArt Graphic” dialog box will open.
    smartart-icon
  2. After that, choose the graphic category as per your need from the left panel of the dialog box, then choose the graphic design and click OK.
    smartart-graphic-dialog-box
  3. Once you click OK, you will get your graphic design, where you can write your messages, captions, highlights, etc.
    smartart-graphic-design

Insert Smart Art Graphics with Images Options

Smart Art also allows you to add images, and if you want to add images along with the text in the Smart Art graphic, you can do it by just following the below steps:

  1. First, go to the “Insert” tab and click on the “SmartArt” icon in the “Illustrations” group, and the “Choose a SmartArt Graphic” dialog box will open.
    insert-tab-smartart-icon
  2. After that, choose the graphic category “Picture” from the left panel of the dialog box, then choose the graphic design and click OK.
    choose-picture-option
  3. At this point, you will get the graphic design that allows you to also add images along with the text options.
  4. Now, click on the image icon to insert the image from your computer, from stock images, online, or from Excel’s built-in icons.
    smartart-design-with-insert-picture-options
  5. From here, choose the option from where you want to add or insert the image.
    insert-pictures-dialog-box

The images will get added within the shapes and will look like the below image.

image-added-to-smartart

Formatting of Smart Art Graphics

Excel Smart Art also allows you to format the Smart Art graphics designs. You can change the colors, add shapes, delete shapes, and much more.

  1. First, select the existing graphic design, and you will get the “SmartArt Design” tab (SmartArt Tools ➜ Design in older versions).
  2. After that, click on the “SmartArt Design” tab, and you will find multiple formatting options to format the existing graphic design.
    smartart-design
  3. Now, to change the background color of the boxes in the design, click on the “Change Colors” icon and choose from the colors drop-down, and it will get applied.
    change-colors-icon
  4. To add the additional shapes, select the existing shape before or after which you want to add another shape, and then click on the “Add Shape” icon and select “Add Shape After” or “Add Shape Before” as you need.
    add-shapes
  5. Once you choose the option (here we chose “Add Shape After”), it will add the shape just after the shape you had selected.
    shape-added-to-the-smartart
  6. To switch the position of the shapes, click on “Move Up”, “Move Down” or “Right to Left”. “Promote” and “Demote” move a shape up or down a level, and to delete a shape, select it and press the Delete key.
    move-delete-shapes

When you move, resize, or adjust any shape in the design, the other shapes get adjusted accordingly. To keep the other shapes fixed, you can convert the design into separate shapes by clicking on “Convert to Shapes”. After that, the graphic becomes a group of normal shapes, and the formatting options change as well (it’s no longer a Smart Art graphic, so you can’t use the SmartArt Design tab on it).

convert-to-shapes

Add and Edit Text with the Text Pane

The easiest way to type the text in a Smart Art graphic is the Text Pane. It works like a bulleted list, and each bullet is one shape in the graphic.

  1. First of all, select the graphic and click on “Text Pane” on the SmartArt Design tab (or click the small arrow on the left edge of the graphic).
  2. After that, type your text in the bullets. Press Enter to add a new shape.
  3. In the end, press Tab to make a bullet a sub-point (demote it) and Shift + Tab to move it back up (promote it).

Change the Layout and Style

You don’t need to start again to try a different design. On the SmartArt Design tab, pick another design from the Layouts group, and your text moves to the new layout. Use SmartArt Styles to change the look (like 3D or shadows), and “Reset Graphic” to remove all the formatting changes you have made.

Frequently Asked Questions

Can I undo Convert to Shapes?

Only with Undo (Ctrl + Z) right after you do it. Once the graphic is converted into shapes, there’s no option to turn it back into Smart Art, so keep a copy if you may need to edit it later.

How do I make an org chart with Smart Art?

Choose the Hierarchy category in the dialog box and pick the Organization Chart design. Then type the names in the Text Pane and use Tab to put each person under their manager.

Can I copy a Smart Art graphic to Word or PowerPoint?

Yes. Select the graphic, copy it with Ctrl + C, and paste it into Word or PowerPoint with Ctrl + V. It stays a Smart Art graphic that you can edit there.