Microsoft Office Tutorials and References
In Depth Information
Alicia tells you that the company is particularly interested in the sales performance of the
BrightStar 6 telescope, because the company is considering replacing this scope with a six-
inch version of the NightVision. Alicia has seen pie charts in which a single slice is removed
from the others to give it greater emphasis. She wants the slice for the BrightStar 6
removed from the other slices to draw attention to this telescope.
Exploding a Slice of a Pie Chart
This method of emphasizing a particular pie slice over others is called separating or
“exploding” the slice. An exploded slice is more distinctive because it is not connected to
the other slices in the pie and it appears to be bigger. Excel allows you to explode any or
all of the slices in the pie. A pie chart with one or more pie slices separated from the
whole is referred to as an exploded pie chart.
Creating an Exploded Pie Chart
To explode one pie slice from a pie chart:
Click the pie chart to select it, and then click the pie slice you want to explode.
Drag the selected pie slice away from the rest of the pie, and then release the mouse button.
To explode all the pie slices in a pie chart:
Click the pie chart to select it.
Drag any pie slice to explode all the slices an equal distance apart, and then release the
Next, you’ll separate the BrightStar 6 telescope pie slice from the rest of the pie.
To explode the slice for the BrightStar 6 telescope:
1. Make sure that the pie chart is still selected, and then click the pie slice representing the
total sales for the BrightStar 6. When you position the pointer over the pie slice, a
ScreenTip appears with the corresponding worksheet cell information.
2. Drag the pie slice down and to the left. As you drag the pie slice, an outline marks your
3. Release the mouse button, moving the slice into its new position. See Figure 4-19 for the
location of the exploded pie slice.