How to Change Pie Chart Percentage to Number in Google Sheets

Suppose you are working on a dataset that contains every month’s sales and you need to analyze this data. Imagine how hard it could be. Because if you analyze every data manually then this procedure is very time-consuming and tiring. In this case, the pie chart is a helpful process. If you show your data through a pie chart then this is very easy to process and understand. But most of the time pie chart contains percentage by default. In this article, we will learn how to change pie chart percentage to number in google sheets.

Here is the overview image to change pie chart percentage to number in google sheets. Hope you’ll learn more after you go through the total article.

Table of Contents

A Sample of Practice Spreadsheet

You may copy the spreadsheet below and practice by yourself.

Change Pie Chart Percentage to Number

What Is Pie Chart in Google Sheets?

The Pie Chart is a type of graph that is a circle in shape and divided into portions where each portion represents a value. Here, each size of the portion or slice is proportional to the actual number in the dataset. Basically, a pie chart is a statistical graphical chart it is used when you need to show someone the percentage of the whole dataset or you need to represent if a part is large or small in the dataset. On the other hand, if there are two almost similar data in a dataset then you should avoid a pie chart.

Step by Step Procedures to Change Pie Chart Percentage to Number in Google Sheets

The below dataset contains Company Name and Profit of the leading companies. Here, we will learn how to change pie chart percentage to number in google sheets using the following dataset. So, let’s start.

Step 1: Create a Pie Chart

Now, we will create a pie chart using the following dataset.

First, select the dataset range B4:C10 to create the pe chart. As B4:C4 will be used as the header row.

Then, select Insert >> Chart to insert a chart in google sheets.

After that, a Pie chart will appear with the given data as below.

Therefore, the above data shows the details in the “Chart editor”. The Chart type is Pie chart, the Data range is B4:C10, row 4 is used as the header row and Column B is used as labels.

Similar Readings

Step 2: Change Percentage to Number in Pie Chart

Following, we will change the pie chart percentage to number using the above data.

Now, select the 3 dots in the pie chart and select Edit chart to edit the chart.

Again, Chart editor will pop up and select Customize as below.

Moreover, select Pie chart from Customize as follows.

Consequently, select Value from Slice label to get the value in the pie chart.

Now, the output of choosing value is below.

After that, select Legend >> Position >> Left from customize to remove the percentage from the chart.

Finally, the output to change the pie chart percentage to number is below.

Things to Remember

The pie chart always shows the percentage of the data by default.
Your selected first row is considered the header row. But you can change the feature.

Conclusion

In this article, we explained how to change pie chart percentage to number in google sheets with practical examples. Hopefully, the methods will help you to apply this feature to your own dataset. Please let us know in the comment section if you have any further queries or suggestions. You may also visit our OfficeWheel blog to explore more Google Sheets-related articles.