The charts in Figure 4.15 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.
4
Figure 4.15
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 Figure
4.16, a large order could not ship because of shortages of a tiny assembly. The plant man-
agers 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.