Google Sheets Pie Chart

What Is Pie Chart In Google Sheets?

Pie chart in Google sheets is one of the inbuilt charts used to represent the data. Using pie chart, we can show the data based on different factors in multiple slices to visually represent the numerical proportions.

There are three types of pie chart in Google sheets, such as 2D pie chart, 3D pie chart and doughnut chart. Similarly, Google spreadsheets enables users to edit the pie chart like changing colors, customizing chart etc., For example, consider the below table showing subjects and marks obtained by a student in an examination.

Now, let us learn how to create pie chart in Google sheets. To begin with, insert the data in the spreadsheet. Next, select the data and click on Insert Tab and then, click on Pie chart.

We will be able to see the pie chart for the given data as shown in the below image.

In this article, let us learn how to create pie charts in Google sheets with detailed examples.

How To Make A Pie Chart In Google Sheets?

We can create pie charts in Google sheets easily without any add-ons or extensions. In Google sheets, we can create three kind of charts such as

• 2D Pie chart
• 3D Pie Chart
• Doughnut Chart

Let us learn how to make pie chart in Google sheets in all of the three types with examples.

#1 – 2D Pie Chart

For example, consider the below table showing name and age of various employees in an organization in columns A and B, respectively.

Now, let us learn how to create 2D pie chart in Google sheets with the following steps.

The steps are:

Step 1: To begin with, we need to insert the data in the Google spreadsheets. In this example, the data is available in the spreadsheet A1:B10. Next, we need to select the cell range in the spreadsheet. In this example, we need to select the cell range A1:B10.

Step 2: Next, click on the Insert tab and click on Chart option.

Step 3: Now, we will be able to see the Chart Editor window at the right-end of the screen. Here, click on 2D Pie Chart under the Chart Type option.

We will be able to see the Pie chart for the given data as shown in the below image.

Likewise, we can create 2D pie chart in Google sheets.

#2 – 3D Pie Chart

For better understanding, let us use the same example we used for 2D pie chart.

Consider the below table showing name and age of various employees in an organization in columns A and B, respectively.

Now, let us learn how to create 3D pie chart in Google sheets with the following steps.

The steps are:

Step 1: To begin with, we need to insert the data in the Google spreadsheets. In this example, the data is available in the spreadsheet A1:B10. Next, we need to select the cell range in the spreadsheet. In this example, we need to select the cell range A1:B10.

Step 2: Next, click on the Insert tab and click on Chart option.

Step 3: Now, we will be able to see the Chart Editor window at the right-end of the screen. Here, click on 3D Pie Chart under the Chart Type option.

We will be able to see the Pie chart for the given data as shown in the below image.

Likewise, we can create 3D pie chart in Google sheets.

#3 – Doughnut Chart

For example, consider the below table showing product and quantity of various products in a shop in columns A and B, respectively.

Now, let us learn how to create doughnut chart in Google sheets with the following steps.

The steps are:

Step 1: To begin with, we need to insert the data in the Google spreadsheets. In this example, the data is available in the spreadsheet A1:B10. Next, we need to select the cell range in the spreadsheet. In this example, we need to select the cell range A1:B10.

Step 2: Next, click on the Insert tab and click on Chart option.

Step 3: Now, we will be able to see the Chart Editor window at the right-end of the screen. Here, click on doughnut Chart under the Chart Type option.

We will be able to see the Pie chart for the given data as shown in the below image.

Likewise, we can create doughnut chart in Google sheets.

Similarly, we can create any of the three available pie chart.

Customizing A Google Sheets Pie Chart

Let us learn how to customize a pie chart in Google sheets.

For example, consider the below table showing items and quantity of various electronic items of a shop in columns A and B, respectively.

Now, let us learn how to create pie chart with the following steps.

The steps are:

Step 1: To begin with, we need to insert the data in the Google spreadsheets. In this example, the data is available in the spreadsheet A1:B10. Next, we need to select the cell range in the spreadsheet. In this example, we need to select the cell range A1:B10.

