To Make a Pie Chart in Google Sheets
- Select the data you want to visualize.
- Go to “Insert” and choose “Chart“.
- In the Chart Editor, select “Pie Chart”.
- Customize your chart, including title and colors.
- To add percentage values, enable “Percentage” in the Chart Editor.
- Click “Insert” to add the Pie Chart to your sheet.
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.
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.
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.
Step 2: Select the values for making Pie Chart as:
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
Method 2: Select the Insert Chart Icon shown on the panel as:
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:
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:
Chart will take the form as below:
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:
Now put in the new name for the pie chart in the input text box as:
Now pie chart title is automatically updated as:
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
Our Simple Pie Chart appears along with values of each Pie Slice as below:
This is the simple Pie Chart for Revenue Details 2022.
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:
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:
Chart Editor will appear as:
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:
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:
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:
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:
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
We see our 3D Pie Chart with label values as:
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:
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:
Now, you can see the Percentage Pie Chart as:
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:
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:
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:
Using any of the above methods, we can see the Pie Chart as:
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:
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 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:
Step 2: Select the data cells required to be made into a Pie Chart Budget.
Here, let us select the cells as:
Step 3: Create a Chart by following the steps as:
Insert -> Chart
Chart will appear as:
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
So, our Pie Chart Budget appears as:
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:
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:
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.
Is the Process of Making a Pie Chart Similar in Google Forms and Google Sheets?
Creating pie charts in google forms and Google Sheets is a simple process. In Google Forms, you can add a pie chart by selecting the Multiple choice question type and choosing Pie chart as the response validation. In Google Sheets, you can create a pie chart by highlighting the data you want to use, clicking on the Insert tab, and selecting Chart. Both platforms make it easy to visualize data using pie charts.
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 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.
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!