[ Pobierz całość w formacie PDF ]
.2 Choose View, Toolbars, Customize.3 Click the Drawing category and drag the Edit Points button from the Commands list tothe floating Lines palette.For more information on customizing toolbars, see Customizing Toolbars and Menus on page 65.Working with CurvesWhen you edit the points in an object created using the Scribble, Curve, or Freeform buttons,you can fine-tune the curves even further by using commands on the shortcut menu thatappears when you right-click any edit point, as shown in Figure 10-6.289Part 4: Adding Graphics and PrintingChapter 10 Microsoft Office Excel 2003 Inside Outf10ie06Figure 10-6.Change the type of a selected edit point by right-clicking it and using com-mands on the shortcut menu.There are four types of points.You can right-click any existing point, and change it to a dif-ferent type of point using the corresponding command on the shortcut menu:Ï% Auto Point.Auto Points are determined by the button used to create the line and theway it was drawn.The Curve button always creates Auto Points, which display no ver-tex handles.Ï% Smooth Point.Lines flowing out from either side of a smooth point are equallycurved and display vertex handles of equal length when selected.Drag a vertex handleand the opposite handle moves equally in the opposite direction, creating an equalcurve on either side of the point.Ï% Straight Point.Straight points create gradual transitions between the lines flowingout from either side, which can be unequal, and display vertex handles when selected.You can drag each vertex handle separately.The longer the vertex handle, the moregradual the curve on that side of the point.Ï% Corner Point.Corner points create abrupt transitions between the lines flowing outfrom either side, and display vertex handles when selected, which can be dragged sep-arately.The Scribble button always creates Corner Points.All types of points except Auto Points provide vertex handles when selected.These handles,shown in Figure 10-7, allow total control over the shape of a curve.The longer the vertexhandle, the flatter the curve in the direction you drag.Working with Text BoxesUse the Text Box button on the Drawing toolbar to add notes, headings, legends, andother text to your worksheets and charts to give more impact to or to clarify the datayou re presenting.290Part 4: Adding Graphics and PrintingChapter 10 Part 3: Formatting and Editing WorksheetsCreating Spiffy Graphicsf10ie07Figure 10-7.Change the shape of freeform objects by dragging the vertex handles thatappear when you click any type of point except an Auto Point.Click the Text Box button and a box appears.A blinking cursor appears in the box, indicatingthat you can begin typing.After you are finished, you can select and format text using thesame commands you use for text in cells.Tip Check the spelling of text in objectsIf you choose the Spelling command with a single cell selected, all the text in the currentworksheet is checked, including text in text boxes.If you choose Spelling while a text box(or any object) is selected, only the text contained in that text box (or object) is checked.Adding Text to Other ShapesThe Text Box button is quick and easy to use, but if you want to add graphic assistance to yourmessage, you can add text to many of the shapes created by using the AutoShapes menu,including arrows, banners, boxes, and just about any shape except lines and connectors.g10ie01To do so, just draw the shape you want and then start typing.Resize the object as needed,and use Format, AutoShape to give the shape and its text the look you want.291Part 4: Adding Graphics and PrintingChapter 10 Microsoft Office Excel 2003 Inside OutTip Create linked objectsYou can create a link from a text box or any other shape containing text to a cell so that youcan display that cell s contents in the text box.First draw a text box.With the text box selected,type an equal sign in the formula bar, and then type a cell reference or defined name.For exam-ple, suppose cell D3 contains a formula that returns the value $123.45.When you type=$D$3 into the formula bar while a text box is selected, the value $123.45 appears in the textbox.When you link a text box in this way, you cannot type additional text into it.To remove thelink, select the text box and delete the reference formula in the formula bar.Working with AutoShapesThe AutoShapes menu on the Drawing toolbar offers dozens of predrawn shapes you can useto add effective visual communication to your worksheets.Notice that most AutoShapes dis-play a yellow, diamond-shaped handle somewhere on the perimeter.If you drag this handle,you can control a specific dimension of the shape, as Figure 10-8 illustrates.f10ie08Figure 10-8.Many AutoShapes have special diamond-shaped handles that you can drag tocontrol a specific feature of the shape.In addition to the diamond handle, all two-dimensional objects in Excel display a green pan-handle that you drag to rotate the object as shown in Figure 10-9.This is a handy way torotate objects.It directly adds the same functionality offered by the Free Rotate command(on the Draw, Rotate, or Flip submenu) without actually having to use the command.f10ie09Figure 10-9.Drag the panhandle of any two-dimensional object to rotate it.292Part 4: Adding Graphics and PrintingChapter 10 Part 3: Formatting and Editing WorksheetsCreating Spiffy GraphicsUsing Connectors and CalloutsMost AutoShapes are easy to use and somewhat self-explanatory.Connectors and Callouts,however, have some special qualities that bear mentioning.If you ve ever spent time creatingdrawings using simple lines and boxes only to find that you need to reposition somethinglater, you know what a problem this can be.You usually end up spending as much time fine-tuning the drawing as you spent drawing it in the first place.Connectors can help.They arespecial kinds of lines that are sticky on both ends.You use them when you want to connectshapes using lines that remain attached and stretch, making it easier to reposition objectslater with a minimum of tweaking.After you click one of the buttons on the Connectors palette on the AutoShapes menu, specialblue points appear when you hover the mouse pointer over any existing shape.These are con-nection points, and if you click one of them, the connector line attaches to that point.The sec-ond mouse click attaches the other end of the connector line to a blue point on anotherobject and finishes the connector line.As Figure 10-10 shows, the resulting connector linestays attached to the two points even when you move the shapes around.You don t have toattach connectors to anything.For example, you can connect one end to a shape and leave theother end free to create your own custom callout.f10ie10Figure 10-10.Connector lines remain attached to the points where you place them, evenwhen you drag the shape to a new location.Tip Create easily modified flow chartsConnectors are particularly useful for creating flow charts.First, sketch out your rough ideasusing the Flowchart And Connectors palettes on the AutoShapes menu
[ Pobierz całość w formacie PDF ]