How to Make a Pie Chart in Google Sheets

How to make a Pie Chart in Google Sheets 21

In this article, we will learn how to make a Pie Chart in Google Sheets. But firstly, let us discuss what is Pie Chart and hoe it can be used to solve our problems in Google Sheets.

Google Sheets provide an excellent way to keep records of data and manage and utilize those records in most efficient way. Those records are mostly stored for the future use and decision making. Google Sheets is preferred and recommended tool for data keeping because it allows a bundle of tools for automation and saves up a lot of manual effort of users. We can just use those automated tools for making summary on our data, find out a specific term or create reports and much more. In the same way, Google Sheets provide us with automated tools to create charts and graphs for our provided data and records.

What is a Pie Chart in Google Sheets?

Pie Chart is one such provided tool by Google Sheets. Google Sheets provide us with creating Pie charts with minimum effort. All we need to do is to select data for Pie Chart and create it. There is no need to create it manually spending a lot of precious time of users. And also, as the data change, there is no need to change the Pie Chart manually rather automated tools provided by Google Sheets can be utilized.

In this article, we will discuss the following about making Pie Charts in Google Sheets:

  • How to make a Simple Pie Chart in Google Sheets?
  • How to make a 3D Pie Chart in Google Sheets?
  • How to make a Percentage Pie Chart in Google Sheets?
  • How to make a Pie Chart 1/10 in Google Sheets?
  • How to make a Pie Chart Budget in Google Sheets?

The method for making Pie Chart in Google Sheets along with instructions on 3D Pie Chart, Percentage Pie Chart, Pie Chart 1/10 and Pie Chart Budget is elaborated below with complete details.

See also  How to Find Absolute Value in Google Sheets (4 Methods)

Use Cases of Pie Chart in Google Sheets

One of the very basic purpose of Google Sheets is to store records and provide automation tools on that set of data and records. Data is mostly stored in the form of text and categorized in cells. We may need to make a graphical representation of summary of data. Google Sheets provide automated tools for making graphs and charts. In the same way, we can create Pie Charts using automated tools provided by Google Sheets.

We may have a worksheet which has data about sales of different objects in terms of Dollars. Now we need to have a quick look at which products make up most of the revenue and which products do not contribute that much. It is possible to look at sales value of each product one by one but this gets tiring and exhausted as number of products keep increasing, also visualization of all this data in the form of pie graph will make it very easy to understand the composition of revenue due to these objects. So making a pie chart of the given sales value is the best choice for better accuracy as well as time saving.

Let us demonstrate the method to make a Pie Chart in Google Sheets as below.

See also  How to Use Transpose Function In Google Sheets (Easy Guide)

How to Make Pie Chart in Google Sheets

It is very easy to make Pie Chart in Google Sheets. We can create a simple Pie Chart, 3D Pie Chart, Percentage Pie Chart, Pie Chart 1/10 and Pie Chart Budget and much more in a very easy way in Google Sheets.

Let us discuss the methods for above mentioned Pie Charts below.

How to Make a Simple/2D Pie Chart in Google Sheets

Step 1: Open the Google Sheet which contains the data for making Pie Chart.

Let us use the data of sales of various products for a store in terms of Dollars and find out by making pie chart about how much revenue does each product contribute to total revenue of the store.

How to make a Pie Chart in Google Sheets 1

Step 2: Select the values for making Pie Chart as:

How to make a Pie Chart in Google Sheets 2

Selected cells will appear in blue boundaries as above.

Step 3: Insert the Pie Chart using one of the methods below:

Method 1: Go to Insert Menu and further choose Charts.

Insert -> Chart

How to make a Pie Chart in Google Sheets 3

Method 2: Select the Insert Chart Icon shown on the panel as:

How to make a Pie Chart in Google Sheets 4

As soon as you click Chart using any of the above two methods, Chart based upon the selected data along with Chart Editor will appear as:

How to make a Pie Chart in Google Sheets 5

