How to Create a Pie Chart in Google Sheets

Quick Guide

• First, input the series of data you want to visualize in a pie chart.
• Go to “Insert” and click ”Chart”.
• You will have a default chart on your worksheet, and a chart editor shows up on the right.
• Navigate to “Setup” on the chart editor.
• Go to ”Chart type” and select “Pie Chart”.
• You also have to select a range of labels (names of each category) for the “Label” section.
• Go to the “Customize” tab in the chart editor and customize your chart if you want.

What is a Pie Chart

A pie chart is a circular form of graph. The slices of pie in the chart shows the estimated size of the data. It is used to put your data in a pictorial form. Pie charts have a way of visualizing your data for easy analysis by whoever you share the data with

How to Create a Pie Chart in Google Sheets

#1. Inserting a Pie Chart

• Input the series of data you want to visualize in a pie chart.
  
• Go to “Insert” and click ”Chart”. You will have a default chart on your worksheet, and a chart editor shows up on the right.
  
• Navigate to “Setup” on the chart editor.
• Go to ”Chart type” and select “Pie Chart”.
• You also have to select a range of labels (names of each category) for the “Label” section.

#2. Customizing the Pie Chart

Go to the “Customize” tab in the chart editor and customize your chart if you want.

You can customize and edit a ton of options on your chart. You can change the colors, make the chart look like 3D, add a legend, change around the titles and labels, add a donut hole, change the background color, the border color or set the chart border color to ‘none’.

Interpreting a Pie Chart

Once you have created your Pie chart and customized it to suit your taste, interpret it by looking at the labels and the slices of pie to see the figures they represent.

Sharing and Exporting Your Pie Chart

To share the pie chart, click on the “Share” button. You can add the email addresses you want to share your Sheet with. Or copy the link and send it to whoever you want to share with.

Or click the Chart, and select the three vertical menu. Select “Publish Chart”, and select to Publish the Sheet to the web.

FAQs

How Can I Display Values on a Google Sheets Pie Chart?

To display values in Google Sheets, follow these steps:

• Select the Pie Chart in Google Sheets.
• Click on the 3-dot menu on the top right side of the chart, or double-click the chart to go to the “Chart Editor“.
• In the “Customize” tab, select “Data Labels“.
• Select the data label options you want to use from the drop-down menu and click OK.

Is it Possible to Create a Multi-level Pie Chart in Google Sheets?

A multi-level pie chart which can also be called a sunburst chart or nested pie chart is a set of concentric circles that allow to visualize symmetrical and asymmetrical tree structures in a pie chart. You can create a multi-level pie chart in Google Sheets by stacking separate doughnut charts on top of each other using the customization tool in your Google Sheets.

Here’s how to:

First prepare your Data in Google Sheets. Create the first doughnut chart that will act as the outer layer of the multi level pie chart.

• Highlight the data set, navigate to the Insert tab, and select “Chart.”
• Pie chart will appear with the Chart editor task pane by its side.
• Go to the Setup tab of the Chart editor, and open the “Chart type” drop-down menu.
• Scroll down the drop down menu and under “Pie”, select “Doughnut chart.”
• Increase the size of the donut hole to accommodate the smaller inner layer inside it.
• Then switch to the Chart editor, and select Customize
• Go to the “Pie chart” section
• Set the “Donut hole” value to “75%” to modify the amount of empty space in the middle of our doughnut chart.
• Then remove the background of the chart area to seamlessly stack two doughnut charts on top of each other.
• Then go to the “Chart style” section.
• Under “Background color,” pull up the color palette and choose “None” to remove the background of your chart.

Can I Create Both Pie and Line Charts in Google Sheets?

No, the pie and line chart combo is not available in Google Sheets.