How to create a pie graph in google sheets

  • Home
  • Productivity

Using a pie chart is one of the best ways to present your data visually. Here's how to make one in Google Sheets.

How to create a pie graph in google sheets

Step 2: Create the Pie Chart

Next, highlight the values in the range A1:B7. Then click the Insert tab and then click Chart:

How to create a pie graph in google sheets

The following pie chart will automatically be inserted:

How to create a pie graph in google sheets

Step 3: Customize the Pie Chart

To customize the pie chart, click anywhere on the chart. Then click the three vertical dots in the top right corner of the chart. Then click Edit chart:

How to create a pie graph in google sheets

In the Chart editor panel that appears on the right side of the screen, click the Customize tab to see a variety of options for customizing the chart.

First, we can click Pie chart and change the Slice label to Percentage.

How to create a pie graph in google sheets

Next, we can click Pie slice and change the individual colors of the slices in the chart if we’d like:

How to create a pie graph in google sheets

Next, we can click Chart & axis titles and change the Chart title to whatever we’d like:

How to create a pie graph in google sheets

Next, we can click Legend and change the Position to wherever we’d like:

How to create a pie graph in google sheets

The final pie chart looks like this:

How to create a pie graph in google sheets

Additional Resources

The following tutorials explain how to create other common charts in Google Sheets:

How to Make a Box Plot in Google Sheets
How to Create a Bubble Chart in Google Sheets
How to Create a Pareto Chart in Google Sheets
How to Create a Candlestick Chart in Google Sheets

How do I make a pie chart with two sets of data in Google Sheets?

Create a Chart with Multiple Ranges of Data.
Step 1: Format your data into rows and columns so a chart can be created. ... .
Step 2: Select the data to be included in the chart, with the headings included..
Step 3: Click Insert in the file menu, then click Chart. ... .
Step 4: Format your Newly Created Chart in the Chart Editor..

How do I create a pie chart with categories and percentages in Google Sheets?

How to Create a Pie Chart in Google Sheets.
Insert data range. The first step is to insert all your data onto Google Sheets. ... .
Click Chart. Once you have added your data, click the Insert tab on top. ... .
Click Pie Chart on Chart Editor. ... .
Select data and your pie chart will appear..

How do I add percentages to a pie chart in Google Sheets?

Pie Chart – Show Percentage – Excel & Google Sheets.
Add Data Labels. Click on the chart. ... .
Change to Percentage. This will show the “Values” of the data labels. ... .
Right click on the new labels. Select Format Data Labels..
Uncheck box next to Value. ... .
Final Graph with Percentage. ... .
Adding Percentages to a Pie Chart In Google Sheets..