Table of Contents
Creating a pie chart in Google Sheets is a simple and effective way to visually represent data and make it easier to understand. To create a pie chart, first input the data into a spreadsheet in Google Sheets. Then, select the data and click on the “Insert” tab, followed by “Chart.” From the chart options, choose the “Pie” chart and customize it to your preferences. For example, you can change the chart title, add a legend, and adjust the colors. Once the chart is created, it will automatically update if any changes are made to the data. This allows for a dynamic and interactive representation of the data.
Create a Pie Chart in Google Sheets (With Example)
A pie chart is a type of chart that is shaped like a circle and uses slices to represent proportions of a whole.
The following step-by-step example shows how to create a pie chart in Google Sheets.
Step 1: Enter the Data
First, let’s enter some data that shows the total sales for 6 different products:
Step 2: Create the Pie Chart
Next, highlight the values in the range A1:B7. Then click the Insert tab and then click Chart:
The following pie chart will automatically be inserted:
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:
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.
Next, we can click Pie slice and change the individual colors of the slices in the chart if we’d like:
Next, we can click Chart & axis titles and change the Chart title to whatever we’d like:
Next, we can click Legend and change the Position to wherever we’d like:
The final pie chart looks like this:
The following tutorials explain how to create other common charts in Google Sheets:
Cite this article
stats writer (2024). How can I create a pie chart in Google Sheets with an example?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-create-a-pie-chart-in-google-sheets-with-an-example/
stats writer. "How can I create a pie chart in Google Sheets with an example?." PSYCHOLOGICAL SCALES, 15 May. 2024, https://scales.arabpsychology.com/stats/how-can-i-create-a-pie-chart-in-google-sheets-with-an-example/.
stats writer. "How can I create a pie chart in Google Sheets with an example?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-create-a-pie-chart-in-google-sheets-with-an-example/.
stats writer (2024) 'How can I create a pie chart in Google Sheets with an example?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-create-a-pie-chart-in-google-sheets-with-an-example/.
[1] stats writer, "How can I create a pie chart in Google Sheets with an example?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, May, 2024.
stats writer. How can I create a pie chart in Google Sheets with an example?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.