How to use Smart Art in Excel

Smart Art 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 which allows you to add text and images to them.

Smart Art Graphic can be used to represent information in the form of an Organizational chart, Process flows, List information, Repetitive or Cyclic information, Matrix, Images, and so on.

Steps to Insert Smart Art Graphics

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

Insert Smart Art Graphics with Images Options

Smart Art also allows you to add images and if you want to add the 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 then click on the “Smart Art” icon under the “Illustrations” group and you will get the “Smart Art Graphic” dialog box opened.
    4-insert-tab-smartart-icon
  2. After that, choose the graphic category “Picture” from the left panel of the dialog box and then choose the graphic design and click OK.
    5-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 local system, online, or Excel inbuilt icons.
    6-smartart-design-with-insert-picture-options
  5. From here, choose the option from where you want to add or insert the image.
    7-insert-pictures-dialog-box

Added images will get added within the shapes and will look as per 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 format the background color, add shapes, delete shapes, and many more.

  1. First, select the existing graphic design and you will get the “Smart Art Design” tab.
  2. After that click on the “Smart Art Design” tab and you will find multiple formatting options to format the existing graphic design.
    9-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.
    10-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 the “Add Shape After or before” as you need.
    11-add-shapes
  5. Once you choose the option (we choose here “Add Shape After”) and it will add the shape just after the shape you had selected.
    12-shape-added-to-the-smartart
  6. To switch the position of the shapes, click on “Move Up” or “Right to Left” and to delete the text shapes click on “Demote”.
    13-move-delete-shapes

When you move, resize, or adjust any shape in the design, other available shapes will get adjusted accordingly but to make other shapes constant/fixed you can convert the design into shapes format by clicking on “Convert to Shapes” after which design of the graphic will get converted into shapes format and along with this the formatting options will also get changed.

convert-to-shapes