This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Use the Text Pane to Build SmartArt
Problem: How do I create SmartArt?
Strategy: Initially, you shouldn’t worry about the graphics but should instead focus your attention on the text pane, where you can build bullet points of Level 1 and, optionally, Level 2 text.
Using the text pane is similar to building a slide in PowerPoint’s Outline view.
When you choose Insert, SmartArt and select a layout, Excel will draw a default layout and place the insertion cursor in the text pane.
Figure 1316 SmartArt starts out with bullet points that show [Text].
You can use these keys to navigate in the text pane:
● Enter - Add a new shape at the same level as the current shape and immediately after the current shape.
● Down Arrow - Move to the next shape without creating a new shape.
● Tab - Demote the current shape one level. Pressing Tab on a Level 1 entry will change the entry to Level 2.
● Shift+Tab - Promote the current shape one level. Pressing Shift+Tab on a Level 2 entry will change the entry to Level 1.
● Delete - Pressing Delete when there is no text for a shape will delete the shape. Initially, you should focus all your attention on the text pane. As you type in the text pane, Excel will continue to render new shapes in the SmartArt graphic.
Additional Details: In most of the SmartArt layouts, Excel will ensure that every shape is the same size and that every shape has the same font size. This works best when you have similar-length text in each shape. For example, each shape contains a single word or concept. The font sizes are fairly large.
Figure 1317 With similar length points, the fonts are fairly large.