Page 216 - Excel Workbook for Dummies

21_798452 ch15.qxp 3/13/06 7:41 PM Page 199
Chapter 15: Adding Graphics to the Spreadsheet 199
replace the dummy text Your Text Here with the words or phrase that you want pre-
sented in the WordArt style you just selected in the Gallery dialog box.

The Edit WordArt Text dialog box contains a Font drop-down list box and Size combo
box that you can use to change the font and font size of the text you enter. It also
contains a Bold and Italic button that you can click to enhance the text you enter by
making it bold and/or italic.

After you finish entering and enhancing your text in the Edit WordArt Text dialog box,
click its OK button. Excel inserts your WordArt graphic object in the worksheet, while
at the same time displaying the WordArt toolbar that you can use to further format or
make changes to the new graphic object.

Try It

Exercise 15-6: Constructing WordArt in a Spreadsheet

Open the Exercise15-6.xls workbook file in your Chapter 15 folder in the My Practice
Spreadsheets folder on your hard disk or in the Excel Workbook folder on the work-
book CD-ROM. This workbook contains a copy of the 3-D Column chart without the
Horizontal Scroll AutoShape and text box that you added in Exercise 15-5. You will use
this earlier version of the 3-D Column chart to practice heading from a WordArt
graphic object:
1. Click the Insert WordArt button on the Drawing toolbar to open the WordArt
Gallery dialog box.
2. Click the second style in the first row (with the black text on a diagonal pointing
upward) and then select OK to open the Edit WordArt Text dialog box.
3. Replace the Your Text Here by typing CG Media and then select OK.
Excel inserts a WordArt graphic object containing the text CG Media in the
middle of the 3-D Column chart, while at the same time displaying the floating
WordArt toolbar (see Figure 15-7).
4. Drag the WordArt graphic from the center of the chart to the upper-left corner of
the 3-D Column chart.
5. Click the Format WordArt button on the WordArt toolbar to open the Format
WordArt dialog box.
6. On the Color and Lines tab, click the Turquoise color square on the Color drop-
down palette in the Fill section before you select OK.
The company name now appears in turquoise rather than black letters.

7. Click the WordArt Shape button on the WordArt toolbar to open the pop-up
palettes of shapes and then click the Triangle Down shape on the palette (the
fourth one from the left in the top row).
Excel redraws the WordArt graphic as a 3-D shape that fits into a downward-
pointing triangle.
8. Click the WordArt Gallery button on the WordArt toolbar to reopen the WordArt
Gallery dialog box and then click the thumbnail of the style that is located
second from the left in the third row (with purple text on a diagonal pointing
upward) before you select OK.
Excel redraws the WordArt graphic object using the new diagonal style with
gradient-purple shaded letters.
9. Resize the WordArt graphic and reposition it as needed (use Figure 15-8 as your
guide).