How to Make Pie Chart with Breakout in Excel (Step by Step)

Get FREE Advanced Excel Exercises with Solutions!

Excel datasets contain sectionized data that can be referred to as breakout. The typical way to make a pie chart with breakout in Excel involves inserting pie charts for each of the different sections or periods.

Let’s say we have dummy Sales Data (Pics) for an entire year divided into quarters. Each quarter represents a separate section or period.

In this article, we discuss data breakout and demonstrate step by step process to make a pie chart with breakout in Excel.

Table of Contents hide

Download Excel Workbook

Explaining Data Breakouts

Step by Step Process to Make Pie Chart with Breakout in Excel

Step 1: Insert a Pie Chart Using the First Breakout Data

Step 2: Repeat the Chart Insertion for Other Breakouts

Conclusion

Download Excel Workbook

Making Pie Chart with Breakout.xlsx

Explaining Data Breakouts

Data representing multiple sections, ranges, groups, or periods is common in Excel datasets. Each of those sections, ranges, groups, or periods is referred to as breakouts. So, in our dataset, each quarter is a breakout. Therefore, we have 4 breakouts in our dataset.

Step by Step Process to Make Pie Chart with Breakout in Excel

As breakouts are the different specific sections or periods of a dataset, users need to select any of the sections or periods to insert a pie chart. Follow the below steps to make a pie chart with breakouts in Excel.

Step 1: Insert a Pie Chart Using the First Breakout Data

🔄 Highlight the breakout along with the legends. After that, go to Insert > Click Insert Pie or Doughnut Chart > Choose any Pie Chart (i.e., 2D Pie).

🔄 In a moment, Excel inserts the 1^st breakout pie chart as depicted in the below image. Tick Chat Title, Data Labels, and Legend under Chart Elements from the side menu Plus Icon options.

⧭ You can choose any Pie Chart design from the options to organize your breakouts.

Step 2: Repeat the Chart Insertion for Other Breakouts

🔄 As mentioned earlier, the dataset has 4 separate quarters and if users want to make pie charts for all the breakouts, just repeat Step 1. Finally, you’ll have a depiction similar to the image below representing all the breakouts into pie charts.

Conclusion

This article discusses data breakouts and step by step process to make a pie chart with a breakout in Excel. We hope the above discussion clarifies the concept of breakouts and helps you make pie charts with them. Comment if you have further inquiries or have anything to add.