Page 586 - Excel 2013 All-in-One For Dummies

568 Drawing Graphics
3. Type the text you want to display in the worksheet in the Text text box.
As soon as you start typing, Excel replaces the Your Text Here text in the selected text box with the characters you enter.
4. (Optional) To format the background of the text box, use Live Preview in the Shape Styles drop-down gallery on the Format tab to find the style to use and then set it by clicking its thumbnail.
The Format tab on the Drawing Tools contextual tab is automatically added and activated whenever WordArt text is selected in the worksheet.
5. After making any final adjustments to the size, shape, or orientation of the WordArt text with the sizing and rotation handles, click a cell somewhere outside of the text to deselect the graphic.
Note that Excel automatically compresses the text to fill the shape and size of its text box. To put more space between the words and the char- acters in each word, make the text box wider by dragging the sizing handle on either side of the text box.
When you click outside of the WordArt text, Excel deselects the graphic, and the Drawing Tools contextual tab disappears from the Ribbon. (If you ever want this tab to reappear, all you have to do is click somewhere on the WordArt text to select the graphic.)
Figure 2-11 shows the WordArt label for the web image of the new Microsoft Surface tablet after creating the text in the WordArt style called Fill – Blue, Accent 1, Outline – Background 1, Hard Shadow – Accent 1 in the WordArt gallery, and then formatting the text box with the style called Subtle Effect – Blue, Accent 1, selected in the Shape Styles gallery on the Format tab.
Inserting SmartArt graphics
SmartArt graphics give you the ability to quickly and easily construct fancy graphical lists and diagrams in your worksheet. SmartArt lists and diagrams come in a wide array of configurations that include a variety of organiza- tional charts and flow diagrams that enable you to add your own text to pre- defined graphic shapes.
To insert a SmartArt list or diagram into the worksheet, click the Illustrations button on the Insert tab and then select the SmartArt option or press Alt+NM. Excel then opens the Choose a SmartArt Graphic dialog box (shown in Figure 2-12), where you select a category in the navigation pane on the left followed by the list’s or diagram’s thumbnail in the center section before you click OK.