81%(21)17 out of 21 people found this document helpful
This preview shows page 20 - 22 out of 53 pages.
An Optionsgroup in a Formattask pane is the command set that enables you to accomplish tasks that are specific to the type of element you select. For a data series in a column chart, for example, these commands determine whether numbers are shown on the right or left of the chart (secondary or primary axis), or you can choose to have the columns overlap. A pie chart, on the other hand, has series options that allow you to rotate the pie and explode the slices. HOW TO: Use the Format Task Pane to Set Data Label Options1. Double-click a data label element.• Right-click the element and choose Format[Element Name].• If you have difficulty selecting the desired element, click the Optionstriangle next to the group name and choose the element from the drop-down list.2. Click the Label Optionsbutton in the Formattask pane.3. Click Label Optionsor Numberto expand the group.4. Enter your format preferences in the task pane (Figure 3-31).3-31 Format Data LabelspaneUsing Images, S hapes, and WordArt in a Chart A chart includes several selectable elements as part of its basic layout. You can add images, shapes, or WordArtin a chart to further personalize it. For example, a chart that illustrates the number of fish caught in a tournament could use a small image of a fish as fill for a data series rather than a fill color, or you might add a shape as a callout to a particular data point on a chart, such as a star to highlight the best sales record. You can also replace a chart title box with WordArtfor a distinctive look. Pictures, shapes, or WordArtare chart elements that you can size, position, and format. Use a Picture as Shape Fill In a chart, you can fill bars, columns, or pie slices with a picture that helps illustrate the data. To clarify, you might use a small stick-figure in a chart that graphs numbers of customers. You can use images that are filed on your computer or external storage device. You can search for and insert an online image, or you can copy an image from another application. The size and design of an image are important. You cannot edit all images in Excel, so you may have to experiment with pictures to learn what works well in your charts. For example, you may not be able to change the color of a picture, or it may have a transparent background. When you use a picture as a fill, you can use the Stretchoption to stretch it across the data marker. This places a single copy of the image and stretches it to fill the shape. The Stackoptions resizes the picture to fit the width of the marker and repeats it to signify the values represented. There is also a Stack and Scalesetting for more detailed sizing and placement of the picture. SLO 3.5nor86919_ch03_133-185.indd 152nor86919_ch03_133-185.indd 1527/16/13 6:42 PM7/16/13 6:42 PMFinal PDF to printer
SLO 3.5 Using Images, Shapes, and WordArt in a Chart E3-153Insert Shapes Shapes such as arrows, circles, or callouts can be used to highlight important parts of a chart.