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.

Overview How to use 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.


A Sample of Practice Spreadsheet

You may copy the spreadsheet below and practice by yourself.


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.

Dataset


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.

Select rangs to chnage pie chart percentage to number

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

Insert chart

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

Pie Chart

  • 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.

Read More: How to Make a 3D Pie Chart in Google Sheets (With Quick Steps)


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.

Edit chart to change pie chart percentage to number in google shhets

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

Customize chart

  • Moreover, select Pie chart from Customize as follows.

Select pie chart

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

Edit Pie chart

  • Now, the output of choosing value is below.

Pie chart completed

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

edit legend

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

Output to change pie chart percentage to number in google sheets

Read More: How to Edit a Pie Chart in Google Sheets (5 Core Features)


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.


Related Articles

Afrina

Afrina

This is Afrina Nafisa. Currently working as a Technical Writer at OFFICEWHEEL.COM. I have done my graduation from Ahsanullah University of Science and Technology. As I am eager to learn more and more currently my motive is to make myself better every day with my work so that I can make better content for all the readers.

We will be happy to hear your thoughts

Leave a reply

OfficeWheel
Logo