Step 2: Next, click on the Insert tab and click on Chart option.

Step 3: Now, we will be able to see the Chart Editor window at the right-end of the screen. Here, click on Pie Chart under the Chart Type option.

We will be able to see the Pie chart for the given data as shown in the below image.

Likewise, we can create 2D pie chart.

Now, let us learn how to customize the table with the following options.

-Adding Data Labels

We can add labels in our pie chart with the following steps.

Step 1: We need to create a pie chart.

Step 2: After creating pie chart, we need to double click on the chart or click on the three dots option in the chart.

Step 3: We will be able to see the Chart Editor window.

Here, click on Labels and select the available options to change the pie chart type.

Since the chart label is selected as ‘Label’, let us select the label as ‘Quantity’.

We will be able to see the pie chart converted based on the quantity, as shown in the below image.

Likewise, we can add labels and edit the pie chart. 

Changing Colors

Now, let us learn how to change colors.

The steps are:

Step 1: We need to create a pie chart.

Step 2: After creating a pie chart, we need to double click on the chart. Else click on the three dots option in the chart.

Step 3: We will be able to see the Chart Editor window.

Here, click on Customize and select the Chart style option.

As we can see, there are options to change the chart outline color and background style.

Similarly, we can change the color of each of the slice in pie charts under the Pie slice option, found under Customize tab.

Now, let us change the color of the background, outline and slice color of ‘Speakers’, as shown in the below image.

Exploding A Pie Chart

Exploding pie chart is nothing but taking a slice in pie chart apart from the diameter.

The steps are:

Step 1: Simply, click on the created chart and then, select Customize option in the Chart Editor window.

Step 2: Next, click on Pie Slice option. Under the ‘Color’ option, we will be able to see Distance from center option, as shown in the below image.

Step 3: Change the percentage of option and we will be able to see the slice getting apart in Google sheets.

In this example, let us select the slice ‘Speakers’ and change the distance from center option to 25%.

We will be able to see the slice apart from the pie chart as shown in the below image.

Similarly, we can change the distance till 100% to explode the pie chart.

-Rotating A Pie Chart

We can rotate pie chart by simply selecting the chart and clicking on Setup option. Now, we can click on Switch Row as headers option to see the difference in pie chart in Google sheets.

-Sorting Slices By Size

We can sort the slice in pie chart by arranging the data using SORT or SORTN functions in Google sheets. By using the function, we can sort the pie chart, as shown in the below image.

-Formatting 0ptions

There are many formatting options in Google sheets which we have not discussed in the article.

For example, using the Chart & Axis Titles, we can change the font and font color of the chart, as shown in the below image.

Likewise, we can format the pie chart using the chart & axis titles under the customize option.

How To Make A Pie Chart In Google Sheets With Data From Multiple Sheets?

To create a pie chart with data from multiple sheets, we need to use the IMPORTRANGE formula.

The steps are:

Step 1: Open the sheet where we have the data.

Step 2: Using the IMPORTRANGE function, click on the sheet name and press Enter key.

And then, we need to select the range, click on Insert tab and Chart option to create pie chart.

Important Things To Note

• Pie chart is a default option used to present our data in a ‘pie’ shaped chart.
• We can change the color of the pie chart under the Customize option.
• Remember, to format the font or font color, we need to click on the Customize option under the chart editor window and click on the Chart & axis title to format the text and appearance of the pie chart.

Frequently Asked Questions (FAQs)

Download Template

This article must help understand Google Sheets Pie Chart with its formula and examples. You can download the template here to use it instantly.

Recommended Articles

Guide to What Is Google Sheets Pie Chart. We learn how to make different types of pie charts and customize them with step-wise examples. You can learn more from the following articles –

Pareto Chart In Google Sheets

COMPLEX Function In Google Sheets

ISBLANK In Google Sheets