MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))

The SmartArt button on the Insert tab represents a significant new set of features in the 2007 Microsoft Office system. SmartArt replaces the Organization Chart feature with all that and more-a comparative cornucopia of new functionality and graphic complexity. SmartArt graphics are prepackaged sets of graphic objects designed to address a variety of presentation tasks, such as creating timelines and decision trees, illustrating procedural steps and relationships, and, yes, even creating organizational charts.

When you click the SmartArt button, the Choose A SmartArt Graphic dialog box shown in Figure 10-17 appears.

Figure 10-17: SmartArt graphics help you illustrate conceptual information.

The categories on the left represent conceptual approaches you can select to narrow the SmartArt graphics available in the main area of the dialog box:

• List Creates a list of information that does not need to be in any particular order

• Process Illustrates sequential steps to achieve a goal

• Cycle Describes processes that are cyclical rather than goal oriented

• Hierarchy Creates organizational charts or decision trees

• Relationship Shows connections

• Matrix Illustrates relationships that are interdependent

• Pyramid Shows relationships that are proportional in size or importance

After you select a SmartArt graphic in the dialog box, click OK to add it to your worksheet, as shown in Figure 10-18.

Figure 10-18: You can type your text into the box on the left, and it appears in the graphic to the right.

The SmartArt graphic comprises several components: the text pane with its Name box at the bottom displaying the currently active item; the SmartArt graphic; and the border surrounding the SmartArt like a picture frame. The text pane and the border appear only when you select the graphic. Similarly, two tabs appear on the Ribbon, under SmartArt Tools, only when you select a SmartArt graphic: Design and Format. The text pane makes organizing large charts and diagrams a lot easier and lets you easily perform editing tasks such as indenting bullet lists and rearranging hierarchical items. Here's more information about the text pane and the border:

• Resize the graphic by dragging any of the eight dotted handles on the border.

• Move the graphic by dragging the border; the text pane will follow.

• Enter text directly into graphic items by clicking and typing.

• Redisplay a closed text pane by clicking the tab that appears in its place on the border or by clicking the Text Pane button on the Design tab under SmartArt Tools.

If you change your mind about your original SmartArt selection, the Layouts palette on the Design tab under SmartArt Tools lets you switch to a different graphic arrangement within the same SmartArt category, without having to start from scratch. Or click the More Layouts command at the bottom of the Layouts palette to switch to a different SmartArt category.

The SmartArt Styles palette offers different graphic treatments and gives you thumbnail previews using your selected graphic, as shown in Figure 10-19. Both of these palettes exhibit live preview functionality, allowing you to rest the pointer on each thumbnail in the palette to quickly view your graphic in each style.

Figure 10-19: Use the SmartArt Styles palette on the Design tab under SmartArt Tools to add graphic interest to your SmartArt.

The buttons in the Create Graphic group on the Design tab under SmartArt Tools offer ways to modify your graphic, and how they work depends on the particular graphic you're using. For example, the Add Bullet button works perfectly in most List graphics but not so well in the gear graphic shown in Figure 10-19. Experimentation is inevitable and rewarding. You can always press Ctrl+Z to undo any changes or click the Reset Graphic button on the Design tab under SmartArt Tools. Here is some more information about buttons in the Create Graphic group:

• Add Shape Inserts another shape similar to those already in the selected graphic. Clicking the arrow displays a menu of commands that allow you to choose where to put the new shape: above, below, after, or before the active shape. The Add Assistant command applies only to Hierarchical Organization Chart graphics; it adds a box outside the hierarchy that is typically used for administrative assistants or other positions outside the normal chain of command.

• Add Bullet Creates a new bullet item, subordinate to the active bullet.

• Right To Left Flips the horizontal orientation of applicable graphics.

• Layout Controls the horizontal orientation of an organization chart. Menu commands include Standard, Left Hanging, Right Hanging, and Both (left and right hanging). This is available only when an Organization Chart graphic is selected.

• Promote and Demote Change the hierarchical position of a selected bullet. Promoting to the highest level creates a new shape in the SmartArt graphic. Similarly, demoting a top-level bullet removes the corresponding shape in the graphic and adds its text as subordinate to the previous bullet. Only in Organization Chart graphics, these buttons move the selected shape up or down the hierarchy and do not add or remove shapes from the graphic.

We discuss the controls available on the Format tab under SmartArt Tools in "Formatting Graphics" on page 368.