Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Create Pie Chart for Sum by Category in Excel (2 Quick Methods)

A Pie Chart is a great way to show the comparison between multiple variables. In many cases, you might need to create a Pie Chart for sum by category in Excel. Although you can’t do it directly for a Pie Chart, there are a few tricks that you can apply. This article demonstrates how to create Pie Chart for sum by category in Excel.


Download Practice Workbook

You can download the practice workbook from the link below.


2 Methods to Create Pie Chart for Sum by Category in Excel

Let’s assume, you have a dataset with a list of products that fall into three categories and their Sales Quantity. The categories are Laptop, Headphone, and Smartwatch. At this point, you want to create a Pie Chart for the sum by category. In the following stages of the article, we will show you two methods to do so.

Dataset


1. Using SUMIF Function to Create Pie Chart for Sum by Category

In this method, we will use the SUMIF function to find out the sum by category and then create a Pie Chart. Now, follow the steps below to do so.

Steps:

  • First, select cell G5 and insert the following formula.
=SUMIF(D5:D13,"Laptop",C5:C13)

In this case, cell G5 is the cell indicating the Sales Quantity of the category Laptop. Also, we used the SUMIF function which has a syntax of =SUMIF (range, criteria, [sum_range]).

Using SUMIF Function to Create Pie Chart for Sum by Category

  • Then, select cell G6 and insert the following formula.
=SUMIF(D5:D13,"Headphone",C5:C13)

Here, cell G6 is the cell indicating the Sales Quantity of the category Headphone.

Using SUMIF Function

  • After that, select cell G7 and insert the following formula.
=SUMIF(D5:D13,"Smartwatch",C5:C13)

In this case, cell G7 is the cell indicating the Sales Quantity of the category Smartwatch.

Using SUMIF Function to Create Pie Chart for Sum by Category

  • At this point, select range F4:G7.
  • Then, go to the Insert tab.
  • After that, select Insert Pie or Doughnut Chart.
  • Next, click on Pie to insert a Pie Chart.

Using SUMIF Function to Create Pie Chart for Sum by Category

After inserting the Pie Chart, now we will format the chart and add elements to make the chart more understandable and visually more appealing.

  • Now, double-click on the data series to format the data series according to your preference.
  • Also, click on Chart Element > Data Labels > Center to add Sales Quantity value to the center of each proportion.

Using SUMIF Function to Create Pie Chart for Sum by Category

Consequently, you will have your output as shown in the below screenshot.

Using SUMIF Function to Create Pie Chart for Sum by Category


Similar Readings


2. Utilizing Pivot Table to Make Pie Chart for Sum by Category

Pivot Table is a very handy tool in Excel. In this case, to create a Pie Chart for sum by category we will use a Pivot Table. Now, follow the below steps to do so.

Steps:

  • First, select the whole dataset.
  • Then, go to the Insert tab.
  • After that, select Pivot Table.
  • Next, click on From Table/Range.

Utilizing Pivot Table

  • At this point, select Existing Worksheet first or the worksheet you want to keep your Pivot Table in.
  • Then, from Location select the cell you want your Pivot Table to start. In this case, we choose cell F4.
  • Next, click on OK.

Utilizing Pivot Table

  • Now, from Pivot Table Fields select Sales Quantity and Category.
  • Or, drag Category to Rows and Sales Quantity to Values field.

Utilizing Pivot Table

  • At this point, you will have your Pivot Table as shown in the screenshot below.

Utilizing Pivot Table

  • Now, select any cell on the Pivot Table.
  • Then, go to the tab PivotTable Analyze.
  • Next, click on PivotChart.

Utilizing Pivot Table to Make Pie Chart for Sum by Category

  • Subsequently, go to Pie from the All Charts options.
  • Then, select Pie and click on OK.

Utilizing Pivot Table to Make Pie Chart for Sum by Category

  • Now, format and add elements to the chart as mentioned in the above method.

Eventually, you will have your output as shown in the below screenshot.

Utilizing Pivot Table to Make Pie Chart for Sum by Category

Note: This method is dynamic. That means if you add a new entry with its category and update the PivotTable range, you’ll get an updated chart automatically.

Read More: How to Create a Pie Chart in Excel from Pivot Table (2 Quick Ways)


How to Sum Data and Create a Pie Chart in Excel

In this section, we will sum data using the excel Consolidate feature and then create a Pie Chart for the consolidated data.

Suppose you have a dataset where you have the Sales Quantity of three different products for two different weeks as shown in the screenshot below.

How to Sum Data and Create a Pie Chart in Excel

At this point, you want to sum the Sales Quantity for each of the products over the weeks and create a Pie Chart. Now, follow the steps below to do so.

Steps:

  • First, select the cell you want to keep your consolidated data.
  • Then, go to the Data tab.
  • Next, from the Data Tools select Consolidate.

How to Sum Data and Create a Pie Chart in Excel

  • Now, from the Function select Sum.
  • After that, in Reference select the range B5 to F8.
  • At this point, from the Use labels in check the boxes for Top Row and Left Column.
  • Subsequently, click on OK.

How to Sum Data and Create a Pie Chart in Excel

  • Right now, select the range B11:C14 which represents the range for consolidated data.
  • Then, go to the Insert tab.
  • After that, select Insert Pie or Doughnut Chart.
  • Next, click on Pie to insert a Pie Chart.

How to Sum Data and Create a Pie Chart in Excel

  • Now, format and add elements to the chart as mentioned in the above method.

Consequently, you will have your output as shown in the below screenshot.

How to Sum Data and Create a Pie Chart in Excel

Read More: How to Make a Pie Chart in Excel [Video Tutorial]


💡 Things to Remember

  • In Excel, you can not directly insert a Pie Chart for sum by category.
  • In order to create a Pie Chart for sum by category, you need to categorize the data using other functions or features first.
  • You can use Bar Chart in excel which will automatically give you a chart for sum by category if it fits your preference.

Conclusion

Last but not the least, I hope you found what you were looking for from this article. If you have any queries, please drop a comment below. Also, if you want to read more articles like this, you can visit our website ExcelDemy.


Related Articles

Sowmik Chowdhury

Sowmik Chowdhury

Hello! Welcome to my Profile. I , Sowmik Chowdhury, graduated from the Bangladesh University of Engineering and Technology from the Department of Naval Architecture and Marine Engineering. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this..

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo