Exploding a Single Slice of Pie
To add emphasis to a particular piece of a pie chart, you can move or explode the slice out from the rest of the chart as illustrated in the image above.
Pie of Pie and Bar of Pie Charts
Another option for adding emphasis to certain parts of a pie chart is to use a Pie of Pie or a Bar of Pie chart instead of a regular pie chart. If you have one or two larger slices that dominate the pie chart, making it difficult to see the details of the smaller slices, you can switch to one of the above-mentioned chart types; these emphasize the smaller slices in a secondary chart, either a second pie chart or a stacked bar chart. Unless changed, Excel will automatically include the three smallest slices (data points) in the secondary pie or stack bar chart. To create a Pie of Pie or Bar of Pie chart: The left-hand chart is always the main chart, with the secondary chart always appearing on its right. This arrangement cannot be changed.
Changing Chart Types
To switch from an existing regular pie chart to either a Pie of Pie or Bar of Pie chart:
Changing the Number of Data Points
To change the number of data points (slices) displayed in the secondary chart: The options available for changing the number of data points in the second chart include:
Split the Series by Position: In the Values in second plot box, enter the number of positions or slices displayed in the second chart (a minimum of three).Split the Series by Value: In the Values less than box, enter a number that is larger than the smallest data value to be displayed in the secondary chart.Split the Series by Percentage Value: In the Values less than box, enter a percent value between 0% and 100%. This value relates to the percentage of the main chart’s total value to be displayed in the secondary chart.