But we can see that this is column chart not Pie Chart so we will change the chart type to Pie Chart and work on it using Chart Editor.

Step 4: Set the chart type to Pie Chart from Chart Editor as below:

How to make a Pie Chart in Google Sheets 6

Chart will take the form as below:

How to make a Pie Chart in Google Sheets 7

We can see that we got our desired Pie Chart as above which shows the contribution of each of product sales in Total Revenue. We can edit it further using Chart Editor.

Step 5: We can name the pie chart using Chart Editor as:

Chart Editor -> Customize -> Chart and Axis Title -> Chart Title

We can reach Pie Chart Title by following the above mentioned steps as:

How to make a Pie Chart in Google Sheets 8

Now put in the new name for the pie chart in the input text box as:

How to make a Pie Chart in Google Sheets 9

Now pie chart title is automatically updated as:

How to make a Pie Chart in Google Sheets 10

Step 6: We can choose to show values of each pie slice in it, by following the procedure below using Chart Editor:

Chart Editor -> Customize -> Pie Chart -> Slice Label -> Value

How to make a Pie Chart in Google Sheets 11

Our Simple Pie Chart appears along with values of each Pie Slice as below:

How to make a Pie Chart in Google Sheets 12

This is the simple Pie Chart for Revenue Details 2022.

See also  How to Copy Conditional Formatting in Google Sheets (2 Methods)

How to Make a 3D Pie Chart in Google Sheets

Here, in this case, we will use the recently made Pie Chart as above to make a 3D Pie Chart with a little modifications. So let us assume that we have made a simple Pie Chart as above and now we want to make it 3D Pie Chart or make a new 3D Pie Chart. We can do so, using Chart Editor by following the steps below:

Step 1: Make a simple Pie Chart with the data required to be made into a 3D Pie Chart.

Here, we can also use the above made Pie Chart or make an identical one so, we have the chart as:

How to make a Pie Chart in Google Sheets 13

Step 2: Select Edit Chart option to get Chart Editor pop-up window.

We can do so by clicking on the triple dot Icon on top right corner of chart as below:

How to make a Pie Chart in Google Sheets 14

Chart Editor will appear as:

How to make a Pie Chart in Google Sheets 15

We can also change the Chart Title in Chart Editor by following the procedure as:

Chart Editor -> Customize -> Chart and Axis Title -> Chart Title

Now, Pie Chart is named as “3D Pie Chart Revenue Details 2022” according to requirements as:

How to make a Pie Chart in Google Sheets 16

Step 3: Convert the Pie Chart into 3D Pie Chart using one of the methods below:

Method 1: Select “3D Pie Chart” from Chart Type inside Setup menu.

We can do so by clicking on Chart Type then it shows all possible charts and graphs to be used. We will see a Pie Section in it. Find 3D Pie Chart in that section as:

How to make a Pie Chart in Google Sheets 17

Method 2: Check the 3D checkbox in Chart Style of Customize menu of Chart Editor.

Make sure that Customize menu is open in Chart Edit. In the start, you will find a Chart Style option, check the 3D checkbox to confirm that you need 3D version of Pie Chart as:

How to make a Pie Chart in Google Sheets 18

By selecting 3D Pie Chart using any of the two ways, we can see that our Pie Chart appears in more of a 3D format rather than 2D format. It makes the graph look more appealing as well as provide better visualization of data being used in the process. Thickness of Pie can now be seen for the purpose of visualization and making it more appealing to the eyes.

3D Pie Chart appears as:

How to make a Pie Chart in Google Sheets 19

We can further edit it using Chart Editor as per requirements of the project.

Step 4: We can choose to show value in Pie Slices by going through the following steps:

Chart Editor -> Customize -> Pie Chart -> Slice Label -> Value

How to make a Pie Chart in Google Sheets 20

We see our 3D Pie Chart with label values as:

How to make a Pie Chart in Google Sheets 21

See also  How to Use COUNTIF & COUNTIFS in Google Sheets

How to Make a Percentage Pie Chart in Google Sheets

Percentage Pie Chart is the Pie Chart that shows percentage of how each Pie Slice contribute to whole pie chart rather than each slice’s individual values. Google Sheets facilitates the users by automatically providing percentage values in the form of Legend Text. As you can see above, Simple Pie Chart also had Percentage values for each and every slice in the form of Legend Text.

Step 1: Make a Pie Chart.

As mentioned above, we need not to follow a different procedure for obtaining Percentage Pie Chart in Google Sheets. Rather following the procedure for “How to make a Pie Chart?” mentioned above can be used to make a Percentage Pie Chart. So, following the same procedure, we have Percentage Pie Chart as:

How to make a Pie Chart in Google Sheets 22

Percentage Pie Chart is shown above.

Step 2: Add Percentage to pie slices.

We can also add Percentage values to slices by following the procedure below in Chart Editor as:

Chart Editor -> Customize -> Pie Chart -> Slice Label -> Percentage

Follow the procedure as:

How to make a Pie Chart in Google Sheets 23

Now, you can see the Percentage Pie Chart as:

How to make a Pie Chart in Google Sheets 24

See also  How to Use Google Sheets Conditional Formatting Based on Another Column

How to Make a Pie Chart 1/10 in Google Sheets

Pie Chart 1/10 may means to make a Pie Chart that is holding up a Pie but that that pie is around 1/10 of its volume. Here, we can make a Pie Chart that is empty inside and basically shapes like a doughnut or more specifically called donut.

Step 1: Make a Pie Chart or any simple chart based on the data by following the procedure above in “How to make a Pie Chart?”

Let us use the same data for the purpose of demonstration and make a Pie Chart as:

How to make a Pie Chart in Google Sheets 25

You can set the Chart title by following the following steps (as shown in above methods):

Chart Editor -> Customize -> Chart and Axis Title -> Chart Title -> Enter new title

Step 2: Make it a Doughnut Pie Chart.

We can follow any of the methods below to convert the Pie Chart into 1/10 (Donut) Pie Chart.

 Method 1: Provide Donut Hole value in Chart Editor.

Use the following set of steps to provide Donut Hole value for the Pie Chart:

Chart Editor -> Customize -> Pie Chart -> Donut Hole

You can see the steps as:

How to make a Pie Chart in Google Sheets 26

Different values for Donut Hole can be utilized as per the problem requirements.

Method 2: Convert the Chart Type to Doughnut (Pie) Chart.

                Use the following set of steps to convert the chart into a doughnut chart 1/10 as:

Chart Editor -> Setup -> Chart Type -> Doughnut Chart

These steps can be seen below:

How to make a Pie Chart in Google Sheets 27

Using any of the above methods, we can see the Pie Chart as:

How to make a Pie Chart in Google Sheets 28

Step 3: We may choose to show values in Pie Slices by following the steps as:

Chart Editor -> Customize -> Pie Chart -> Slice Label -> Value

Now, we have our Donut (Doughnut) 1/10 Pie Chart as:

How to make a Pie Chart in Google Sheets 29

Step 4: We may want it to appear in 3D view. We can do so by checking the checkbox of 3D in Chart Style section of Chart Editor using:

Chart Editor -> Chart Style -> 3D (check it)

So, our chart becomes:

How to make a Pie Chart in Google Sheets 30

See also  How to Slice a String in Google Sheets [4 Easy Methods]

How to Make a Pie Chart Budget in Google Sheets

In order to make a Pie Chart Budget, we need to have budget data that we can summarize in the form of Pie Chart.

Step 1: Open the Google Sheet which contains the budget for making Pie Chart.

Let us use the following budget doe making a Pie Chart Budget in Google Sheets:

How to make a Pie Chart in Google Sheets 31

Step 2: Select the data cells required to be made into a Pie Chart Budget.

Here, let us select the cells as:

How to make a Pie Chart in Google Sheets 32

Step 3: Create a Chart by following the steps as:

Insert -> Chart

How to make a Pie Chart in Google Sheets 33

Chart will appear as:

How to make a Pie Chart in Google Sheets 34

Click on triple dot icon and then Chart Editor to edit the chart further.

Step 4: Change the Chart Type to Pie Chart by following:

Chart Editor -> Setup -> Chart Type -> Pie Chart

How to make a Pie Chart in Google Sheets 35

So, our Pie Chart Budget appears as:

How to make a Pie Chart in Google Sheets 36

Step 5: We can change the Pie Chart Title as well as choose to show values of Pie Slices inside of Pie Chart by using Chart Editor; “Chart Axis and Titles” and “Pie Chart -> Slices -> Value” menus.

Now our Pie Chart Budget has taken the form as:

How to make a Pie Chart in Google Sheets 37

See also  How to use the PI Function in Google Sheets [With Examples]

Notes to Remember about Pie Chart in Google Sheets

  • We can outline the borders of Pie Slices by specifying border color in Chart Editor -> Customize -> Pie Chart -> Border Color.
  • We can also choose to take out one or more Pie Slice(s) outside of Pie in Pie Chart by following these steps:
    • Chart Editor -> Customize -> Pie Slice -> Distance from Center
  • Specify the value for Distance inside the input box and you can see the slice lifted away from center of Pie as:

How to make a Pie Chart in Google Sheets 38

FAQs

What is the difference between Pie Chart and 3D Pie Chart?

Pie Chart attempts to show the representation of charted values in the form of a 2D Pie. 3D Pie Chart serves the same purpose, the only difference between the both is that 3D Pie Chart shows a 3D version of Pie Chart, giving the pie a more of a 3D look and present more appealing.

Is it possible to make multiple graphs or charts on same set of data?

Yes, you can make as many graphs and charts as you want on the same set of data (before running out of memory). These charts may be identical or different, but there is no limitation as such.

Can I download the Pie Chart that I created?

Yes, Google Sheets allow users to download the charts they create inside Google Sheets as a separate png picture or PDF document. You can download by clicking the triple dot icon of Chart and further select Download from list of options as:

How to make a Pie Chart in Google Sheets 39

How can I delete the Pie Chart from Google Sheets?

Deleting charts is permissible in Google Sheets. You can delete a chart by clicking on its triple dot icon and further select Delete Chart.

Can I move the Chart from top of my data to the side?

Yes, Charts can be moved from one location to the others within a document. You can drag and drop the chart to desired location.

Do I have to make the chart again if I change my values?

No, you are not required to update or make new chart if values within the chart changes. Google Sheets automatically detects the changes and adjusts the charts according to those values. So, there is no need to explicitly change the charts.

See also  How to Find Column Letters in Google Sheets [Easy Guide]

Conclusion

Google Sheets allows us many automated services and features for the ease of user. Pie Chart is one of those automated tools provided by Google Sheets. It provides summarization of data in the form of a Pie Chart indicating different data with different colors in the form of Pie.

In this article, we discussed how to make Pie Chart in Google Sheets. We also discussed how to make a simple Pie Chart, 3D Pie Chart, Percentage Pie Chart, Pie Chart 1/10 and Pie Chart with step by step procedure and screenshots in Google Sheets.

Any queries about the given topic and methods are most welcome to be entertained. Feel free to share your thoughts in the comment section below.

Thanks for Reading!

Content Protection by DMCA.com

Widad Khan

Hi, I am Widad Khan. I was born and raised in Pakistan. I have always loved the field of Computer Sciences and since I was a kid, I would say I wanna grow up to be a scientist, now this term is mostly related to "Computer Scientist" and not scientist alone. I am pursuing my Bachelor Degree in Computer Sciences from GCU, Lahore. I have always loved keeping records of different types of data. Earlier, I would use MS Excel for that. But with the advancements in Google Sheets, my work has become much easier. And also it's very easy to share and coordinate data with fellows and coordinates.

OfficeDemy.com
Logo
Enable registration in settings - general