spot_img

Exploding Out Slices Of A Pie Chart

In this lesson you will learn few tricks in pie charting. You will know how to explode single slices out of a pie chart in Excel.

 

In Excel, you can explode one, several or all slices of a pie chart. Here are examples of how this might look like a pie chart in Excel:Excel example pie chartExcel pie chart explosionExcel pie chart slices explosion

Pie Chart Explosion

Pie Chart Exploded

The first way (pulling by mouse)

To explode a single slice of the pie, select it and drag and drop out of a chart.

Pie Chart Slice Explosion

To pull all the slices of the pie, select all of the slices and drag and drop them.

Pie Chart Slices Drag and Drop

To restore default, select all slices. Use drag and drop method and pull them to the center of the pie chart.

Pie Chart Restore Explosion

The second way (by Format Data Point menu)

You can also explode slice out of pie chart in the other way. Just right click the pie chart and select Format Data Point.

Pie Chart Format Data Point Explosion

You can set up the Point Explosion here. The higher the percentage the more distant from the center of pie chart.

Pie Chart Format Point Explosion

This is how to explode out slices of a Pie Chart in Excel.

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell