How to Explode Pie Chart in Excel (2 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Pie Chart Explosion in Excel is a very useful and popular feature. It is often used to show the portion of different things while representing the whole as a circle. Often we need to separate those portions for better understanding or add labels to them. This separation is called pie explosion. In this article, we will learn how to Explode Pie Chart in Excel.


Download Practice Workbook

You can download the practice workbook from here.


2 Easy Methods to Explode Pie Chart in Excel

There are two individual methods to explode a pie chart in excel. Both methods have different applications and benefits. Those methods are step by step described below. For example, we have this data showing a person’s spent amount percentage in different fields.

And the corresponding pie chart is also given below.

2 Easy Methods to Explode Pie Charts in Excel


1. Explode Pie Chart in Excel Using Mouse Cursor

We will follow these steps to explode a pie chart in Excel by dragging with a cursor.

Steps:

  • First we need to select the pie chart with the mouse cursor.

  • Second, try to drag the specific portion away from the pie. In our case, we want to separate the portion of Traveling.

Explode Pie Chart in Excel Using Mouse Cursor

  • Finally, drop the portion away from the pie at an expected distance.

Explode Pie Chart in Excel Using Mouse Cursor

That’s how we explode pie very easily. For exploding multiple portions, repeat the exact same process with other portions. Here in our example, we will explode the Traveling, Music, and Electronics portions for instance.


Similar Readings


2. Use Format Data Series Option to Explode Pie Chart

Excel has a built-in function to explode pie chart. Here we will learn how to explode a pie chart in Excel using the built-in function with the steps below.

Steps:

  • Firstly, we need to select the pie chart and right-click on it.
  • Secondly, select the Format Data Series option from the selection options.

Use Format Data Series Option to Explode Pie Chart

  • As a result, selecting Format Data Series will open the Format Data Series panel.

  • Next, in the panel, we will have an option named Pie Explosion.

Use Format Data Series Option to Explode Pie Chart

  • Finally, setting Pie Explosion to different values will give us an exploded pie chart. in our case, we will set it to 20% for example and we will get the following output.

Use Format Data Series Option to Explode Pie Chart

This is how we explode pie charts very easily in excel.

Read More: How to Format a Pie Chart in Excel


Things to Remember

  • Exploding Pie Charts by Dragging with Cursor scatters the plot portions unevenly. But this method is beneficial when we need to write descriptions beside the pie.
  • Using Format Data Series option gives an evenly separated pie chart. It is visually more appealing and organized.
  • 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 for 3-D Pie charts as well.

Conclusion

Pie Charts are widely used in different sectors for analyzing and representing portions or percentages. Explosion enables us to separate each portion for visually better understanding and writing about it. This article was all about how we can explode pie charts in excel very easily. Finally, if you’re still having trouble with any of these steps, let us know in the comments. Our team is ready to answer all of your questions. If you face any kind of problems in Excel, visit our website Exceldemy for all types of excel related problem solutions.


Related Articles

Nasir Muhammad Munim

Nasir Muhammad Munim

I am Nasir Muhammad Munim from Dhaka, Bangladesh. I work as an Excel and VBA Content Developer for Exceldemy right now. Electrical and electronic engineering was my major at Islamic University of Technology, where I got my degree. I love creative works and learning new things. And I'm really into online games, especially first-person shooter games.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo