How to Group Small Values in Excel Pie Chart (2 Suitable Examples)

The pie chart represents numerical data of analysis through slices that form a circular graph. It is challenging to draw pie charts because they present data as a percentage or as a value in a circular graph. Excel has made it easier and more popular to analyze pie charts graphically. If you are looking for some special tricks to create a pie chart with a group of small values in Excel, you’ve come to the right place. This article will discuss two suitable examples of creating a pie chart with a group of small values in Excel. Let’s follow the complete guide to learn all of this.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article. It contains all the datasets in different spreadsheets for a clear understanding. Try yourself while you go through the step-by-step process.


2 Suitable Examples to Group Small Values in Excel Pie Chart

In the following section, we will use two effective and tricky methods to create a pie chart with a group of small values in Excel. Our process for creating a more understandable pie chart involves organizing the data, creating a pie chart, and then customizing the graph by adding elements and editing the layout. This section provides extensive details on these methods. You should learn and apply these to improve your thinking capability and Excel knowledge. We use the Microsoft Office 365 version here, but you can utilize any other version according to your preference.


1. Group Small Values with Pie of Pie Chart

Here, we will demonstrate how to make a pie of pie chart with a group of small values in Excel. At first, we have to prepare a dataset containing total sales in different months as shown below. Let’s walk through the following steps to create a pie of pie chart with a group of small values.

📌 Steps:

  • First, input the name of the 12 months in the range of cells B5:B15 and total sales of the corresponding month in the range of cells C5:C15. Variables on the X-axis are represented by row headers, while variables on the Y-axis are represented by column headers.

Group Small Values with Pie of Pie Chart

  • Now, we are going to insert a pie of pie chart for our dataset. Through this chart, we can easily combine the group of small values in “Other”.
  • First of all, select the range of the cells B5:C15.
  • Next, in the Insert tab, click on the drop-down arrow of the Insert Pie or Doughnut Chart from the Charts group.
  • Then, choose the Pie of Pie chart.

How to Group Small Values in Excel Pie Chart

  • As a consequence, you will get the following pie of pie chart.

  • Next, you can find the list of chart elements by clicking the Plus (+) icon from the right corner of the chart.
  • Here, you have to mark the elements to add or unmark the elements to remove.
  • You will find an arrow on the element, where you will find other options to edit the elements.
  • Here, we will mark the Data Labels to show the corresponding data in the chart.

How to Group Small Values in Excel Pie Chart

  • Next, double-click on the data labels and select Format Data Labels.

  • As a result, a side window called Format Data Labels will appear.
  • Now, in the Label Options drop-down, go to the Label Options option.
  • After that, uncheck the Value option and check the Percentage option.
  • You will see the data percentage in the pie of pie chart.

How to Group Small Values in Excel Pie Chart

  • Then, you have to right-click any of the slices of the chart and select Format Data Series.

How to Group Small Values in Excel Pie Chart

  • When the Format Data Series window appears, select the Percentage Value option in the Split Series By drop-down list.

  • Next, type 5% in the Values less than a box.

How to Group Small Values in Excel Pie Chart

  • Through this chart, we can easily combine the group of small values (less than 5% value) in “Other” as shown below.

  • To modify the chart style, select Chart Design and then, select your desired Style 3 option from the Chart Styles group.

How to Group Small Values in Excel Pie Chart

  • As a consequence, you will get the following pie of pie chart.

  • Next, we want to combine the group of small values (less than 5% value) in “Other” and show this on the chart. To do this you have to modify the chart style. In order to accomplish this, we select Chart Design, then Quick Layout, and finally select Layout 1 from the Quick Layout group.

How to Group Small Values in Excel Pie Chart

  • Therefore, we will be able to create a pie of pie chart with a group of small values as shown below.

How to Group Small Values in Excel Pie Chart

Read More: How to Show Pie Chart Data Labels in Percentage in Excel


Similar Readings


2. Group Small Values with Bar of Pie Chart

Here, we will demonstrate how to make a bar of pie chart with a group of small values in Excel. At first, we have to prepare a dataset containing the total sales of different items as shown below. Let’s walk through the following steps to create make a bar of pie chart with a group of small values.

📌 Steps:

  • First, input the name of the items in the range of cells B5:B15 and the total sales of the corresponding item in the range of cells C5:C15. Variables on the X-axis are represented by row headers, while variables on the Y-axis are represented by column headers.

Group Small Values with Bar of Pie Chart

  • Now, we are going to insert a pie of pie chart for our dataset. Through this chart, we can easily combine the group of small values in “Other”. First of all, select the range of the cells B5:C15.
  • Next, in the Insert tab, click on the drop-down arrow of the Insert Pie or Doughnut Chart from the Charts group.
  • Then, choose the Bar of Pie chart.

How to Group Small Values in Excel Pie Chart

  • As a consequence, you will get the following bar of a pie chart.

  • Next, you can find the list of chart elements by clicking the Plus (+) icon from the right corner of the chart.
  • Here, you have to mark the elements to add or unmark the elements to remove.
  • You will find an arrow on the element, where you will find other options to edit the elements.
  • Here, we will mark the Data labels to show the corresponding data in the chart.

  • Next, double-click on the data labels and select Format Data Labels.

How to Group Small Values in Excel Pie Chart

  • As a result, a side window called Format Data Labels will appear.
  • Now, in the Label Options drop-down, go to the Label Options option.
  • After that, uncheck the Value option and check the Percentage option.

  • You will see the data percentage in the pie of pie chart.

How to Group Small Values in Excel Pie Chart

  • Then, you have to right-click any of the slices of the chart and select Format Data Series.

  • When the Format Data Series window appears, select the Percentage Value option in the Split Series By drop-down list.

How to Group Small Values in Excel Pie Chart

  • Next, type 5% in the Values less than box.

  • Through this chart, we can easily combine the group of small values (less than 5% value) in “Other” as shown below.

How to Group Small Values in Excel Pie Chart

  • To modify the chart style, select Chart Design and then, select your desired Style 3 option from the Chart Styles group.

  • As a consequence, you will get the following pie of pie chart.

How to Group Small Values in Excel Pie Chart

  • Next, we want to combine the group of small values (less than 5% value) in “Other” and show this on the chart. To do this you have to modify the chart style. In order to accomplish this, we select Chart Design, then Quick Layout, and finally select Layout 6 from the Quick Layout group.

  • Therefore, we will be able to create a bar of pie chart with a group of small values as shown below.

How to Group Small Values in Excel Pie Chart

Read More: How to Create A Doughnut, Bubble and Pie of Pie Chart in Excel


💬 Things to Remember

✎ Before inserting a pie chart, you must select anywhere in the dataset. The rows and columns will need to be manually added otherwise.

✎ When working with a large dataset, avoid pie charts since they will create confusing graph information.

✎ If you want to switch rows and columns remember that before switching rows and columns, make sure they are all selected.


Conclusion

That’s the end of today’s session. I firmly believe that from now you may be able to create a pie chart with a group of small values in Excel. If you have any queries or recommendations, please share them in the comments section below.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib

Saquib

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo