Page 125 - Excel Data Analysis

07 537547 Ch06.qxd 3/4/03 12:09 PM Page 111

CHARTING DATA 6

EXPLODE SLICES OF A PIE CHART

f you consider one piece of information more You can rotate the pie chart so that the exploded
crucial than any other in your pie chart, you piece appears at a specific angle in the chart. To
I can emphasize it by exploding its corresponding rotate the chart, click the piece of the pie chart and
piece of pie. Remember that the purpose of a pie
chart is to show the relationship between individual click Format ➪ Selected Data Point to display the
values and the entire chart. After you create a pie Format Data Point dialog box. Click the Options tab.
chart, and apply this feature, you can move each In the Angle of first slice field, specify the degrees of
element of the chart individually within the chart rotation for the pie chart. The Preview window in the
object to emphasize your specific data values. For dialog box shows the effect of rotating the chart.
more on the various types of charts that Excel Keep in mind that the selected piece remains in the
provides, see the section "Chart Basics." same location in the chart. Excel rotates the entire
chart.
You can explode all pieces of a chart by selecting
the entire pie chart and dragging toward the By default, Excel displays each piece of the pie chart
outside of the Chart object. As you drag, each piece in a different color. If you want to make the entire
moves an equal distance from the center of the pie chart the same color, you can deselect the Vary
chart.
colors by slice option ( changes to ).

EXPLODE SLICES OF A PIE CHART

⁄ Click a piece of the pie ¤ Drag the piece toward the ■ The piece moves away
chart. edge of the chart object. from the pie chart.

111