Excel’s Smart Art

Microsoft boosted Excel’s graphic engine and increased the chart formatting options and it also added Smart Art. Smart Art includes built-in graphics that represent different types of processes.

These graphics can be useful in displaying business processes. These graphics can be formatted and have text added to them. Smart Art graphics can’t however be linked to a cell. There is a work around however that can allows you to link the graphics to a Smart Art graphic.

To insert a Smart Art graphic you click on the Insert ribbon tab and click the Smart Art icon.

Smart_01

The types of graphics are listed on the left. The graphics are typically coloured even though they displayed in grey in the List section. The image on the right shows what the selected graphic will look like.

Smart_02

Once inserted on the sheet a text entry section is shown on the left and you can update the entries and see them on the graphic.

Smart_03

There are lots of formatting options in terms of display and colour in the Design ribbon tab. See two image below.

Smart_04

Smart_05

 

Linking to a cell

If you want to link to cell content and you have finished formatting you can convert the Smart Art graphic into separate graphics that can be linked to cell as per the previous blog post. On far the right of the Design ribbon tab there is a convert to Shapes icon.

Smart_06

Simply click the graphic and then click in the formula bar and the press = and click on the cell to link to – see below. See this previous post for more info on linking to cells.

Smart_07

Note: The Smart Art graphics are also available in Word and PowerPoint.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.