From the PivotChart Analyze tab, in the Data group, click Refresh All. On the dashboard, click on a Pivot Chart.
Drag the Pie Explosion slider to increase the separation, or. To more precisely control the expansion, follow these steps: Right-click the pie chart, then click Format Data Series. For help deciding which chart is best for your data. The quickest way to pull all of the slices out of a pie chart is to click the pie chart and then drag away from the center of the chart. Select one of the chart types, and a Sub-type, then click Set as Default Chart. Click the chart type, and then double-click the chart you want. In the Charts group, click the Dialog Launcher button, at the bottom right.