Watch Video: How to Make a Pie Chart in Google Sheets
There are a number of visualization options available in Google Sheets, one of which is the Pie Chart. This tool lets you visualize data and see how individual data elements contribute as parts of a whole. Creating a pie chart in Google Sheets is as easy as…well, pie.
In this tutorial, we will show you how to make a pie chart Google Sheets, how to edit the chart, style it and customize it according to your requirements.
What is a Pie Chart?
A pie chart is a visualization tool that is used to represent data and helps express part-to-whole relationships in data.
Just like each slice of an actual pie represents one component (or portion) of the whole pie, each slice of the pie chart represents a portion of the entire quantity (or Sum total) of a variable. Moreover, all the slices combined together make up the whole pie. In the same way, all the individual portions of the pie chart, when combined together, should add up to 100% of the quantity.
When are Pie Charts Used?
Google Sheet pie charts are excellent visualization options when you want to show percentages or parts of a quantity. As such, it is the perfect tool to represent percentages of different types of customers, profits from different types of products, demographic information, etc.
In fact, whenever you encounter the words ‘percent of’ or ‘part of’, you’re probably going to need a pie chart to visualize the data.
It is also often used in dashboards since it is simple, aesthetic, and easy to understand.
In general, there are two main use-cases that call for a pie chart:
- When you want to put across a sense of how each part or type of data contributes to a whole. For example, if you want to show how different sales reps of a company contributed to the total company sales for the month.
- When you want to show how one segment of the total quantity is relatively smaller or larger. For example, if you want to show that there are more men in a given company’s workforce as compared to women.
It’s important to note, however, that you should not use pie charts to compare data across different quantities (or pies). You should also never use it when you’re visualizing portions that don’t add up to 100%.
How to Make a Pie Chart in Google Sheets
Let’s say you have the following dataset, consisting of revenue obtained from 5 different regional assets of an imaginary organization.
To visualize how much each region has contributed to the total revenue, we can use a pie chart. Let’s see how to create a pie chart in Google Sheets to visualize the above data:
Step 1: Select the range of cells that contain your data range (cells A1:B6 in this case).
Step 2: Navigate to Insert->Chart.
Step 3: You should now see a chart displayed to represent your data, and a Chart Editor sidebar to the right side of the browser. This chart editor pane is your pie chart maker Google Sheets.
Step 4: Google Sheets normally tries to recommend the best chart to represent your selected data range. So if you see a Pie chart displayed, you can stop here. However, if you see some other type of chart displayed, go to step 5.
Step 5: Click on the Setup tab (of the Chart editor) and click on the dropdown arrow just below ‘Chart Type’.
Step 6: You should see options for different types of charts in the drop-down menu that appears. Select ‘Pie Chart’, which you should find under the Suggested or Pie category.
That’s it, you should now see a pie chart giving a visual representation of your selected data range. Each slice of the pie is in a different color, representing how much each region contributes to the total revenue.
This is all there is to know about how to make a pie graph in Google Sheets. Easy as pie!
As you can see, labels automatically show each slice’s pie chart percentage.
How to Make a 3D Pie Chart in Google Sheets.
You can also make a 3D pie chart in Google Sheets. If you are in the process of making the pie chart, you can choose the 3d pie chart in the chart editor pane.
In the setup section, go to the chart type drop-down menu and scroll down to the pie chart options. Select the third pie chart option, which is the 3D pie chart.
You can also still change your pie chart to a 3d pie chart after making it in the same way in the chart editor. You can go to the customize section and tick on 3D
How to Create a Double Pie Chart.
There are times you may wish to represent multiple ranges of data at once. Unfortunately, there’s no pie of pie chart Google Sheets option unlike in Excel. If you want to make a double pie chart, you will have to make it manually by combining two doughnut charts.
In our table below, let’s say we want to compare the number of shoes sold and the total sale price for each shoe,
Step 1: Select the data range you wish to represent.
Step 2: Go to insert then chart
Step 3: In the chart type choose a doughnut pie chart
Step 4: In the chart editor, go to customize the pie chart.
Step 5: Change the donut hole to 75%
Step 6: To create the second pie chart, click Insert > Chart again
Step 7: Choose the doughnut pie chart in chart type
Step 8: Go to customize and change the border to None
Step 9: Change the background color to none.
Also, you can remove the legends to make the charts less congested.
Step 10: Resize the second pie chart to fit into the first one.
How to Customize / Edit a Pie Chart in Google Sheets
Now that the basic pie chart is ready, let us see how to edit and customize it according to your liking. All customization options for your chart are available in one place – the Chart editor. Using this sidebar, you can style your chart, customize the pie chart, change the pie slices, change the titles, add labels, and more.
Let us see some of these customization options in a little more detail.
Note: If you cannot see the Chart editor sidebar, simply double click on the blank area of the chart, or click on the chart, click on the ellipsis button that appears (three dots) on the top-right corner of the chart, and then select ‘Edit chart’ from the context menu that appears.
To customize the chart style, select the Customize tab of the Chart editor. Then click on the Chart style section.
This section gives you options to change the background and border color of the chart, as well as change the chart font. There’s also an option to convert the chart into a 3D pie chart, as shown below:
To customize the pie chart, select Customize tab ->Pie Chart from the chart editor.
This section lets you add labels to each slice of the pie chart, format the labels, as well as convert the chart to a doughnut chart.
If converting to a doughnut chart, you also have the option to change the size of the doughnut hole according to your liking. For example, in the image shown below, we specified that we want the doughnut hole to take up 25% of the pie chart’s center. We also added labels to each slice to show the revenue value corresponding to each slice:
This section lets you customize individual slices of the pie. There are a number of pie slice options. For example, you can change the color of each pie slice from this section. You can also separate out individual slices and set the distance of the slice from the center. This makes it seem like the slice is breaking off from the main pie.
For example, we changed the color of the North slice to ‘Light Magenta 3’ and made it separate out to a distance of 25% from the main pie, as shown below:
Chart & Axis Titles
This section allows you to change the chart title (and subtitle) as well as its font style, size, color, and style. For example, we changed the chart title text to ‘Pie chart of Region-wise Revenue’. We changed its font style to ‘Sans Serif’ and its font size to 16, as shown below:
In your chart, you have a Google pie chart legend with values. This section lets you format the chart legend and change its position in the chart. For example, we changed the legend position to the Right of the chart and changed its font style to ‘Sans Serif’, as shown below:
Changing the Data Range
In the chart editor, you can also change the data range of your Google Sheets pie chart. You can do this by inputting your new range in the option for data range. The pie chart will update to represent data from the new range that you have chosen.
If you select a data range with multiple columns of data, then you can choose which column you want to represent in your pie chart in the chart editor in the drop-down menu for value.
For example, in our chart, we selected the data range B14 to E24, which has 4 columns.
In the chart editor pane, click the Value option. You will get a list of options for the columns you have in your data range. You can choose any one of them to be represented by your pie chart and change it if you need to.
Additional Pie Chart Options
Clicking on the chart and then the ellipsis button gives you other chart options that you can select if you want to further perform additional actions. For example, there are options to publish the chart, download it, copy, move and delete it as well.
Moreover, the Setup tab of the Chart editor has more options. For example, you have the option to change the data source for the chart, switch rows and columns, and more.
Hot to Create a Pie Chart in Google Sheets on Android
You can also use Google Sheets on your mobile phone using the sheets app. Here’s how to create pie chart in Google Sheets on Android.
Step 1: Select the columns for your data
Step 2: Tap the plus (+) sign at the top
Step 3: In the Insert menu, click Chart
Step 4: Tap chart type to change the chart from a column to a pie chart type.
Step 4: Choose the type of pie chart you want
Step 5: Tap the tick at the top left corner
How do I make a pie chart in Google Sheets?
Making a pie chart in Google Sheets is a simple process. To make a pie chart in Google Sheets, click on the Insert menu and then select Chart from the dropdown list that appears.
How do you set up a pie chart?
To set up a pie chart, double click on the chart or click on the ellipsis (three dots), followed by ‘Edit chart’. This displays the Chart editor sidebar to the right of the browser window. Select the Setup tab from the chart editor. You can now see all the options to set up your pie chart..
What is a pie chart with examples?
A pie chart is a visualization tool that lets you express a variable as parts of a whole. For example, you can express how much time different members of the team contributed to a project using a pie chart Google Sheets.
How do I label a pie chart in Google Sheets?
To label a pie chart, select the Customize tab from the Chart editor. Click on the Pie chart section to open it and then click on the drop-down list under Slice label. You can select the type of label you want for your pie chart, as well as the format, and font for the labels from here.
The pie chart is a frequently used visualization tool, so it’s a good idea to familiarize yourself with everything there is to know about it.
In this tutorial, we discussed what a pie chart is, what it is used for, and how to make a Pie Chart in Google Sheets. We also discussed how to use the Chart editor sidebar to customize your pie chart according to your requirements. So can you make a pie chart in Google Sheets?, this article should answer your question. You can also find out about how to make a combo chart in Google Sheets.