HomeGoogleGoogle SheetsAnalyze Data With Pie Charts

13.16. Analyze Data With Pie Charts

Directions: There are four options to view the resources below: try it, view it, watch it, or print it. Click the drop down menu titled "Try-it interactive" to select your preferred viewing method. Then, click start.


14 STEPS

1. The first step is to open Google Drive, then select the Google Sheet you want to create a Pie Chart in. In this case, we will be creating a Pie Chart based on responses in column G.

Step 1 image

2. Select the cells that you would like to create a pie chart based on.

Step 2 image

3. Click Insert

Step 3 image

4. Click Chart

Step 4 image

5. Google Sheets has automatically guess that I want a bar chart.

Step 5 image

6. To change this from a bar graph, Click Chart Type: Column chart in the dropdown menu at right.

Step 6 image

7. Scroll down and click Pie.

Step 7 image

8. I now see my Pie chart, but it's not labelled right. Click to highlight the chart

Step 8 image

9. Click Pie chart at right.

Step 9 image

10. Click the dropdown menu under Slice Label to change how each pie slice is labelled.

Step 10 image

11. We will choose Value, as we want each pie slice to reflect the ratings from our students.

Step 11 image

12. Click Close

Step 12 image

13. I now see my chart labels, their corresponding percentages, and can drag and drop my chart as needed in the sheet.

Step 13 image

14. Scroll undefined and that's it. You're done.

Step 14 image

Here's an interactive tutorial

https://www.iorad.com/player/1739619/Docs-Google---How-to-untitled-task-name



Downloads

Knowledge Tags