How to Group Small Values in an Excel Pie Chart (2 Methods)

 

Method 1 – Group Small Values with Pie of Pie Chart

  • Prepare Your Data
    • Input the names of the 12 months in cells B5:B15.
    • Enter the total sales for each corresponding month in cells C5:C15.
    • The X-axis variables are represented by row headers, while Y-axis variables are represented by column headers.

Group Small Values with Pie of Pie Chart

  • Insert the Pie of Pie Chart
    • Select the range of cells B5:C15.
    • In the Insert tab, click the drop-down arrow next to Pie or Doughnut Chart in the Charts group.
    • Choose the Pie of Pie chart type.

How to Group Small Values in Excel Pie Chart

  • This chart allows you to combine small values into an Other category.

  • Customize the Chart
    • Click the plus icon (+) on the chart to access chart elements.
    • Mark elements to add or unmark elements to remove.
    • Edit elements using the options available.
    • Enable Data Labels to display corresponding data on the chart.

How to Group Small Values in Excel Pie Chart

    • Double-click the Data Labels and select Format Data Labels.

    • In the Label Options drop-down, choose Percentage instead of Value.

How to Group Small Values in Excel Pie Chart

  • Combine Small Values
    • Right-click any slice of the chart and select Format Data Series.

How to Group Small Values in Excel Pie Chart

    • In the Format Data Series window, choose Percentage Value in the Split Series By drop-down.

    • Specify a threshold (e.g., 5%) in the Values less than box.

How to Group Small Values in Excel Pie Chart

    • This combines small values (less than 5%) into the Other category.

  • Modify Chart Style
    • Go to Chart Design and select your desired style (e.g., Style 3) from the Chart Styles group.

How to Group Small Values in Excel Pie Chart

    • The pie of pie chart will display as follows:

  • Show Small Values in the Chart
    • To display the combined small values, modify the chart style further.
    • Select Chart Design, then Quick Layout, and choose Layout 1 from the Quick Layout group.

How to Group Small Values in Excel Pie Chart

  • By following these steps, you’ll create a pie of pie chart that effectively groups small values.

How to Group Small Values in Excel Pie Chart

Read More: [Solved]: Excel Pie Chart Not Grouping Data


Method 2 – Group Small Values with a Bar of Pie Chart

  • Prepare Your Data
    • Input the names of the items in cells B5:B15.
    • Enter the total sales for each corresponding item in cells C5:C15.
    • The X-axis variables are represented by row headers, while Y-axis variables are represented by column headers.

Group Small Values with Bar of Pie Chart

  • Insert the Bar of Pie Chart
    • Select the range of cells B5:C15.
    • In the Insert tab, click the drop-down arrow next to Pie or Doughnut Chart in the Charts group.
    • Choose the Bar of Pie chart type.
    • This chart allows you to combine small values into an Other category.

How to Group Small Values in Excel Pie Chart

  • The bar of a pie chart will be displayed:

  • Customize the Chart
    • Click the plus icon (+) on the chart to access chart elements.
    • Mark elements to add or unmark elements to remove.
    • Edit elements using the available options.
    • Enable data labels to display corresponding data on the chart.

    • Double-click the data labels and select Format Data Labels.

How to Group Small Values in Excel Pie Chart

    • In the Label Options drop-down, choose Percentage instead of Value.

    • The data percentage will appear in the pie of pie chart.

How to Group Small Values in Excel Pie Chart

  • Combine Small Values
    • Right-click any slice of the chart and select Format Data Series.

    • In the Format Data Series window, choose Percentage Value in the Split Series By drop-down.

How to Group Small Values in Excel Pie Chart

    • Specify a threshold (e.g., 5%) in the Values less than box.

    • This combines small values (less than 5%) into the Other category.

How to Group Small Values in Excel Pie Chart

  • Modify Chart Style
    • Go to Chart Design and select your desired style (e.g., Style 3) from the Chart Styles group.

    • The following pie of pie chart will display:

How to Group Small Values in Excel Pie Chart

  • Display Small Values
    • To show the combined small values, further modify the chart style.
    • Select Chart Design, then Quick Layout, and choose Layout 6 from the Quick Layout group.

How to Group Small Values in Excel Pie Chart

Read More: How to Make Pie Chart by Count of Values in Excel


Things to Remember

✎ Before inserting a pie chart, select anywhere in the dataset.

✎ Avoid pie charts for large datasets to prevent confusion.

✎ When switching rows and columns, ensure all relevant data is selected.


Download Practice Workbook

You can download the practice workbook from here:


Related Articles


<< Go Back To Excel Pie ChartExcel ChartsLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo