Highlighting One Slice of a Pie by Exploding in Excel 2007:-
The first click on a pie selects the data series (that is, it selects all the pie slices). If you then drag outward from the center of the pie, you explode all the slices of the pie.
The charts in the Figure (specified below) show various levels of explosion. The top-left chart uses a 15% explosion factor. Excel allows you to specify up to a 400% explosion factor, which really looks pretty silly.
(You drag outward while a data series is selected to select the entire pie.)
A better technique is to explode just the one slice that is the subject of the pie. In the Figure (specified below), a large order could not ship because of shortages of a tiny assembly. The plant managers had previously decided to cut safety stock on this component. To illustrate that this might have been a poor decision, you can explode just that slice of the pie. You click once on the pie to select the entire series. Then you click the slice in question one more time to select only that slice. You drag the individual slice outward to explode only that slice, as shown in the Figure below.
(You can explode one piece of the pie to call attention to that piece.)


LinkBack URL
About LinkBacks
Reply With Quote

LinkBacks Enabled by vBSEO
Bookmarks