An Options group in a Format task pane is the command set that enables you to

An options group in a format task pane is the command

This preview shows page 20 - 22 out of 53 pages.

An Options group in a Format task 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 Options 1. 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 Options triangle next to the group name and choose the element from the drop-down list. 2. Click the Label Options button in the Format task pane. 3. Click Label Options or Number to expand the group. 4. Enter your format preferences in the task pane (Figure 3-31). 3-31 Format Data Labels pane Using 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 WordArt in 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 WordArt for a distinctive look. Pictures, shapes, or WordArt are 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 Stretch option to stretch it across the data marker. This places a single copy of the image and stretches it to fill the shape. The Stack options resizes the picture to fit the width of the marker and repeats it to signify the values represented. There is also a Stack and Scale setting for more detailed sizing and placement of the picture. SLO 3.5 nor86919_ch03_133-185.indd 152 nor86919_ch03_133-185.indd 152 7/16/13 6:42 PM 7/16/13 6:42 PM Final PDF to printer
Image of page 20
SLO 3.5 Using Images, Shapes, and WordArt in a Chart E3-153 Insert Shapes Shapes such as arrows, circles, or callouts can be used to highlight important parts of a chart.
Image of page 21
Image of page 22

You've reached the end of your free preview.

Want to read all 53 pages?

  • Spring '11
  • Wesley
  • Bar chart, chart type

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture