How to Explode a Pie Chart in Excel – 2 Methods

 

This is the sample dataset.

And the corresponding pie chart:

2 Easy Methods to Explode Pie Charts in Excel


Method 1 – Exploding a Pie Chart Using the Mouse Cursor

Steps:

  • Select the pie chart.

  • Drag a portion away from the pie. Here, Traveling.

Explode Pie Chart in Excel Using Mouse Cursor

  • Drop the portion away from the pie.

Explode Pie Chart in Excel Using Mouse Cursor

To explode multiple portions, repeat the process. Here, Traveling, Music, and Electronics.

Read More: How to Edit Pie Chart in Excel


Method 2 – Use the Format Data Series Option to Explode a Pie Chart

Steps:

  • Select the pie chart and right-click it.
  • Select Format Data Series.

Use Format Data Series Option to Explode Pie Chart

  • The Format Data Series panel will be displayed.

  • Select Pie Explosion.

Use Format Data Series Option to Explode Pie Chart

  • Set Pie Explosion to different values. Here, to 20%.

Use Format Data Series Option to Explode Pie Chart

 

Read More: How to Rotate Pie Chart in Excel


Things to Remember

  • Exploding Pie Charts by Dragging the Cursor scatters the plot portions unevenly.
  • Higher percentage values in Pie Explosion may result in shortening the pie portions to maintain distance in the specific chart area.
  • These methods are also applicable to 3-D Pie charts.

Download Practice Workbook


Related Articles


<< Go Back To Edit Pie Chart in ExcelExcel Pie ChartExcel ChartsLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nasir Muhammad Munim
Nasir Muhammad Munim

Nasir Muhammad Munim has been an Excel and VBA Content Developer for over a year in Exceldemy and published more than 30 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Electrical and Electronic Engineering from the Islamic University of Technology. Apart from creating Excel tutorials, he is interested in developing PostgreSQL, MySQL, and Android applications. He is fascinated by CAD-based designing systems and building... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo