Using SmartArt in Excel

by rhyttinen on August 18, 2008

SmartArt is a new feature in Microsoft Office 2007 that allows you to insert grapical objects such as diagrams, organization charts, flow charts, graphical lists, matrix, and much more to illustrate processes and relationships.  With the wide-range of formatting tools available such as colors, bevels, shadeows, etc., you can easily create extremely impressive spreadsheets.

After you have inserted a SmartArt object, you can manipulate and format the object in many ways from the contextual Design tab and the Format tab on the Ribbon.  Options include appying a quick style to a SmartArt graphic, changing its orientation, changing its layout, and changing its colors, just to name a few.

The quickest way to add text is to click directly into SmartArt object and begin typing.  You can also use the Text Pane to enter your text.  Click the Text Pane button on the contextual Design tab on the Create Graphic group or click the control with two arrows along the left side of the object to display the text pane.

  1. To Insert SmartArt into a Worksheet
  2. Click the Insert tab on the Ribbon.
  3. Click the SmartArt button on the Illustrations group to display the SmartArt gallery.
  4. Click the desired category in the left pane.
  5. Click the SmartArt graphic you want to use in the center pane.
  6. Click OK.
  7. Click in the SmartArt object and type in your text Or click the Text Pane button on the contextual Design tab and type in your text in the text pane.
  8. Click the contextual Design or Formatting tabs on the Ribbon to modify the SmartArt object.

 

Similar Posts:

Share and Enjoy:
  • del.icio.us
  • Digg
  • TwitThis
  • Reddit
  • Technorati
  • Facebook
  • StumbleUpon
  • Google Bookmarks
  • Propeller
  • E-mail this story to a friend!

Comments on this entry are closed.

Previous post: Change Worksheet Tab Color in Excel

Next post: Inserting Columns in Word 2007